/*
================================================================================
档案代号:aps_eci
档案名称:APS 设备维护档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table aps_eci
(
eq_id       varchar2(32) NOT NULL,   /*设备编号                               */
wcaln_id    varchar2(32),            /*周行事历                               */
dcaln_id    varchar2(32),            /*日行事历                               */
eq_type     number(4)                /*产能型态(0:有限产能 1:无限产           */
);

create unique index aps_eci_pk on aps_eci (eq_id);
alter table aps_eci add  constraint aps_eci_pk primary key  (eq_id) enable validate;
grant select on aps_eci to public;
grant index on aps_eci to public;
grant update on aps_eci to public;
grant delete on aps_eci to public;
grant insert on aps_eci to public;