/*
================================================================================
档案代号:fjd_file
档案名称:设备系列型号资料单身档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table fjd_file
(
fjd01       varchar2(30) NOT NULL,   /*系列号                                 */
fjd02       varchar2(30) NOT NULL,   /*型号                                   */
fjd03       number(5) NOT NULL,      /*项次                                   */
fjd04       varchar2(70),            /*文件路径档名                           */
fjd05       varchar2(1),             /*No Use                                 */
fjd06       varchar2(1),             /*No Use                                 */
fjd07       varchar2(1),             /*No Use                                 */
fjd08       varchar2(1),             /*No Use                                 */
fjd09       varchar2(1)              /*No Use                                 */
);

create unique index fjd_pk on fjd_file (fjd01,fjd02,fjd03);
alter table fjd_file add  constraint fjd_pk primary key  (fjd01,fjd02,fjd03) enable validate;
grant select on fjd_file to public;
grant index on fjd_file to public;
grant update on fjd_file to public;
grant delete on fjd_file to public;
grant insert on fjd_file to public;