/*
================================================================================
档案代号:gas_file
档案名称:UI系统变数设定档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table gas_file
(
gas01       varchar2(1) NOT NULL,    /*KEY VALUE (0)                          */
                                     /* VALUE (0)                             */
gas02       varchar2(15),            /*Not Null/Required (Head)               */
                                     /* Null/Required (Head)                  */
gas03       varchar2(15),            /*Not Null/Required (Detail)             */
                                     /*Null/Required (Detail)                 */
gas04       varchar2(15),            /*Key Value (Head/Detail)                */
                                     /*Value (Head/Detail)                    */
gas05       varchar2(15),            /*No Use                                 */
gas06       varchar2(1),             /*No Use                                 */
gas07       varchar2(1),             /*No Use                                 */
gas08       varchar2(1),             /*No Use                                 */
gas09       varchar2(1),             /*No Use                                 */
gas10       varchar2(1)              /*No Use                                 */
);

create unique index gas_pk on gas_file (gas01);
alter table gas_file add  constraint gas_pk primary key  (gas01) enable validate;
grant select on gas_file to public;
grant index on gas_file to public;
grant update on gas_file to public;
grant delete on gas_file to public;
grant insert on gas_file to public;