/*
================================================================================
档案代号:gfc_file
档案名称:客户开发记录 (程式修改清单)
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table gfc_file
(
gfc01       varchar2(16) NOT NULL,   /*开发单号                               */
gfc02       number(5) NOT NULL,      /*项次                                   */
gfc03       varchar2(5),             /*系统别                                 */
gfc04       varchar2(5),             /*档案类别                               */
gfc05       varchar2(80),            /*档案名称                               */
gfc06       varchar2(80),            /*备注                                   */
gfc07       varchar2(1),             /*程式状态                               */
gfc08       varchar2(10),            /*拥有者                                 */
gfc09       date,                    /*锁定日期                               */
gfc10       date,                    /*最后下载日期                           */
gfc11       date,                    /*最后上载日期                           */
gfc12       varchar2(255)            /*档案下载位置                           */
);

create unique index gfc_pk on gfc_file (gfc01,gfc02);
alter table gfc_file add  constraint gfc_pk primary key  (gfc01,gfc02) enable validate;
grant select on gfc_file to public;
grant index on gfc_file to public;
grant update on gfc_file to public;
grant delete on gfc_file to public;
grant insert on gfc_file to public;