/* ================================================================================ 档案代号:vbc_file 档案名称: 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table vbc_file ( vbc01 varchar2(10) DEFAULT '' NOT NULL, /*资源编号*/ vbc02 date DEFAULT sysdate NOT NULL, /*日期*/ vbc03 number(9) DEFAULT '0' NOT NULL, /*开始时间(整数)*/ vbc04 number(9), /*结束时间(整数) */ vbc05 number(1) /*是否排程 */ ); create unique index vbc_pk on vbc_file (vbc01,vbc02,vbc03); alter table vbc_file add constraint vbc_pk primary key (vbc01,vbc02,vbc03) enable validate; grant select on vbc_file to public; grant index on vbc_file to public; grant update on vbc_file to public; grant delete on vbc_file to public; grant insert on vbc_file to public; |