/* ================================================================================ 档案代号:gsyc_file 档案名称:软体代工开发记录(资料同 ze.zz.zm.zmd同步清单) 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table gsyc_file ( gsyc00 varchar2(16) NOT NULL, /*确认单号 */ gsyc01 number(5) NOT NULL, /*项次 */ gsyc02 number(5) NOT NULL, /*行序 */ gsyc03 varchar2(1), /*动作 */ gsyc04 varchar2(1), /*档案代号 */ gsyc05 varchar2(15), /*档案名称 */ gsyc06 varchar2(80), /*key栏位的值1 */ gsyc07 varchar2(80), /*key栏位的值2 */ gsyc08 number(5) NOT NULL /*版次 */ ); create unique index gsyc_pk on gsyc_file (gsyc00,gsyc01,gsyc08,gsyc02); alter table gsyc_file add constraint gsyc_pk primary key (gsyc00,gsyc01,gsyc08,gsyc02) enable validate; grant select on gsyc_file to public; grant index on gsyc_file to public; grant update on gsyc_file to public; grant delete on gsyc_file to public; grant insert on gsyc_file to public; |