/* ================================================================================ 档案代号:fip_file 档案名称:保修项目作业资料档 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table fip_file ( fip01 varchar2(10) NOT NULL, /*项目编号 */ fip02 number(5) NOT NULL, /*项目序 */ fip03 varchar2(10), /*作业编号 */ fip04 varchar2(1), /*No Use */ fip05 varchar2(1), /*No Use */ fip06 varchar2(1) /*No Use */ ); create unique index fip_pk on fip_file (fip01,fip02); alter table fip_file add constraint fip_pk primary key (fip01,fip02) enable validate; grant select on fip_file to public; grant index on fip_file to public; grant update on fip_file to public; grant delete on fip_file to public; grant insert on fip_file to public; |