MFG制造

## 数据表：T_QM_SAMPLECODEENTRY(样本字码表表体)

### T_QM_SAMPLECODEENTRY(样本字码表表体)：描述

名称 | T_QM_SAMPLECODEENTRY(样本字码表表体)
代码 | T_QM_SAMPLECODEENTRY
注释 |
模型 | MFG制造
主键 | PK_QM_SAMPLECODEENTRY

### T_QM_SAMPLECODEENTRY(样本字码表表体)：列规格定义

名称 | 代码 | 数据类型 | 长度 | 强制 | 注释
内码 | FID | int |  | FALSE |
分录内码 | FENTRYID | int |  | TRUE |
序号 | FSEQ | int |  | FALSE |
样本下限 | FSAMPLELOW | int |  | FALSE |
样本上限 | FSAMPLEUP | int |  | FALSE |
FS1 | FS1 | char(1) | 1 | FALSE |
FS2 | FS2 | char(1) | 1 | FALSE |
FS3 | FS3 | char(1) | 1 | FALSE |
FS4 | FS4 | char(1) | 1 | FALSE |
FC1 | FC1 | char(1) | 1 | FALSE |
FC2 | FC2 | char(1) | 1 | FALSE |
FC3 | FC3 | char(1) | 1 | FALSE |

### T_QM_SAMPLECODEENTRY(样本字码表表体)：脚本代码

if exists (select 1
from sysindexes
where id = object_id('T_QM_SAMPLECODEENTRY')
and name = 'IDX_QM_SAMPLECODEE_ID'
and indid > 0
and indid < 255)
drop index T_QM_SAMPLECODEENTRY.IDX_QM_SAMPLECODEE_ID
go
if exists (select 1
from sysobjects
where id = object_id('T_QM_SAMPLECODEENTRY')
and type = 'U')
drop table T_QM_SAMPLECODEENTRY
go
/*==============================================================*/
/* Table: T_QM_SAMPLECODEENTRY */
/*==============================================================*/
create table T_QM_SAMPLECODEENTRY (
FID int null,
FENTRYID int not null default 0,
FSEQ int null,
FSAMPLELOW int null,
FSAMPLEUP int null,
FS1 char(1) null,
FS2 char(1) null,
FS3 char(1) null,
FS4 char(1) null,
FC1 char(1) null,
FC2 char(1) null,
FC3 char(1) null,
constraint PK_QM_SAMPLECODEENTRY primary key (FENTRYID)
)
go
/*==============================================================*/
/* Index: IDX_QM_SAMPLECODEE_ID */
/*==============================================================*/
create index IDX_QM_SAMPLECODEE_ID on T_QM_SAMPLECODEENTRY (
FID ASC
)
go

### T_QM_SAMPLECODEENTRY(样本字码表表体)：键值定义

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

### T_QM_SAMPLECODEENTRY(样本字码表表体)：索引定义

名称 | 代码 | 唯一的 | 群集器 | 主要的 | 外键 | 候选键 | 表格
IDX_QM_SAMPLECODEE_ID | IDX_QM_SAMPLECODEE_ID | FALSE | FALSE | FALSE | FALSE | FALSE | T_QM_SAMPLECODEENTRY(样本字码表表体)

上一页

主页

下一页