SCO供应链协同

## 数据表：T_SPM_PROMOTIONPROJECT(促销费用项目（废弃）)

### T_SPM_PROMOTIONPROJECT(促销费用项目（废弃）)：描述

名称 | T_SPM_PROMOTIONPROJECT(促销费用项目（废弃）)
代码 | T_SPM_PROMOTIONPROJECT
注释 |
模型 | SCO供应链协同
主键 | PK_SPM_PROMOTIONPROJECT

### T_SPM_PROMOTIONPROJECT(促销费用项目（废弃）)：列规格定义

名称 | 代码 | 数据类型 | 长度 | 强制 | 注释
促销费用项目主键ID | FPROMOTIONPROJECTID | int |  | TRUE |
编码 | FNUMBER | nvarchar(30) | 30 | TRUE |
状态 | FDOCUMENTSTATUS | char(1) | 1 | TRUE |
禁用状态 | FFORBIDSTATUS | char(1) | 1 | TRUE |
修改人 | FMODIFIERID | int |  | TRUE |
创建人 | FCREATORID | int |  | TRUE |
修改时间 | FMODIFYDATE | datetime |  | FALSE |
创建时间 | FCREATEDATE | datetime |  | FALSE |
禁用人 | FFORBIDERID | int |  | TRUE |
禁用时间 | FFORBIDDATE | datetime |  | FALSE |
审核人 | FAPPROVERID | int |  | TRUE |
审核时间 | FAPPROVEDATE | datetime |  | FALSE |
促销费用项目分类 | FPROMOTIONPROJECTGROUPID | int |  | TRUE |

### T_SPM_PROMOTIONPROJECT(促销费用项目（废弃）)：脚本代码

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('T_SPM_PROMOTIONPROJECT') and o.name = 'FK_T_SPM_PR_R_DRP_PRO_T_SPM_PR')
alter table T_SPM_PROMOTIONPROJECT
drop constraint FK_T_SPM_PR_R_DRP_PRO_T_SPM_PR
go
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('T_SPM_PROMOTIONPROJECT_L') and o.name = 'FK_T_SPM_PR_REFERENCE_T_SPM_PR')
alter table T_SPM_PROMOTIONPROJECT_L
drop constraint FK_T_SPM_PR_REFERENCE_T_SPM_PR
go
if exists (select 1
from sysindexes
where id = object_id('T_SPM_PROMOTIONPROJECT')
and name = 'IDX_SPM_PROMOPRO_GP'
and indid > 0
and indid < 255)
drop index T_SPM_PROMOTIONPROJECT.IDX_SPM_PROMOPRO_GP
go
if exists (select 1
from sysindexes
where id = object_id('T_SPM_PROMOTIONPROJECT')
and name = 'IDX_SPM_PROMOPRONUM'
and indid > 0
and indid < 255)
drop index T_SPM_PROMOTIONPROJECT.IDX_SPM_PROMOPRONUM
go
if exists (select 1
from sysobjects
where id = object_id('T_SPM_PROMOTIONPROJECT')
and type = 'U')
drop table T_SPM_PROMOTIONPROJECT
go
/*==============================================================*/
/* Table: T_SPM_PROMOTIONPROJECT */
/*==============================================================*/
create table T_SPM_PROMOTIONPROJECT (
FPROMOTIONPROJECTID int not null default 0,
FNUMBER nvarchar(30) not null default '',
FDOCUMENTSTATUS char(1) not null default '',
FFORBIDSTATUS char(1) not null default '',
FMODIFIERID int not null default 0,
FCREATORID int not null default 0,
FMODIFYDATE datetime null,
FCREATEDATE datetime null,
FFORBIDERID int not null default 0,
FFORBIDDATE datetime null,
FAPPROVERID int not null default 0,
FAPPROVEDATE datetime null,
FPROMOTIONPROJECTGROUPID int not null default 0,
constraint PK_SPM_PROMOTIONPROJECT primary key (FPROMOTIONPROJECTID)
)
go
/*==============================================================*/
/* Index: IDX_SPM_PROMOPRONUM */
/*==============================================================*/
create index IDX_SPM_PROMOPRONUM on T_SPM_PROMOTIONPROJECT (
FNUMBER ASC,
FDOCUMENTSTATUS ASC,
FFORBIDSTATUS ASC,
FPROMOTIONPROJECTGROUPID ASC
)
go
/*==============================================================*/
/* Index: IDX_SPM_PROMOPRO_GP */
/*==============================================================*/
create index IDX_SPM_PROMOPRO_GP on T_SPM_PROMOTIONPROJECT (
FPROMOTIONPROJECTGROUPID ASC,
FDOCUMENTSTATUS ASC,
FFORBIDSTATUS ASC
)
go
alter table T_SPM_PROMOTIONPROJECT
add constraint FK_T_SPM_PR_R_DRP_PRO_T_SPM_PR foreign key (FPROMOTIONPROJECTGROUPID)
references T_SPM_PROMOTIONPROJECTGROUP (FID)
go

### T_SPM_PROMOTIONPROJECT(促销费用项目（废弃）)：键值定义

名称 | 代码 | 主要的
PK_SPM_PROMOTIONPROJECT | PK_SPM_PROMOTIONPROJECT | TRUE

### T_SPM_PROMOTIONPROJECT(促销费用项目（废弃）)：索引定义

名称 | 代码 | 唯一的 | 群集器 | 主要的 | 外键 | 候选键 | 表格
IDX_SPM_PROMOPRONUM | IDX_SPM_PROMOPRONUM | FALSE | FALSE | FALSE | FALSE | FALSE | T_SPM_PROMOTIONPROJECT(促销费用项目（废弃）)
IDX_SPM_PROMOPRO_GP | IDX_SPM_PROMOPRO_GP | FALSE | FALSE | FALSE | FALSE | FALSE | T_SPM_PROMOTIONPROJECT(促销费用项目（废弃）)

上一页

主页

下一页