/* ================================================================================ 档案代号:aps_spm 档案名称:APS 采购令维护档 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table aps_spm ( po_id varchar2(32) NOT NULL, /*采购单编号 */ is_hold number(4), /*否为保留状态 */ sply_rid varchar2(32) /*供给法则编号 */ ); create unique index aps_spm_pk on aps_spm (po_id); alter table aps_spm add constraint aps_spm_pk primary key (po_id) enable validate; grant select on aps_spm to public; grant index on aps_spm to public; grant update on aps_spm to public; grant delete on aps_spm to public; grant insert on aps_spm to public; |