/*
================================================================================
档案代号:gak_file
档案名称:程式联结资料维护单头档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table gak_file
(
gak01       varchar2(20) NOT NULL,   /*LINK程式                               */
                                     /* 程式代码                              */
gak02       varchar2(100),           /*No Use                                 */
gak03       varchar2(1000),          /*No Use                                 */
gak04       varchar2(1),             /*No Use                                 */
gak05       varchar2(1),             /*No Use                                 */
gakuser     varchar2(10),            /*OWNER                                  */
                                     /* OWNER                                 */
gakgrup     varchar2(10),            /*GROUP                                  */
                                     /* GROUP                                 */
gakmodu     varchar2(10),            /*MODIFY USER                            */
                                     /* MODIFY USER                           */
gakdate     date                     /*MODIFY DATE                            */
                                     /* MODIFY DATE                           */
);

create unique index gak_pk on gak_file (gak01);
alter table gak_file add  constraint gak_pk primary key  (gak01) enable validate;
grant select on gak_file to public;
grant index on gak_file to public;
grant update on gak_file to public;
grant delete on gak_file to public;
grant insert on gak_file to public;