USE WB19013 GO /*==============================================================*/ /* Table: StockClearLog */ /* Description: 软件过期表 */ /* Author:shaocx */ /* CreateTime:2021-02-23 */ /*==============================================================*/ IF NOT EXISTS( SELECT 1 FROM SYSOBJECTS WHERE ID = OBJECT_ID('SoftDue') AND TYPE = 'U') create table SoftDue( ID int IDENTITY(1,1) NOT NULL, -- 主键 DuePass NVARCHAR(128) NOT NULL , -- 密码 DueDay NVARCHAR(128) NOT NULL , -- 过期天数 IsCompleted char(1) NULL , -- 是否完成( 0 未完成 1 已完成) Remark NVARCHAR(128) NULL , -- 备注(清理缘由) Creator varchar(128) null,-- 创建人 CreateTime datetime null, -- 创建时间 LastModifier varchar(128) null,-- 修改人 LastModifyTime datetime null -- 修改时间 constraint PK_SoftDue primary key (ID) ) GO /*==============================================================*/ /* Table: StockClearLog */ /* Description: 库存清理日志表 */ /* Author:shaocx */ /* CreateTime:2021-02-23 */ /*==============================================================*/ IF NOT EXISTS( SELECT 1 FROM SYSOBJECTS WHERE ID = OBJECT_ID('StockClearLog') AND TYPE = 'U') create table StockClearLog( ID int IDENTITY(1,1) NOT NULL, -- 主键 PlaceNo NVARCHAR(128) NOT NULL , -- 库位号 StoreNo INT NOT NULL , -- 仓库号 CarType VARCHAR(50) NULL , -- 车型 MouldId NVARCHAR(50) NULL , -- 模具ID PartName NVARCHAR(50) NULL , -- 零件名称 PartId NVARCHAR(50) NULL , -- 零件编号 IsLock char(1) NULL , -- 是否锁定 Remark NVARCHAR(128) NULL , -- 备注(清理缘由) Creator varchar(128) null,-- 创建人 CreateTime datetime null, -- 创建时间 LastModifier varchar(128) null,-- 修改人 LastModifyTime datetime null -- 修改时间 constraint PK_StockClearLog primary key (ID) ) GO SET ANSI_PADDING OFF GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'主键' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'StockClearLog', @level2type=N'COLUMN',@level2name=N'ID' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'库位号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'StockClearLog', @level2type=N'COLUMN',@level2name=N'PlaceNo' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'仓库号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'StockClearLog', @level2type=N'COLUMN',@level2name=N'StoreNo' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'车型' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'StockClearLog', @level2type=N'COLUMN',@level2name=N'CarType' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'模具ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'StockClearLog', @level2type=N'COLUMN',@level2name=N'MouldId' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'零件名称' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'StockClearLog', @level2type=N'COLUMN',@level2name=N'PartName' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'零件编号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'StockClearLog', @level2type=N'COLUMN',@level2name=N'PartId' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'是否锁定' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'StockClearLog', @level2type=N'COLUMN',@level2name=N'IsLock' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'创建人' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'StockClearLog', @level2type=N'COLUMN',@level2name=N'Creator' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'创建时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'StockClearLog', @level2type=N'COLUMN',@level2name=N'CreateTime' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'修改人' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'StockClearLog', @level2type=N'COLUMN',@level2name=N'LastModifier' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'修改时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'StockClearLog', @level2type=N'COLUMN',@level2name=N'LastModifyTime' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'备注' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'StockClearLog', @level2type=N'COLUMN',@level2name=N'Remark' GO