MFG制造

## 数据表：T_ENG_WORKTYPE(工种)

### T_ENG_WORKTYPE(工种)：描述

名称 | T_ENG_WORKTYPE(工种)
代码 | T_ENG_WORKTYPE
注释 |
模型 | MFG制造
主键 | PK_ENG_WORKTYPE

### T_ENG_WORKTYPE(工种)：列规格定义

名称 | 代码 | 数据类型 | 长度 | 强制 | 注释
主键 | FID | int |  | TRUE |
组织控制字段 | FMASTERID | int |  | TRUE |
创建组织 | FCREATEORGID | int |  | TRUE |
编码 | FNUMBER | nvarchar(80) | 80 | FALSE |
使用组织 | FUSEORGID | int |  | FALSE |
创建人 | FCREATORID | int |  | FALSE |
创建日期 | FCREATEDATE | datetime |  | FALSE |
修改人 | FMODIFIERID | int |  | FALSE |
修改日期 | FMODIFYDATE | datetime |  | FALSE |
审核人 | FAPPROVERID | int |  | FALSE |
审核日期 | FAPPROVEDATE | datetime |  | FALSE |
数据状态 | FDOCUMENTSTATUS | CHAR(1) | 1 | FALSE |
禁用人 | FFORBIDDERID | int |  | FALSE |
禁用日期 | FFORBIDDATE | datetime |  | FALSE |
禁用状态 | FFORBIDSTATUS | CHAR(1) | 1 | FALSE |
生效日期 | FEFFECTDATE | datetime |  | FALSE |
失效日期 | FEXPREDATE | datetime |  | FALSE |
系统预设 | FISSYSTEMSET | CHAR(1) | 1 | FALSE |

### T_ENG_WORKTYPE(工种)：脚本代码

if exists (select 1
from sysindexes
where id = object_id('dbo.T_ENG_WORKTYPE')
and name = 'IDX_ENG_WORKTYPE_CRTDATE'
and indid > 0
and indid < 255)
drop index dbo.T_ENG_WORKTYPE.IDX_ENG_WORKTYPE_CRTDATE
go
if exists (select 1
from sysindexes
where id = object_id('dbo.T_ENG_WORKTYPE')
and name = 'IDX_ENG_WORKTYPE_USERORGID'
and indid > 0
and indid < 255)
drop index dbo.T_ENG_WORKTYPE.IDX_ENG_WORKTYPE_USERORGID
go
if exists (select 1
from sysindexes
where id = object_id('dbo.T_ENG_WORKTYPE')
and name = 'IDX_ENG_WORKTYPE_NUMBER'
and indid > 0
and indid < 255)
drop index dbo.T_ENG_WORKTYPE.IDX_ENG_WORKTYPE_NUMBER
go
if exists (select 1
from sysobjects
where id = object_id('dbo.T_ENG_WORKTYPE')
and type = 'U')
drop table dbo.T_ENG_WORKTYPE
go
/*==============================================================*/
/* Table: T_ENG_WORKTYPE */
/*==============================================================*/
create table dbo.T_ENG_WORKTYPE (
FID int not null,
FMASTERID int not null,
FCREATEORGID int not null,
FNUMBER nvarchar(80) null,
FUSEORGID int null,
FCREATORID int null,
FCREATEDATE datetime null,
FMODIFIERID int null,
FMODIFYDATE datetime null,
FAPPROVERID int null,
FAPPROVEDATE datetime null,
FDOCUMENTSTATUS CHAR(1) null,
FFORBIDDERID int null,
FFORBIDDATE datetime null,
FFORBIDSTATUS CHAR(1) null,
FEFFECTDATE datetime null,
FEXPREDATE datetime null,
FISSYSTEMSET CHAR(1) null,
constraint pk_ENG_WORKTYPE primary key (FID)
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
)
ON [PRIMARY]
go
/*==============================================================*/
/* Index: IDX_ENG_WORKTYPE_NUMBER */
/*==============================================================*/
create index IDX_ENG_WORKTYPE_NUMBER on dbo.T_ENG_WORKTYPE (
FNUMBER ASC,
FUSEORGID ASC
)
go
/*==============================================================*/
/* Index: IDX_ENG_WORKTYPE_USERORGID */
/*==============================================================*/
create index IDX_ENG_WORKTYPE_USERORGID on dbo.T_ENG_WORKTYPE (
FUSEORGID ASC
)
go
/*==============================================================*/
/* Index: IDX_ENG_WORKTYPE_CRTDATE */
/*==============================================================*/
create index IDX_ENG_WORKTYPE_CRTDATE on dbo.T_ENG_WORKTYPE (
FCREATEDATE ASC
)
go

### T_ENG_WORKTYPE(工种)：键值定义

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

### T_ENG_WORKTYPE(工种)：索引定义

名称 | 代码 | 唯一的 | 群集器 | 主要的 | 外键 | 候选键 | 表格
IDX_ENG_WORKTYPE_NUMBER | IDX_ENG_WORKTYPE_NUMBER | FALSE | FALSE | FALSE | FALSE | FALSE | T_ENG_WORKTYPE(工种)
IDX_ENG_WORKTYPE_USERORGID | IDX_ENG_WORKTYPE_USERORGID | FALSE | FALSE | FALSE | FALSE | FALSE | T_ENG_WORKTYPE(工种)
IDX_ENG_WORKTYPE_CRTDATE | IDX_ENG_WORKTYPE_CRTDATE | FALSE | FALSE | FALSE | FALSE | FALSE | T_ENG_WORKTYPE(工种)

上一页

主页

下一页