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