每日总结28

USE [sale]
GO
/****** Object: Table [dbo].[F_CLASS] Script Date: 2024/12/24 11:52:12 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[F_CLASS](
[ID] [int] IDENTITY(1,1) NOT NULL,
[品牌名称] [nvarchar](50) NOT NULL,
[颜色货号锁定] [bit] NULL,
CONSTRAINT [PK_F_CLASS] PRIMARY KEY CLUSTERED
(
[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[F_INCOME] Script Date: 2024/12/24 11:52:12 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[F_INCOME](
[ID] [int] IDENTITY(1,1) NOT NULL,
[进货批次] [nvarchar](50) NOT NULL,
[品牌] [int] NOT NULL,
[货号] [nvarchar](50) NOT NULL,
[颜色] [int] NOT NULL,
[尺寸] [int] NULL,
[类型] [int] NOT NULL,
[季节] [int] NOT NULL,
[进货数量] [int] NOT NULL,
[吊牌价] [decimal](18, 2) NOT NULL,
[进货价] [decimal](18, 2) NOT NULL,
[备注] [nvarchar](500) NULL,
[录入人员] [int] NOT NULL,
[录入时间] [datetime] NOT NULL,
CONSTRAINT [PK_F_INCOME] PRIMARY KEY CLUSTERED
(
[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[F_KCTZ] Script Date: 2024/12/24 11:52:12 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[F_KCTZ](
[ID] [int] IDENTITY(1,1) NOT NULL,
[调整日期] [datetime] NOT NULL,
[货号] [nvarchar](50) NOT NULL,
[颜色] [int] NOT NULL,
[尺寸] [int] NULL,
[数量] [int] NOT NULL,
[对方] [nvarchar](50) NULL,
[调整责任人] [int] NULL,
[调整理由] [int] NOT NULL,
[录入人员] [int] NOT NULL,
[录入时间] [datetime] NOT NULL,
[备注] [nvarchar](500) NULL,
CONSTRAINT [PK_F_KCTZ] PRIMARY KEY CLUSTERED
(
[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[F_PEND] Script Date: 2024/12/24 11:52:12 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[F_PEND](
[ID] [int] IDENTITY(1,1) NOT NULL,
[费用描述] [int] NOT NULL,
[支出时间] [datetime] NOT NULL,
[金额] [decimal](18, 2) NOT NULL,
[录入时间] [datetime] NOT NULL,
[录入人员] [int] NOT NULL,
[备注] [nvarchar](50) NOT NULL,
CONSTRAINT [PK_F_PEND] PRIMARY KEY CLUSTERED
(
[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[F_S_CLOTHTYPE] Script Date: 2024/12/24 11:52:12 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[F_S_CLOTHTYPE](
[ID] [int] IDENTITY(1,1) NOT NULL,
[类别] [nvarchar](50) NOT NULL,
[父类ID] [int] NOT NULL,
CONSTRAINT [PK_F_CLOTHTYPE] PRIMARY KEY CLUSTERED
(
[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[F_S_COLOR] Script Date: 2024/12/24 11:52:12 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[F_S_COLOR](
[ID] [int] IDENTITY(1,1) NOT NULL,
[颜色] [nvarchar](50) NOT NULL,
[颜色代码] [int] NOT NULL,
CONSTRAINT [PK_F_COLOR] PRIMARY KEY CLUSTERED
(
[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[F_S_KCTZTYPE] Script Date: 2024/12/24 11:52:12 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[F_S_KCTZTYPE](
[ID] [int] IDENTITY(1,1) NOT NULL,
[调整理由描述] [nvarchar](50) NOT NULL,
CONSTRAINT [PK_F_S_BECAUSE] PRIMARY KEY CLUSTERED
(
[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[F_S_PENDTYPE] Script Date: 2024/12/24 11:52:12 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[F_S_PENDTYPE](
[ID] [int] IDENTITY(1,1) NOT NULL,
[支出理由] [nvarchar](50) NOT NULL,
CONSTRAINT [PK_F_S_PENDTYPE] PRIMARY KEY CLUSTERED
(
[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[F_S_SEASON] Script Date: 2024/12/24 11:52:12 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[F_S_SEASON](
[ID] [int] IDENTITY(1,1) NOT NULL,
[季节名称] [nvarchar](50) NOT NULL,
[季节年份] [int] NOT NULL,
CONSTRAINT [PK_F_SEASON] PRIMARY KEY CLUSTERED
(
[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[F_S_SIZE] Script Date: 2024/12/24 11:52:12 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[F_S_SIZE](
[id] [int] IDENTITY(1,1) NOT NULL,
[尺寸] [nvarchar](50) NULL,
[描述] [nvarchar](50) NOT NULL,
CONSTRAINT [PK_F_SIZE] PRIMARY KEY CLUSTERED
(
[id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[F_S_USER] Script Date: 2024/12/24 11:52:12 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[F_S_USER](
[id] [int] IDENTITY(1,1) NOT NULL,
[名称] [nvarchar](50) NOT NULL,
[类型] [nvarchar](50) NOT NULL,
[权限] [nvarchar](50) NOT NULL,
[密码] [nvarchar](50) NOT NULL,
CONSTRAINT [PK_F_USER] PRIMARY KEY CLUSTERED
(
[id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[F_SALE] Script Date: 2024/12/24 11:52:12 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[F_SALE](
[ID] [int] IDENTITY(1,1) NOT NULL,
[销售日期] [datetime] NOT NULL,
[货号] [nvarchar](50) NOT NULL,
[颜色] [int] NOT NULL,
[尺寸] [int] NULL,
[数量] [int] NOT NULL,
[开票价] [decimal](18, 2) NOT NULL,
[活动优惠] [int] NOT NULL,
[销售员] [int] NOT NULL,
[录入人员] [int] NOT NULL,
[录入时间] [datetime] NOT NULL,
[备注] [nvarchar](500) NULL,
CONSTRAINT [PK_F_SALE] PRIMARY KEY CLUSTERED
(
[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[F_STOCKS] Script Date: 2024/12/24 11:52:12 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[F_STOCKS](
[ID] [int] IDENTITY(1,1) NOT NULL,
[货号] [nvarchar](50) NOT NULL,
[颜色] [int] NOT NULL,
[尺寸] [int] NULL,
[类型] [int] NOT NULL,
[品牌] [int] NOT NULL,
[库存量] [int] NULL,
[季节] [int] NULL,
CONSTRAINT [PK_F_STOCKS] PRIMARY KEY CLUSTERED
(
[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[F_VIP] Script Date: 2024/12/24 11:52:12 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[F_VIP](
[ID] [int] IDENTITY(1,1) NOT NULL,
[优惠名称] [nvarchar](50) NOT NULL,
[优惠描述] [nvarchar](500) NULL,
CONSTRAINT [PK_F_VIP] PRIMARY KEY CLUSTERED
(
[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[F_INCOME] WITH CHECK ADD CONSTRAINT [FK_F_INCOME_F_CLASS] FOREIGN KEY([品牌])
REFERENCES [dbo].[F_CLASS] ([ID])
GO
ALTER TABLE [dbo].[F_INCOME] CHECK CONSTRAINT [FK_F_INCOME_F_CLASS]
GO
ALTER TABLE [dbo].[F_INCOME] WITH CHECK ADD CONSTRAINT [FK_F_INCOME_F_S_CLOTHTYPE] FOREIGN KEY([类型])
REFERENCES [dbo].[F_S_CLOTHTYPE] ([ID])
GO
ALTER TABLE [dbo].[F_INCOME] CHECK CONSTRAINT [FK_F_INCOME_F_S_CLOTHTYPE]
GO
ALTER TABLE [dbo].[F_INCOME] WITH CHECK ADD CONSTRAINT [FK_F_INCOME_F_S_COLOR] FOREIGN KEY([颜色])
REFERENCES [dbo].[F_S_COLOR] ([ID])
GO
ALTER TABLE [dbo].[F_INCOME] CHECK CONSTRAINT [FK_F_INCOME_F_S_COLOR]
GO
ALTER TABLE [dbo].[F_INCOME] WITH CHECK ADD CONSTRAINT [FK_F_INCOME_F_S_SEASON] FOREIGN KEY([季节])
REFERENCES [dbo].[F_S_SEASON] ([ID])
GO
ALTER TABLE [dbo].[F_INCOME] CHECK CONSTRAINT [FK_F_INCOME_F_S_SEASON]
GO
ALTER TABLE [dbo].[F_INCOME] WITH CHECK ADD CONSTRAINT [FK_F_INCOME_F_S_SIZE] FOREIGN KEY([尺寸])
REFERENCES [dbo].[F_S_SIZE] ([id])
GO
ALTER TABLE [dbo].[F_INCOME] CHECK CONSTRAINT [FK_F_INCOME_F_S_SIZE]
GO
ALTER TABLE [dbo].[F_INCOME] WITH CHECK ADD CONSTRAINT [FK_F_INCOME_F_S_USER] FOREIGN KEY([录入人员])
REFERENCES [dbo].[F_S_USER] ([id])
GO
ALTER TABLE [dbo].[F_INCOME] CHECK CONSTRAINT [FK_F_INCOME_F_S_USER]
GO
ALTER TABLE [dbo].[F_KCTZ] WITH CHECK ADD CONSTRAINT [FK_F_KCTZ_F_S_COLOR] FOREIGN KEY([颜色])
REFERENCES [dbo].[F_S_COLOR] ([ID])
GO
ALTER TABLE [dbo].[F_KCTZ] CHECK CONSTRAINT [FK_F_KCTZ_F_S_COLOR]
GO
ALTER TABLE [dbo].[F_KCTZ] WITH CHECK ADD CONSTRAINT [FK_F_KCTZ_F_S_KCTZTYPE] FOREIGN KEY([调整理由])
REFERENCES [dbo].[F_S_KCTZTYPE] ([ID])
GO
ALTER TABLE [dbo].[F_KCTZ] CHECK CONSTRAINT [FK_F_KCTZ_F_S_KCTZTYPE]
GO
ALTER TABLE [dbo].[F_KCTZ] WITH CHECK ADD CONSTRAINT [FK_F_KCTZ_F_S_SIZE] FOREIGN KEY([尺寸])
REFERENCES [dbo].[F_S_SIZE] ([id])
GO
ALTER TABLE [dbo].[F_KCTZ] CHECK CONSTRAINT [FK_F_KCTZ_F_S_SIZE]
GO
ALTER TABLE [dbo].[F_KCTZ] WITH CHECK ADD CONSTRAINT [FK_F_KCTZ_F_S_USER] FOREIGN KEY([录入人员])
REFERENCES [dbo].[F_S_USER] ([id])
GO
ALTER TABLE [dbo].[F_KCTZ] CHECK CONSTRAINT [FK_F_KCTZ_F_S_USER]
GO
ALTER TABLE [dbo].[F_PEND] WITH CHECK ADD CONSTRAINT [FK_F_PEND_F_S_PENDTYPE] FOREIGN KEY([费用描述])
REFERENCES [dbo].[F_S_PENDTYPE] ([ID])
GO
ALTER TABLE [dbo].[F_PEND] CHECK CONSTRAINT [FK_F_PEND_F_S_PENDTYPE]
GO
ALTER TABLE [dbo].[F_PEND] WITH CHECK ADD CONSTRAINT [FK_F_PEND_F_S_USER] FOREIGN KEY([录入人员])
REFERENCES [dbo].[F_S_USER] ([id])
GO
ALTER TABLE [dbo].[F_PEND] CHECK CONSTRAINT [FK_F_PEND_F_S_USER]
GO
ALTER TABLE [dbo].[F_SALE] WITH CHECK ADD CONSTRAINT [FK_F_SALE_F_S_COLOR] FOREIGN KEY([颜色])
REFERENCES [dbo].[F_S_COLOR] ([ID])
GO
ALTER TABLE [dbo].[F_SALE] CHECK CONSTRAINT [FK_F_SALE_F_S_COLOR]
GO
ALTER TABLE [dbo].[F_SALE] WITH CHECK ADD CONSTRAINT [FK_F_SALE_F_S_SIZE] FOREIGN KEY([尺寸])
REFERENCES [dbo].[F_S_SIZE] ([id])
GO
ALTER TABLE [dbo].[F_SALE] CHECK CONSTRAINT [FK_F_SALE_F_S_SIZE]
GO
ALTER TABLE [dbo].[F_SALE] WITH CHECK ADD CONSTRAINT [FK_F_SALE_F_S_USER] FOREIGN KEY([录入人员])
REFERENCES [dbo].[F_S_USER] ([id])
GO
ALTER TABLE [dbo].[F_SALE] CHECK CONSTRAINT [FK_F_SALE_F_S_USER]
GO
ALTER TABLE [dbo].[F_SALE] WITH CHECK ADD CONSTRAINT [FK_F_SALE_F_VIP] FOREIGN KEY([活动优惠])
REFERENCES [dbo].[F_VIP] ([ID])
GO
ALTER TABLE [dbo].[F_SALE] CHECK CONSTRAINT [FK_F_SALE_F_VIP]
GO
ALTER TABLE [dbo].[F_STOCKS] WITH CHECK ADD CONSTRAINT [FK_F_STOCKS_F_CLASS] FOREIGN KEY([品牌])
REFERENCES [dbo].[F_CLASS] ([ID])
GO
ALTER TABLE [dbo].[F_STOCKS] CHECK CONSTRAINT [FK_F_STOCKS_F_CLASS]
GO
ALTER TABLE [dbo].[F_STOCKS] WITH CHECK ADD CONSTRAINT [FK_F_STOCKS_F_S_CLOTHTYPE] FOREIGN KEY([类型])
REFERENCES [dbo].[F_S_CLOTHTYPE] ([ID])
GO
ALTER TABLE [dbo].[F_STOCKS] CHECK CONSTRAINT [FK_F_STOCKS_F_S_CLOTHTYPE]
GO
ALTER TABLE [dbo].[F_STOCKS] WITH CHECK ADD CONSTRAINT [FK_F_STOCKS_F_S_COLOR] FOREIGN KEY([颜色])
REFERENCES [dbo].[F_S_COLOR] ([ID])
GO
ALTER TABLE [dbo].[F_STOCKS] CHECK CONSTRAINT [FK_F_STOCKS_F_S_COLOR]
GO
ALTER TABLE [dbo].[F_STOCKS] WITH CHECK ADD CONSTRAINT [FK_F_STOCKS_F_S_SIZE1] FOREIGN KEY([尺寸])
REFERENCES [dbo].[F_S_SIZE] ([id])
GO
ALTER TABLE [dbo].[F_STOCKS] CHECK CONSTRAINT [FK_F_STOCKS_F_S_SIZE1]
GO