if exists (select 1 from sys.sysreferences r join sys.sysobjects o on (o.id = r.constid and o.type = 'F') where r.fkeyid = object_id('replenish.ReplenishOrderLine') and o.name = 'FK_REPLENIS_REFERENCE_REPLENIS') alter table replenish.ReplenishOrderLine drop constraint FK_REPLENIS_REFERENCE_REPLENIS go alter table replenish.ReplenishOrderLine drop constraint PK_REPLENISHORDERLINE go if exists (select 1 from sysobjects where id = object_id('replenish.ReplenishOrderLine') and type = 'U') drop table replenish.ReplenishOrderLine go /*==============================================================*/ /* Table: ReplenishOrderLine */ /*==============================================================*/ create table replenish.ReplenishOrderLine ( ReplenishOrderLineId int not null, ReplenishOrderId int not null, CusRepNumber varchar(20) null, InventoryId int not null, InventoryNumber varchar(20) not null, InventoryName nvarchar(255) not null, Spec varchar(300) null, ReplenishType int null, ReplenishId int null, ReplenishName varchar(50) null, ReplenishCycle Int null default 0, ReplenishReasonId int null, ReplenishReasonMemo nvarchar(255) null, RepPosition nvarchar(255) null, RepMemo nvarchar(255) null, Quantity int null default 1, BearPrice money null default 0, IsFree int null, ApprovedBy nvarchar(20) not null, ApprovedOn datetime null, ApprovedIdea nvarchar(200) null, ProduceReceivingBy nvarchar(20) null, ProduceReceivingOn datetime null, ExpFinishOn datetime null, FinishOnBy nvarchar(20) null, FinishOn datetime null, LineStatus int null, Memo nvarchar(255) null ) go EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value='����������' , @level0type=N'SCHEMA',@level0name='replenish', @level1type=N'TABLE',@level1name='ReplenishOrderLine' go EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value='����������ID', @level0type=N'SCHEMA',@level0name='replenish', @level1type=N'TABLE',@level1name='ReplenishOrderLine', @level2type=N'COLUMN',@level2name='ReplenishOrderLineId' go EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value='������������', @level0type=N'SCHEMA',@level0name='replenish', @level1type=N'TABLE',@level1name='ReplenishOrderLine', @level2type=N'COLUMN',@level2name='ReplenishOrderId' go EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value='�ͻ��������', @level0type=N'SCHEMA',@level0name='replenish', @level1type=N'TABLE',@level1name='ReplenishOrderLine', @level2type=N'COLUMN',@level2name='CusRepNumber' go EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value='�������', @level0type=N'SCHEMA',@level0name='replenish', @level1type=N'TABLE',@level1name='ReplenishOrderLine', @level2type=N'COLUMN',@level2name='InventoryId' go EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value='�Ϻ�', @level0type=N'SCHEMA',@level0name='replenish', @level1type=N'TABLE',@level1name='ReplenishOrderLine', @level2type=N'COLUMN',@level2name='InventoryNumber' go EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value='�������', @level0type=N'SCHEMA',@level0name='replenish', @level1type=N'TABLE',@level1name='ReplenishOrderLine', @level2type=N'COLUMN',@level2name='InventoryName' go EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value='����ͺ�', @level0type=N'SCHEMA',@level0name='replenish', @level1type=N'TABLE',@level1name='ReplenishOrderLine', @level2type=N'COLUMN',@level2name='Spec' go EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value='ValueTextMap��', @level0type=N'SCHEMA',@level0name='replenish', @level1type=N'TABLE',@level1name='ReplenishOrderLine', @level2type=N'COLUMN',@level2name='ReplenishType' go EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value='��������Id', @level0type=N'SCHEMA',@level0name='replenish', @level1type=N'TABLE',@level1name='ReplenishOrderLine', @level2type=N'COLUMN',@level2name='ReplenishId' go EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value='��������', @level0type=N'SCHEMA',@level0name='replenish', @level1type=N'TABLE',@level1name='ReplenishOrderLine', @level2type=N'COLUMN',@level2name='ReplenishName' go EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value='������������', @level0type=N'SCHEMA',@level0name='replenish', @level1type=N'TABLE',@level1name='ReplenishOrderLine', @level2type=N'COLUMN',@level2name='ReplenishCycle' go EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value='ԭ��id', @level0type=N'SCHEMA',@level0name='replenish', @level1type=N'TABLE',@level1name='ReplenishOrderLine', @level2type=N'COLUMN',@level2name='ReplenishReasonId' go EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value='����ԭ������', @level0type=N'SCHEMA',@level0name='replenish', @level1type=N'TABLE',@level1name='ReplenishOrderLine', @level2type=N'COLUMN',@level2name='ReplenishReasonMemo' go EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value='����λ��', @level0type=N'SCHEMA',@level0name='replenish', @level1type=N'TABLE',@level1name='ReplenishOrderLine', @level2type=N'COLUMN',@level2name='RepPosition' go EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value='������������', @level0type=N'SCHEMA',@level0name='replenish', @level1type=N'TABLE',@level1name='ReplenishOrderLine', @level2type=N'COLUMN',@level2name='RepMemo' go EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value='��������', @level0type=N'SCHEMA',@level0name='replenish', @level1type=N'TABLE',@level1name='ReplenishOrderLine', @level2type=N'COLUMN',@level2name='Quantity' go EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value='�ͻ��е���', @level0type=N'SCHEMA',@level0name='replenish', @level1type=N'TABLE',@level1name='ReplenishOrderLine', @level2type=N'COLUMN',@level2name='BearPrice' go EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value='�Ƿ����', @level0type=N'SCHEMA',@level0name='replenish', @level1type=N'TABLE',@level1name='ReplenishOrderLine', @level2type=N'COLUMN',@level2name='IsFree' go EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value='�����', @level0type=N'SCHEMA',@level0name='replenish', @level1type=N'TABLE',@level1name='ReplenishOrderLine', @level2type=N'COLUMN',@level2name='ApprovedBy' go EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value='�������--ִ����˲���ʱ��ϵͳ�Զ���䵱ǰ����', @level0type=N'SCHEMA',@level0name='replenish', @level1type=N'TABLE',@level1name='ReplenishOrderLine', @level2type=N'COLUMN',@level2name='ApprovedOn' go EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value='������', @level0type=N'SCHEMA',@level0name='replenish', @level1type=N'TABLE',@level1name='ReplenishOrderLine', @level2type=N'COLUMN',@level2name='ApprovedIdea' go EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value='�����ӵ���', @level0type=N'SCHEMA',@level0name='replenish', @level1type=N'TABLE',@level1name='ReplenishOrderLine', @level2type=N'COLUMN',@level2name='ProduceReceivingBy' go EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value='�����ӵ�ʱ��', @level0type=N'SCHEMA',@level0name='replenish', @level1type=N'TABLE',@level1name='ReplenishOrderLine', @level2type=N'COLUMN',@level2name='ProduceReceivingOn' go EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value='Ԥ���깤ʱ��', @level0type=N'SCHEMA',@level0name='replenish', @level1type=N'TABLE',@level1name='ReplenishOrderLine', @level2type=N'COLUMN',@level2name='ExpFinishOn' go EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value='�����깤�����', @level0type=N'SCHEMA',@level0name='replenish', @level1type=N'TABLE',@level1name='ReplenishOrderLine', @level2type=N'COLUMN',@level2name='FinishOnBy' go EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value='�����깤���ʱ��', @level0type=N'SCHEMA',@level0name='replenish', @level1type=N'TABLE',@level1name='ReplenishOrderLine', @level2type=N'COLUMN',@level2name='FinishOn' go EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value='������״̬', @level0type=N'SCHEMA',@level0name='replenish', @level1type=N'TABLE',@level1name='ReplenishOrderLine', @level2type=N'COLUMN',@level2name='LineStatus' go EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value='��ע', @level0type=N'SCHEMA',@level0name='replenish', @level1type=N'TABLE',@level1name='ReplenishOrderLine', @level2type=N'COLUMN',@level2name='Memo' go alter table replenish.ReplenishOrderLine add constraint PK_REPLENISHORDERLINE primary key (ReplenishOrderLineId) go alter table replenish.ReplenishOrderLine add constraint FK_REPLENIS_REFERENCE_REPLENIS foreign key (ReplenishOrderId) references replenish.ReplenishOrder (ReplenishOrderId) go