/* ================================================================================ 档案代号:gcf_file 档案名称:V-Point Exporess 站台参数设定档 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table gcf_file ( gcf01 varchar2(10) NOT NULL, /*TIPTOP 营运中心 */ gcf02 varchar2(1) NOT NULL, /*Express 站台设定 */ gcf03 varchar2(15) NOT NULL, /*Express 站台 IP 位址 */ gcf04 varchar2(30) NOT NULL, /*Express 站台名称 */ gcf05 varchar2(1) NOT NULL, /*Express 资料库 */ gcf06 varchar2(10), /*V-Point Express 站台资料库 */ gcf07 varchar2(10), /*No Use */ gcf08 varchar2(10), /*No Use */ gcf09 varchar2(1), /*Express是否与BI整合 */ gcf10 varchar2(1) /*Express 站台是否为 V-Point4 Express */ ); create unique index gcf_pk on gcf_file (gcf01,gcf02,gcf03,gcf04,gcf05); alter table gcf_file add constraint gcf_pk primary key (gcf01,gcf02,gcf03,gcf04,gcf05) enable validate; grant select on gcf_file to public; grant index on gcf_file to public; grant update on gcf_file to public; grant delete on gcf_file to public; grant insert on gcf_file to public; |