/* ================================================================================ 档案代号:fix_file 档案名称:保修项目人员资料档 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table fix_file ( fix01 varchar2(10) NOT NULL, /*项目编号 */ fix02 number(5) NOT NULL, /*项次 */ fix03 varchar2(6), /*工种 */ fix04 number(8,3), /*预计工时 */ fix05 number(5), /*人数 */ fix06 number(5), /*优先级 */ fix07 varchar2(1), /*No Use */ fix08 varchar2(1), /*No Use */ fix09 varchar2(1), /*No Use */ fix10 varchar2(1) /*No Use */ ); create unique index fix_pk on fix_file (fix01,fix02); alter table fix_file add constraint fix_pk primary key (fix01,fix02) enable validate; grant select on fix_file to public; grant index on fix_file to public; grant update on fix_file to public; grant delete on fix_file to public; grant insert on fix_file to public; |