/*
================================================================================
档案代号:fjc_file
档案名称:设备保修项目资料档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table fjc_file
(
fjc01       varchar2(20) NOT NULL,   /*设备编号                               */
fjc02       number(5) NOT NULL,      /*项次                                   */
fjc03       varchar2(10),            /*保修类别                               */
fjc04       varchar2(1),             /*保养周期                               */
fjc05       varchar2(2),             /*保修规模                               */
fjc06       varchar2(1)              /*停机否                                 */
);

create unique index fjc_pk on fjc_file (fjc01,fjc02);
alter table fjc_file add  constraint fjc_pk primary key  (fjc01,fjc02) enable validate;
grant select on fjc_file to public;
grant index on fjc_file to public;
grant update on fjc_file to public;
grant delete on fjc_file to public;
grant insert on fjc_file to public;