/*
================================================================================
档案代号: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;