/*
================================================================================
档案代号:gzln_file
档案名称:软体代工开发记录(程式修改档案清单)
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table gzln_file
(
gzln00      varchar2(16) NOT NULL,   /*确认单号                               */
gzln01      number(5) NOT NULL,      /*项次                                   */
gzln02      number(5) NOT NULL,      /*行序                                   */
gzln03      varchar2(4),             /*系统别                                 */
gzln04      varchar2(4),             /*档案类别/目录名称                      */
gzln05      varchar2(255),           /*档案名称                               */
gzln06      varchar2(255),           /*备注                                   */
gzln07      number(5) NOT NULL       /*版次                                   */
);

create unique index gzln_pk on gzln_file (gzln00,gzln01,gzln07,gzln02);
alter table gzln_file add  constraint gzln_pk primary key  (gzln00,gzln01,gzln07,gzln02) enable validate;
grant select on gzln_file to public;
grant index on gzln_file to public;
grant update on gzln_file to public;
grant delete on gzln_file to public;
grant insert on gzln_file to public;