/* ================================================================================ 档案代号:qcnn_file 档案名称:PQC 品质检验单身档 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table qcnn_file ( qcnn01 varchar2(16), /*收货单号 */ qcnn03 number(5), /*行序 */ qcnn04 number(15,3) /*测量值 */ ); create index qcnn_01 on qcnn_file (qcnn01,qcnn03); grant select on qcnn_file to public; grant index on qcnn_file to public; grant update on qcnn_file to public; grant delete on qcnn_file to public; grant insert on qcnn_file to public; |