/*
================================================================================
档案代号:fjh_file
档案名称:设备系统单据性质档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table fjh_file
(
fjhslip     varchar2(5) NOT NULL,    /*单别                                   */
fjhdesc     varchar2(80),            /*单据名称                               */
fjhauno     varchar2(1),             /*自动编号否 (y/n)                       */
fjhkind     varchar2(1),             /*编号方式                               */
fjhconf     varchar2(1),             /*立即确认                               */
fjhprit     varchar2(1),             /*立即列印                               */
fjhtype     varchar2(2),             /*单据性质                               */
                                     /* 01.设备工单       02.设备检查单        */
                                     /* 03.设备发料单     04.设备退料单       */
fjhacti     varchar2(1),             /*资料有效码                             */
fjhuser     varchar2(10),            /*资料所有者                             */
fjhgrup     varchar2(10),            /*资料所有部门                           */
fjhmodu     varchar2(10),            /*资料修改者                             */
fjhdate     date                     /*最近修改日                             */
);

create unique index fjh_pk on fjh_file (fjhslip);
alter table fjh_file add  constraint fjh_pk primary key  (fjhslip) enable validate;
grant select on fjh_file to public;
grant index on fjh_file to public;
grant update on fjh_file to public;
grant delete on fjh_file to public;
grant insert on fjh_file to public;