/*
================================================================================
档案代号:fja_file
档案名称:设备保修规模档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table fja_file
(
fja01       varchar2(2) NOT NULL,    /*保修规模编号                           */
fja02       varchar2(80),            /*说明                                   */
fjaacti     varchar2(1),             /*资料有效码                             */
fjauser     varchar2(10),            /*资料所有者                             */
fjagrup     varchar2(10),            /*资料所有部门                           */
fjamodu     varchar2(10),            /*最后修改人员                           */
fjadate     date                     /*最后修改日期                           */
);

create unique index fja_pk on fja_file (fja01);
alter table fja_file add  constraint fja_pk primary key  (fja01) enable validate;
grant select on fja_file to public;
grant index on fja_file to public;
grant update on fja_file to public;
grant delete on fja_file to public;
grant insert on fja_file to public;