/*
================================================================================
档案代号:gal_file
档案名称:程式联结资料维护单身档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table gal_file
(
gal01       varchar2(20) NOT NULL,   /*Link 程式代码                          */
                                     /*LINK程式                               */
gal02       varchar2(5) NOT NULL,    /*系统                                   */
gal03       varchar2(80) NOT NULL,   /*程式名称                               */
gal04       varchar2(1)              /*客制否                                 */
                                     /*是否链结个案区 Y/N                     */
);

create unique index gal_pk on gal_file (gal01,gal02,gal03);
alter table gal_file add  constraint gal_pk primary key  (gal01,gal02,gal03) enable validate;
grant select on gal_file to public;
grant index on gal_file to public;
grant update on gal_file to public;
grant delete on gal_file to public;
grant insert on gal_file to public;