/* ================================================================================ 档案代号:qci_file 档案名称:FQC 序号档 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table qci_file ( qci01 varchar2(16) NOT NULL, /*FQC 单号 */ qci02 varchar2(15) NOT NULL /*序号 */ ); create unique index qci_pk on qci_file (qci01,qci02); alter table qci_file add constraint qci_pk primary key (qci01,qci02) enable validate; grant select on qci_file to public; grant index on qci_file to public; grant update on qci_file to public; grant delete on qci_file to public; grant insert on qci_file to public; |