GoldHoo/doc/调整记录/已更新正式环境/2021-03-17 09.56.sql

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