/* ================================================================================ 档案代号: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; |