/*
================================================================================
档案代号:ger_file
档案名称:自定义公式单身档（表达式）
档案目的:记录系统自定义公式使用的表达式内容
上游档案:
下游档案:
============.========================.==========================================
*/
create table ger_file
(
ger01       varchar2(20) NOT NULL,   /*公式编号                               */
ger02       number(5) NOT NULL,      /*项次                                   */
ger03       varchar2(20),            /*表达式编号                             */
ger04       varchar2(80),            /*表达式名称                             */
ger05       varchar2(2),             /*No Use                                 */
ger06       varchar2(4),             /*No Use                                 */
ger07       varchar2(1),             /*No Use                                 */
ger08       varchar2(1),             /*No Use                                 */
ger09       varchar2(4),             /*No Use                                 */
ger10       varchar2(4)              /*No Use                                 */
);

create unique index ger_pk on ger_file (ger01,ger02);
alter table ger_file add  constraint ger_pk primary key  (ger01,ger02) enable validate;
grant select on ger_file to public;
grant index on ger_file to public;
grant update on ger_file to public;
grant delete on ger_file to public;
grant insert on ger_file to public;