/*
================================================================================
档案代号:aps_ecb
档案名称:APS 途程制程维护档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table aps_ecb
(
route_id    varchar2(32) NOT NULL,   /*途程编号                               */
sequ_num    varchar2(32) NOT NULL,   /*途程序号                               */
op_id       varchar2(32) NOT NULL,   /*作业编号                               */
eqg_id      varchar2(32),            /*设备群组编号                           */
is_batch    number(4),               /*是否是批次(Batch)作业的资源            */
pre_ps_t    number(10),              /*加工前置时间                           */
lotpos_t    number(10),              /*批量后置时间                           */
eqpos_t     number(10),              /*设备后置时间                           */
trans_qty   number(10),              /*移转批量大小                           */
base_qty    number(15,3),            /*变动天数的基本数量                     */
max_eqnm    number(10),              /*最大平行机台数                         */
min_emq     number(15,3),            /*最小平行加工经济批量                   */
altop_p     number(10),              /*替代作业的优先次序                     */
max_bsiz    number(10),              /*批次加工上限                           */
min_bsiz    number(15,3)             /*批次加工下限                           */
);

create unique index aps_ecb_pk on aps_ecb (route_id,sequ_num,op_id);
alter table aps_ecb add  constraint aps_ecb_pk primary key  (route_id,sequ_num,op_id) enable validate;
grant select on aps_ecb to public;
grant index on aps_ecb to public;
grant update on aps_ecb to public;
grant delete on aps_ecb to public;
grant insert on aps_ecb to public;