/* ================================================================================ 档案代号:voh_file 档案名称: 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table voh_file ( voh00 varchar2(10) DEFAULT '' NOT NULL, /*营运中心*/ voh01 varchar2(10) DEFAULT '' NOT NULL, /*限定版本*/ voh02 varchar2(10) DEFAULT '' NOT NULL, /*储存版本*/ voh03 varchar2(16) DEFAULT '' NOT NULL, /*制令编号*/ voh04 number(1), /*是否数量变更 */ voh05 number(1), /*是否日期变更 */ voh06 number(1), /*是否使用制令制程资料 */ voh07 varchar2(1) /*变更码 */ ); create unique index voh_pk on voh_file (voh00,voh01,voh02,voh03); alter table voh_file add constraint voh_pk primary key (voh00,voh01,voh02,voh03) enable validate; grant select on voh_file to public; grant index on voh_file to public; grant update on voh_file to public; grant delete on voh_file to public; grant insert on voh_file to public; |