/*
================================================================================
档案代号:apsocm
档案名称:APS 需求订单选配
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table apsocm
(
opt_pid     varchar2(40) NOT NULL,   /*Option 件料号                          */
feat_pid    varchar2(40) NOT NULL,   /*Feature件料号                          */
do_id       varchar2(32) NOT NULL,   /*需求订单编号                           */
seq_txt     varchar2(32) NOT NULL    /*元件序号                               */
);

create unique index apsocm_pk on apsocm (opt_pid,feat_pid,do_id,seq_txt);
alter table apsocm add  constraint apsocm_pk primary key  (opt_pid,feat_pid,do_id,seq_txt) enable validate;
grant select on apsocm to public;
grant index on apsocm to public;
grant update on apsocm to public;
grant delete on apsocm to public;
grant insert on apsocm to public;