/*
================================================================================
档案代号:gel_file
档案名称:编码类别资料单身档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table gel_file
(
gel01       varchar2(10) NOT NULL,   /*编码类别                               */
gel02       number(5) NOT NULL,      /*段次                                   */
gel03       number(5),               /*长度                                   */
gel04       varchar2(1),             /*型态                                   */
gel05       varchar2(10),            /*固定值/独立段编号                      */
gel06       varchar2(80),            /*段次说明                               */
gel07       varchar2(1)              /*名称显示否                             */
);

create unique index gel_pk on gel_file (gel01,gel02);
alter table gel_file add  constraint gel_pk primary key  (gel01,gel02) enable validate;
grant select on gel_file to public;
grant index on gel_file to public;
grant update on gel_file to public;
grant delete on gel_file to public;
grant insert on gel_file to public;