TargetProxySKU

来源：互联网发布：财经数据网站编辑：程序博客网时间：2024/04/29 07:47

if exists (select 1
            from sysindexes
           where id    = object_id('dbo.TargetProxySKU')
            and   name = 'XIF1User'
            and   indid > 0
            and   indid < 255)
   drop index dbo.TargetProxySKU.XIF1User
go

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

/*==============================================================*/
/* Table: TargetProxySKU                                        */
/*==============================================================*/
create table dbo.TargetProxySKU (
   ID                   uniqueidentifier     PRIMARY KEY,
   SKUID                uniqueidentifier     null,
   TargetConfrimID      uniqueidentifier     null,
   CreatedOn            datetime             null,
   CreatedBy            nvarchar(20)         collate Chinese_PRC_CI_AS null,
   ModifiedOn           datetime             null,
   ModifiedBy           nvarchar(20)         collate Chinese_PRC_CI_AS null,
   Status               int                  null

)
on "PRIMARY"
go

execute sp_addextendedproperty 'MS_Description',
'指标生成选择的SKU',
'user', 'dbo', 'table', 'TargetProxySKU'
go

execute sp_addextendedproperty 'MS_Description',
'主键',
'user', 'dbo', 'table', 'TargetProxySKU', 'column', 'ID'
go

execute sp_addextendedproperty 'MS_Description',
'SKU的ID',
'user', 'dbo', 'table', 'TargetProxySKU', 'column', 'SKUID'
go

execute sp_addextendedproperty 'MS_Description',
   '指标的ConfirmID
   ',
   'user', 'dbo', 'table', 'TargetProxySKU', 'column', 'TargetConfrimID'
go

execute sp_addextendedproperty 'MS_Description',
'创建时间',
'user', 'dbo', 'table', 'TargetProxySKU', 'column', 'CreatedOn'
go

execute sp_addextendedproperty 'MS_Description',
'创建人',
'user', 'dbo', 'table', 'TargetProxySKU', 'column', 'CreatedBy'
go

execute sp_addextendedproperty 'MS_Description',
'更新时间',
'user', 'dbo', 'table', 'TargetProxySKU', 'column', 'ModifiedOn'
go

execute sp_addextendedproperty 'MS_Description',
'更新人',
'user', 'dbo', 'table', 'TargetProxySKU', 'column', 'ModifiedBy'
go

execute sp_addextendedproperty 'MS_Description',
   '0正常
   2删除',
   'user', 'dbo', 'table', 'TargetProxySKU', 'column', 'Status'
go

0 0