/*
================================================================================
档案代号:fjg_file
档案名称:设备位置单身档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table fjg_file
(
fjg01       varchar2(20) NOT NULL,   /*上层位置                               */
fjg02       varchar2(20) NOT NULL,   /*项次                                   */
fjg03       number(5) NOT NULL,      /*下层位置                               */
fjg04       varchar2(20),            /*营运中心编号                           */
fjg05       varchar2(20),            /*营运中心编号                           */
fjg06       varchar2(1),             /*No Use                                 */
fjg07       varchar2(1),             /*No Use                                 */
fjg08       varchar2(1),             /*No Use                                 */
fjg09       varchar2(1),             /*No Use                                 */
fjg10       varchar2(1)              /*No Use                                 */
);

create unique index fjg_pk on fjg_file (fjg01,fjg02,fjg03);
alter table fjg_file add  constraint fjg_pk primary key  (fjg01,fjg02,fjg03) enable validate;
grant select on fjg_file to public;
grant index on fjg_file to public;
grant update on fjg_file to public;
grant delete on fjg_file to public;
grant insert on fjg_file to public;