/*
================================================================================
档案代号:apsirm
档案名称:APS 品项途程
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table apsirm
(
pid         varchar2(40) NOT NULL,   /*料号                                   */
route_id    varchar2(32) NOT NULL,   /*途程编号                               */
sequ_num    number(4),               /*途程序号                               */
ict         number(16,4),            /*理想周期时间因子                       */
eff_st      date,                    /*生效日                                 */
eff_et      date,                    /*失效日                                 */
is_alt      number(4)                /*是否可被当成替代途程(0:否 1:           */
);

create unique index apsirm_pk on apsirm (pid,route_id);
alter table apsirm add  constraint apsirm_pk primary key  (pid,route_id) enable validate;
grant select on apsirm to public;
grant index on apsirm to public;
grant update on apsirm to public;
grant delete on apsirm to public;
grant insert on apsirm to public;