/* ================================================================================ 档案代号:aps_smm 档案名称:APS 制令、工单维护档 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table aps_smm ( mo_id varchar2(32) NOT NULL, /*制令编号 */ sply_rid varchar2(32) /*供给法则编号 */ ); create unique index aps_smm_pk on aps_smm (mo_id); alter table aps_smm add constraint aps_smm_pk primary key (mo_id) enable validate; grant select on aps_smm to public; grant index on aps_smm to public; grant update on aps_smm to public; grant delete on aps_smm to public; grant insert on aps_smm to public; |