/* ================================================================================ 档案代号:gcg_file 档案名称:V-Point Express 关联报表设定档 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table gcg_file ( gcg01 varchar2(10) NOT NULL, /*TIPTOP 营运中心 */ gcg02 varchar2(1) NOT NULL, /*Express 站台设定 */ gcg03 varchar2(15) NOT NULL, /*Express 站台 IP 位址 */ gcg04 varchar2(10) NOT NULL, /*Express 站台名称 */ gcg05 varchar2(1) NOT NULL, /*Express 资料库 */ gcg06 varchar2(20) NOT NULL, /*程序编号 */ gcg07 varchar2(128) NOT NULL, /*关联报表名称 */ gcg08 varchar2(255) NOT NULL, /*报表 ID */ gcg09 varchar2(128), /*关联报表名称 */ gcg10 varchar2(255), /*报表ID */ gcg11 varchar2(5) NOT NULL, /*报表型态 */ gcg12 varchar2(10), /*No Use */ gcg13 varchar2(10) /*No Use */ ); create unique index gcg_pk on gcg_file (gcg01,gcg02,gcg03,gcg04,gcg05,gcg06,gcg07,gcg11); alter table gcg_file add constraint gcg_pk primary key (gcg01,gcg02,gcg03,gcg04,gcg05,gcg06,gcg07,gcg11) enable validate; grant select on gcg_file to public; grant index on gcg_file to public; grant update on gcg_file to public; grant delete on gcg_file to public; grant insert on gcg_file to public; |