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