/* ================================================================================ 档案代号:gci_file 档案名称:Express 报表清单 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table gci_file ( gci01 varchar2(5) NOT NULL, /*报表类型 */ gci02 varchar2(20) NOT NULL, /*报表 ID */ gci03 varchar2(256) NOT NULL, /*报表名称 */ gci04 varchar2(256), /*报表类别 */ gci05 varchar2(30), /*报表 Cuid */ gci06 varchar2(80), /*说明 */ gci07 varchar2(1) /*是否为 Expresss 报表 */ ); create unique index gci_pk on gci_file (gci01,gci02); alter table gci_file add constraint gci_pk primary key (gci01,gci02) enable validate; grant select on gci_file to public; grant index on gci_file to public; grant update on gci_file to public; grant delete on gci_file to public; grant insert on gci_file to public; |