/* ================================================================================ 档案代号:qch_file 档案名称:特殊检验水准样本代码资料档 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table qch_file ( qch01 number(10) NOT NULL, /*起始批量 */ qch02 number(10) NOT NULL, /*截止批量 */ qch03 varchar2(1) NOT NULL, /*样本字号 */ qch04 number(5), /*正常检验样本收 */ qch05 number(5), /*加严检验样本收 */ qch06 number(5), /*减量检验样本收 */ qch07 varchar2(1) NOT NULL /*级数 */ ); create unique index qch_pk on qch_file (qch01,qch02,qch03,qch07); alter table qch_file add constraint qch_pk primary key (qch01,qch02,qch03,qch07) enable validate; grant select on qch_file to public; grant index on qch_file to public; grant update on qch_file to public; grant delete on qch_file to public; grant insert on qch_file to public; |