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