/*
================================================================================
档案代号:ich_file
档案名称:ICD单价公式计算资料档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table ich_file
(
ich01       varchar2(10) NOT NULL,   /*公式代码                               */
ich02       varchar2(80),            /*公式                                   */
ichacti     varchar2(1),             /*资料有效码                             */
ichdate     date,                    /*资料修改日                             */
ichgrup     varchar2(10),            /*资料所有群                             */
ichmodu     varchar2(10),            /*资料修改者                             */
ichuser     varchar2(10)             /*资料所有者                             */
);

create unique index ich_pk on ich_file (ich01);
alter table ich_file add  constraint ich_pk primary key  (ich01) enable validate;
grant select on ich_file to public;
grant index on ich_file to public;
grant update on ich_file to public;
grant delete on ich_file to public;
grant insert on ich_file to public;