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