/* ================================================================================ 档案代号:vnf_file 档案名称:aps 制令外包维护档 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table vnf_file ( vnf01 varchar2(16) DEFAULT '' NOT NULL, /*制令编号*/ vnf03 number(1), /*外包类型 */ vnf07 number(1) /*是否已排程 */ ); create unique index vnf_pk on vnf_file (vnf01); alter table vnf_file add constraint vnf_pk primary key (vnf01) enable validate; grant select on vnf_file to public; grant index on vnf_file to public; grant update on vnf_file to public; grant delete on vnf_file to public; grant insert on vnf_file to public; |