/* ================================================================================ 档案代号:vmw_file 档案名称:aps 制令、工单维护档 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table vmw_file ( vmw01 varchar2(16) DEFAULT '' NOT NULL, /*制令编号*/ vmw02 varchar2(60) /*供给法则编号 */ ); create unique index vmw_pk on vmw_file (vmw01); alter table vmw_file add constraint vmw_pk primary key (vmw01) enable validate; grant select on vmw_file to public; grant index on vmw_file to public; grant update on vmw_file to public; grant delete on vmw_file to public; grant insert on vmw_file to public; |