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