集团财务

## 数据表：T_WB_District(地区信息)

### T_WB_District(地区信息)：描述

名称 | T_WB_District(地区信息)
代码 | T_WB_District
注释 | 地区信息
模型 | 集团财务
主键 | PK_WB_District

### T_WB_District(地区信息)：列规格定义

名称 | 代码 | 数据类型 | 长度 | 强制 | 注释
内码 | FID | int |  | TRUE |
编码 | FNUMBER | nvarchar(10) | 10 | TRUE |
数据状态 | FDOCUMENTSTATUS | char(1) | 1 | TRUE | A：创建 B：审核中 C：已审核 D：重新审核 Z：暂存
禁用状态 | FFORBIDSTATUS | char(1) | 1 | TRUE | A:未禁用；B:已经禁用
城市ID | FParentID | int |  | TRUE |

### T_WB_District(地区信息)：脚本代码

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_WB_District_L') and o.name = '多语言表关系')
alter table T_WB_District_L
drop constraint 多语言表关系
go
if exists (select 1
from sysindexes
where id = object_id('T_WB_District')
and name = 'IDX_WB_District_Number'
and indid > 0
and indid < 255)
drop index T_WB_District.IDX_WB_District_Number
go
if exists (select 1
from sysindexes
where id = object_id('T_WB_District')
and name = 'IDX_WB_District_Parent'
and indid > 0
and indid < 255)
drop index T_WB_District.IDX_WB_District_Parent
go
if exists (select 1
from sysobjects
where id = object_id('T_WB_District')
and type = 'U')
drop table T_WB_District
go
/*==============================================================*/
/* Table: T_WB_District */
/*==============================================================*/
create table T_WB_District (
FID int not null default 0,
FNUMBER nvarchar(10) not null default '',
FDOCUMENTSTATUS char(1) not null default 'C',
FFORBIDSTATUS char(1) not null default 'A',
FParentID int not null default 0,
constraint PK_WB_District primary key (FID)
)
go
declare @CurrentUser sysname
select @CurrentUser = user_name()
execute sp_addextendedproperty 'MS_Description',
'地区信息',
'user', @CurrentUser, 'table', 'T_WB_District'
go
declare @CurrentUser sysname
select @CurrentUser = user_name()
execute sp_addextendedproperty 'MS_Description',
'A：创建
B：审核中
C：已审核
D：重新审核
Z：暂存',
'user', @CurrentUser, 'table', 'T_WB_District', 'column', 'FDOCUMENTSTATUS'
go
declare @CurrentUser sysname
select @CurrentUser = user_name()
execute sp_addextendedproperty 'MS_Description',
'A:未禁用；B:已经禁用',
'user', @CurrentUser, 'table', 'T_WB_District', 'column', 'FFORBIDSTATUS'
go
/*==============================================================*/
/* Index: IDX_WB_District_Parent */
/*==============================================================*/
create index IDX_WB_District_Parent on T_WB_District (
FParentID ASC
)
go
/*==============================================================*/
/* Index: IDX_WB_District_Number */
/*==============================================================*/
create index IDX_WB_District_Number on T_WB_District (
FNUMBER ASC
)
go

### T_WB_District(地区信息)：键值定义

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

### T_WB_District(地区信息)：索引定义

名称 | 代码 | 唯一的 | 群集器 | 主要的 | 外键 | 候选键 | 表格
IDX_WB_District_Parent | IDX_WB_District_Parent | FALSE | FALSE | FALSE | FALSE | FALSE | T_WB_District(地区信息)
IDX_WB_District_Number | IDX_WB_District_Number | FALSE | FALSE | FALSE | FALSE | FALSE | T_WB_District(地区信息)

上一页

主页

下一页