/* ================================================================================ 档案代号:rqa_file 档案名称:每日资源维护作业 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table rqa_file ( rqa01 varchar2(10) NOT NULL, /*资源代号 */ rqa02 varchar2(10) NOT NULL, /*版本 */ rqa03 date NOT NULL, /*起始日期 */ rqa04 date NOT NULL, /*截止日期 */ rqa05 number(15,3), /*当日产能 */ rqa06 number(15,3), /*已秏产能 */ rqa07 varchar2(255), /*备注 */ rqa08 varchar2(1) /*No Use */ ); create unique index rqa_pk on rqa_file (rqa01,rqa02,rqa03,rqa04); alter table rqa_file add constraint rqa_pk primary key (rqa01,rqa02,rqa03,rqa04) enable validate; grant select on rqa_file to public; grant index on rqa_file to public; grant update on rqa_file to public; grant delete on rqa_file to public; grant insert on rqa_file to public; |