GoldHoo/doc/调整记录/已更新正式环境/Promo.PromoSkuMember-2018.08.17.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('Promo.PromoSkuMember') and o.name = 'FK_PROMOSKU_REFERENCE_PROMOSKU')
alter table Promo.PromoSkuMember
   drop constraint FK_PROMOSKU_REFERENCE_PROMOSKU
go

alter table Promo.PromoSkuMember
   drop constraint PK_PROMOSKUMEMBER
go

if exists (select 1
            from  sysobjects
           where  id = object_id('Promo.PromoSkuMember')
            and   type = 'U')
   drop table Promo.PromoSkuMember
go

/*==============================================================*/
/* Table: PromoSkuMember                                        */
/*==============================================================*/
create table Promo.PromoSkuMember (
   PromoSkuMemberId     int                  not null,
   PromoSkuId           int                  not null,
   InventoryId          int                  not null,
   InventoryNumber      varchar(20)          null,
   InventoryName        nvarchar(100)        null,
   Spec                 nvarchar(300)        null,
   Price                money                not null,
   PromoPrice           money                not null,
   Quantity             numeric(9,0)         not null,
   ModifiedBy           nvarchar(20)         null,
   ModifiedOn           datetime             not null default GETDATE(),
   CreatedBy            nvarchar(20)         not null,
   CreatedOn            datetime             not null default GETDATE(),
   Description          nvarchar(200)        null
)
go

execute sp_addextendedproperty 'MS_Description', 
   '销售管理.促销产品组成员',
   'user', 'Promo', 'table', 'PromoSkuMember'
go

execute sp_addextendedproperty 'MS_Description', '组成员内码','schema', 'Promo', 'table', 'PromoSkuMember', 'column', 
'PromoSkuMemberId'
go

execute sp_addextendedproperty 'MS_Description', '组内码','schema', 'Promo', 'table', 'PromoSkuMember', 'column', 
'PromoSkuId'
go

execute sp_addextendedproperty 'MS_Description', '存货内码','schema', 'Promo', 'table', 'PromoSkuMember', 'column', 
'InventoryId'
go

execute sp_addextendedproperty 'MS_Description', '存货编码','schema', 'Promo', 'table', 'PromoSkuMember', 'column', 
'InventoryNumber'
go

execute sp_addextendedproperty 'MS_Description', '存货名称','schema', 'Promo', 'table', 'PromoSkuMember', 'column', 
'InventoryName'
go

execute sp_addextendedproperty 'MS_Description', '规格','schema', 'Promo', 'table', 'PromoSkuMember', 'column', 
'Spec'
go

execute sp_addextendedproperty 'MS_Description', '原价','schema', 'Promo', 'table', 'PromoSkuMember', 'column', 
'Price'
go

execute sp_addextendedproperty 'MS_Description', '促销价','schema', 'Promo', 'table', 'PromoSkuMember', 'column', 
'PromoPrice'
go

execute sp_addextendedproperty 'MS_Description', '数量','schema', 'Promo', 'table', 'PromoSkuMember', 'column', 
'Quantity'
go

execute sp_addextendedproperty 'MS_Description', '记录修改人','schema', 'Promo', 'table', 'PromoSkuMember', 'column', 
'ModifiedBy'
go

execute sp_addextendedproperty 'MS_Description', '记录修改时间','schema', 'Promo', 'table', 'PromoSkuMember', 'column', 
'ModifiedOn'
go

execute sp_addextendedproperty 'MS_Description', '记录创建人','schema', 'Promo', 'table', 'PromoSkuMember', 'column', 
'CreatedBy'
go

execute sp_addextendedproperty 'MS_Description', '记录创建时间','schema', 'Promo', 'table', 'PromoSkuMember', 'column', 
'CreatedOn'
go

execute sp_addextendedproperty 'MS_Description', '备注','schema', 'Promo', 'table', 'PromoSkuMember', 'column', 
'Description'
go

alter table Promo.PromoSkuMember
   add constraint PK_PROMOSKUMEMBER primary key (PromoSkuMemberId)
go

alter table Promo.PromoSkuMember
   add constraint FK_PROMOSKU_REFERENCE_PROMOSKU foreign key (PromoSkuId)
      references Promo.PromoSku (PromoSkuId)
go