MFG制造

## 数据表：T_ENG_ROUTEOPERSEQ(工艺路线工序序列单据体)

### T_ENG_ROUTEOPERSEQ(工艺路线工序序列单据体)：描述

名称 | T_ENG_ROUTEOPERSEQ(工艺路线工序序列单据体)
代码 | T_ENG_ROUTEOPERSEQ
注释 |
模型 | MFG制造
主键 | PK_ENG_ROUTEOPERSEQ

### T_ENG_ROUTEOPERSEQ(工艺路线工序序列单据体)：列规格定义

名称 | 代码 | 数据类型 | 长度 | 强制 | 注释
工艺路线ID | FID | int |  | TRUE |
主键 | FENTRYID | int |  | TRUE |
序号 | FSEQ | int |  | TRUE |
序列号 | FSEQNUMBER | nvarchar(8) | 8 | FALSE |
序列类型 | FSEQTYPE | varchar(20) | 20 | FALSE |
对齐方式 | FSEQALIGNMENT | varchar(20) | 20 | FALSE |
参照序列 | FSEQREFER | nvarchar(8) | 8 | FALSE |
转出工序 | FSEQOUT | int |  | TRUE |
转入工序 | FSEQIN | int |  | TRUE |

### T_ENG_ROUTEOPERSEQ(工艺路线工序序列单据体)：脚本代码

if exists (select 1
from sysindexes
where id = object_id('T_ENG_ROUTEOPERSEQ')
and name = 'IDX_ENG_ROUTEOPERSEQ_SEQNUM'
and indid > 0
and indid < 255)
drop index T_ENG_ROUTEOPERSEQ.IDX_ENG_ROUTEOPERSEQ_SEQNUM
go
if exists (select 1
from sysindexes
where id = object_id('T_ENG_ROUTEOPERSEQ')
and name = 'IDX_ENG_ROUTEOPERSEQ_ID'
and indid > 0
and indid < 255)
drop index T_ENG_ROUTEOPERSEQ.IDX_ENG_ROUTEOPERSEQ_ID
go
if exists (select 1
from sysobjects
where id = object_id('T_ENG_ROUTEOPERSEQ')
and type = 'U')
drop table T_ENG_ROUTEOPERSEQ
go
/*==============================================================*/
/* Table: T_ENG_ROUTEOPERSEQ */
/*==============================================================*/
create table T_ENG_ROUTEOPERSEQ (
FID int not null default 0,
FENTRYID int not null default 0,
FSEQ int not null default 0,
FSEQNUMBER nvarchar(8) null,
FSEQTYPE varchar(20) null,
FSEQALIGNMENT varchar(20) null,
FSEQREFER nvarchar(8) null,
FSEQOUT int not null default 0,
FSEQIN int not null default 0,
constraint PK_ENG_ROUTEOPERSEQ primary key (FENTRYID)
on "PRIMARY"
)
on "PRIMARY"
go
/*==============================================================*/
/* Index: IDX_ENG_ROUTEOPERSEQ_ID */
/*==============================================================*/
create index IDX_ENG_ROUTEOPERSEQ_ID on T_ENG_ROUTEOPERSEQ (
FID ASC
)
go
/*==============================================================*/
/* Index: IDX_ENG_ROUTEOPERSEQ_SEQNUM */
/*==============================================================*/
create index IDX_ENG_ROUTEOPERSEQ_SEQNUM on T_ENG_ROUTEOPERSEQ (
FSEQNUMBER ASC
)
go

### T_ENG_ROUTEOPERSEQ(工艺路线工序序列单据体)：键值定义

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

### T_ENG_ROUTEOPERSEQ(工艺路线工序序列单据体)：索引定义

名称 | 代码 | 唯一的 | 群集器 | 主要的 | 外键 | 候选键 | 表格
IDX_ENG_ROUTEOPERSEQ_ID | IDX_ENG_ROUTEOPERSEQ_ID | FALSE | FALSE | FALSE | FALSE | FALSE | T_ENG_ROUTEOPERSEQ(工艺路线工序序列单据体)
IDX_ENG_ROUTEOPERSEQ_SEQNUM | IDX_ENG_ROUTEOPERSEQ_SEQNUM | FALSE | FALSE | FALSE | FALSE | FALSE | T_ENG_ROUTEOPERSEQ(工艺路线工序序列单据体)

上一页

主页

下一页