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

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