SCO供应链协同

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

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

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

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

名称 | 代码 | 数据类型 | 长度 | 强制 | 注释
ID | FID | int |  | TRUE |
编码 | FNUMBER | nvarchar(100) | 100 | TRUE |
分组ID | FGROUPID | varchar(36) | 36 | TRUE |
上级ID | FPARENTID | int |  | TRUE |
全路径 | FFULLPARENTID | varchar(500) | 500 | TRUE |
左节点 | FLEFT | int |  | TRUE |
右节点 | FRIGHT | int |  | TRUE |

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

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_PROMOTIONPROJECTGROUP_L') and o.name = 'FK_T_SPM_PR_R_DRP_PPG_T_SPM_PR')
alter table T_SPM_PROMOTIONPROJECTGROUP_L
drop constraint FK_T_SPM_PR_R_DRP_PPG_T_SPM_PR
go
if exists (select 1
from sysindexes
where id = object_id('T_SPM_PROMOTIONPROJECTGROUP')
and name = 'IDX_SPM_PROMOPRO_GPID'
and indid > 0
and indid < 255)
drop index T_SPM_PROMOTIONPROJECTGROUP.IDX_SPM_PROMOPRO_GPID
go
if exists (select 1
from sysobjects
where id = object_id('T_SPM_PROMOTIONPROJECTGROUP')
and type = 'U')
drop table T_SPM_PROMOTIONPROJECTGROUP
go
/*==============================================================*/
/* Table: T_SPM_PROMOTIONPROJECTGROUP */
/*==============================================================*/
create table T_SPM_PROMOTIONPROJECTGROUP (
FID int not null default 0,
FNUMBER nvarchar(100) not null default '',
FGROUPID varchar(36) not null default '',
FPARENTID int not null default 0,
FFULLPARENTID varchar(500) not null default '',
FLEFT int not null default 0,
FRIGHT int not null default 0,
constraint PK_SPM_PROMOPROGROUP primary key (FID)
)
go
declare @CurrentUser sysname
select @CurrentUser = user_name()
execute sp_addextendedproperty 'MS_Description',
'促销费用项目分类',
'user', @CurrentUser, 'table', 'T_SPM_PROMOTIONPROJECTGROUP'
go
/*==============================================================*/
/* Index: IDX_SPM_PROMOPRO_GPID */
/*==============================================================*/
create index IDX_SPM_PROMOPRO_GPID on T_SPM_PROMOTIONPROJECTGROUP (
FGROUPID ASC
)
go

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

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

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

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

上一页

主页

下一页