/*
================================================================================
档案代号:aps_dom
档案名称:APS 需求订单维护档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table aps_dom
(
do_id       varchar2(32) NOT NULL,   /*需求订单编号                           */
can_csum    number(4),               /*可否耗用                               */
is_skl      number(4),               /*是否能排程                             */
priority    number(10),              /*优先顺序                               */
allo_rid    varchar2(32),            /*分配法则                               */
ship_day    number(4)                /*运输天数                               */
);

create unique index aps_dom_pk on aps_dom (do_id);
alter table aps_dom add  constraint aps_dom_pk primary key  (do_id) enable validate;
grant select on aps_dom to public;
grant index on aps_dom to public;
grant update on aps_dom to public;
grant delete on aps_dom to public;
grant insert on aps_dom to public;