/* ================================================================================ 档案代号:qctt_file 档案名称:品质检验单身测量值档 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table qctt_file ( qctt01 varchar2(16), /*收货单号 */ /*收货单号 (qcs01) */ qctt02 number(5), /*收货项次 */ /*收货项次 (qcs02) */ qctt021 number(5), /*分批检验顺序 */ /*分批检验顺序 (qcs05) */ qctt03 number(5), /*单身行序 */ qctt04 number(15,3) /*测量值 */ ); create index qctt_01 on qctt_file (qctt01,qctt02,qctt021,qctt03); grant select on qctt_file to public; grant index on qctt_file to public; grant update on qctt_file to public; grant delete on qctt_file to public; grant insert on qctt_file to public; |