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