/*
================================================================================
档案代号:fjf_file
档案名称:设备位置单头档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table fjf_file
(
fjf01       varchar2(20) NOT NULL,   /*上层位置                               */
fjf02       varchar2(20) NOT NULL,   /*营运中心编号                           */
fjf03       varchar2(1),             /*No Use                                 */
fjf04       varchar2(1),             /*No Use                                 */
fjf05       varchar2(1),             /*No Use                                 */
fjf06       varchar2(1),             /*No Use                                 */
fjf07       varchar2(1),             /*No Use                                 */
fjf08       varchar2(1),             /*No Use                                 */
fjf09       varchar2(1),             /*No Use                                 */
fjf10       varchar2(1),             /*No Use                                 */
fjfacti     varchar2(1),             /*资料有效码                             */
fjfuser     varchar2(10),            /*资料所有者                             */
fjfgrup     varchar2(10),            /*资料所有部门                           */
fjfmodu     varchar2(10),            /*最后修改人员                           */
fjfdate     date                     /*最后修改日期                           */
);

create unique index fjf_pk on fjf_file (fjf01,fjf02);
alter table fjf_file add  constraint fjf_pk primary key  (fjf01,fjf02) enable validate;
grant select on fjf_file to public;
grant index on fjf_file to public;
grant update on fjf_file to public;
grant delete on fjf_file to public;
grant insert on fjf_file to public;