MFG制造

## 数据表：T_QM_SSRETRIEVALENTRY(抽样方案检索表表体)

### T_QM_SSRETRIEVALENTRY(抽样方案检索表表体)：描述

名称 | T_QM_SSRETRIEVALENTRY(抽样方案检索表表体)
代码 | T_QM_SSRETRIEVALENTRY
注释 |
模型 | MFG制造
主键 | PK_QM_SSRETRIEVALENTRY

### T_QM_SSRETRIEVALENTRY(抽样方案检索表表体)：列规格定义

名称 | 代码 | 数据类型 | 长度 | 强制 | 注释
内码 | FID | int |  | FALSE |
分录内码 | FENTRYID | int |  | TRUE |
序号 | FSEQ | int |  | FALSE |
样本字码 | FSAMPLECODE | char(1) | 1 | FALSE |
样本量 | FSAMPLEQTY | int |  | FALSE |
F0_010_AC | F0_010_AC | int |  | FALSE |
F0_015_AC | F0_015_AC | int |  | FALSE |
F0_025_AC | F0_025_AC | int |  | FALSE |
F0_040_AC | F0_040_AC | int |  | FALSE |
F0_065_AC | F0_065_AC | int |  | FALSE |
F0_10_AC | F0_10_AC | int |  | FALSE |
F0_15_AC | F0_15_AC | int |  | FALSE |
F0_25_AC | F0_25_AC | int |  | FALSE |
F0_40_AC | F0_40_AC | int |  | FALSE |
F0_65_AC | F0_65_AC | int |  | FALSE |
F1_0_AC | F1_0_AC | int |  | FALSE |
F1_5_AC | F1_5_AC | int |  | FALSE |
F2_5_AC | F2_5_AC | int |  | FALSE |
F4_0_AC | F4_0_AC | int |  | FALSE |
F6_5_AC | F6_5_AC | int |  | FALSE |
F10_AC | F10_AC | int |  | FALSE |
F15_AC | F15_AC | int |  | FALSE |
F25_AC | F25_AC | int |  | FALSE |
F40_AC | F40_AC | int |  | FALSE |
F65_AC | F65_AC | int |  | FALSE |
F100_AC | F100_AC | int |  | FALSE |
F150_AC | F150_AC | int |  | FALSE |
F250_AC | F250_AC | int |  | FALSE |
F400_AC | F400_AC | int |  | FALSE |
F650_AC | F650_AC | int |  | FALSE |
F1000_AC | F1000_AC | int |  | FALSE |

### T_QM_SSRETRIEVALENTRY(抽样方案检索表表体)：脚本代码

if exists (select 1
from sysindexes
where id = object_id('T_QM_SSRETRIEVALENTRY')
and name = 'IDX_QM_SSRE_ID'
and indid > 0
and indid < 255)
drop index T_QM_SSRETRIEVALENTRY.IDX_QM_SSRE_ID
go
if exists (select 1
from sysobjects
where id = object_id('T_QM_SSRETRIEVALENTRY')
and type = 'U')
drop table T_QM_SSRETRIEVALENTRY
go
/*==============================================================*/
/* Table: T_QM_SSRETRIEVALENTRY */
/*==============================================================*/
create table T_QM_SSRETRIEVALENTRY (
FID int null,
FENTRYID int not null default 0,
FSEQ int null,
FSAMPLECODE char(1) null,
FSAMPLEQTY int null,
F0_010_AC int null,
F0_015_AC int null,
F0_025_AC int null,
F0_040_AC int null,
F0_065_AC int null,
F0_10_AC int null,
F0_15_AC int null,
F0_25_AC int null,
F0_40_AC int null,
F0_65_AC int null,
F1_0_AC int null,
F1_5_AC int null,
F2_5_AC int null,
F4_0_AC int null,
F6_5_AC int null,
F10_AC int null,
F15_AC int null,
F25_AC int null,
F40_AC int null,
F65_AC int null,
F100_AC int null,
F150_AC int null,
F250_AC int null,
F400_AC int null,
F650_AC int null,
F1000_AC int null,
constraint PK_QM_SSRETRIEVALENTRY primary key (FENTRYID)
)
go
/*==============================================================*/
/* Index: IDX_QM_SSRE_ID */
/*==============================================================*/
create index IDX_QM_SSRE_ID on T_QM_SSRETRIEVALENTRY (
FID ASC
)
go

### T_QM_SSRETRIEVALENTRY(抽样方案检索表表体)：键值定义

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

### T_QM_SSRETRIEVALENTRY(抽样方案检索表表体)：索引定义

名称 | 代码 | 唯一的 | 群集器 | 主要的 | 外键 | 候选键 | 表格
IDX_QM_SSRE_ID | IDX_QM_SSRE_ID | FALSE | FALSE | FALSE | FALSE | FALSE | T_QM_SSRETRIEVALENTRY(抽样方案检索表表体)

上一页

主页

下一页