/* ================================================================================ 档案代号:vab_file 档案名称:aps 日行事历 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table vab_file ( vab01 varchar2(60) DEFAULT '' NOT NULL, /*日行事历编号*/ vab02 date DEFAULT sysdate NOT NULL, /*日期*/ vab03 varchar2(60) /*工作模式 */ ); create unique index vab_pk on vab_file (vab01,vab02); alter table vab_file add constraint vab_pk primary key (vab01,vab02) enable validate; grant select on vab_file to public; grant index on vab_file to public; grant update on vab_file to public; grant delete on vab_file to public; grant insert on vab_file to public; |