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