/* ================================================================================ 档案代号:stj_file 档案名称:在制工单成本调整档 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table stj_file ( stj01 number(5) NOT NULL, /*年度 */ stj02 number(5) NOT NULL, /*月份 */ stj03 varchar2(16) NOT NULL, /*工单号码 */ stj04 number(20,6), /*材料调整金额 */ stj05 number(20,6), /*人工调整金额 */ stj06 number(20,6), /*制费一调整金额 */ stj07 number(20,6), /*制费二调整金额 */ stj08 number(20,6) /*加工费调整金额 */ ); create unique index stj_pk on stj_file (stj01,stj02,stj03); alter table stj_file add constraint stj_pk primary key (stj01,stj02,stj03) enable validate; grant select on stj_file to public; grant index on stj_file to public; grant update on stj_file to public; grant delete on stj_file to public; grant insert on stj_file to public; |