/* ================================================================================ 档案代号:vma_file 档案名称:aps 工作模式维护档 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table vma_file ( vma01 varchar2(60) DEFAULT '' NOT NULL, /*工作模式编号*/ vma02 number(9) DEFAULT '0' NOT NULL, /*开始时间(整数)*/ vma03 number(9) DEFAULT '0' NOT NULL, /*结束时间(整数)*/ vma04 number(1), /*工作型态 */ vma05 varchar2(60), /*工作模式名称 */ vma06 varchar2(60) /*工作模式描述 */ ); create unique index vma_pk on vma_file (vma01,vma02); alter table vma_file add constraint vma_pk primary key (vma01,vma02) enable validate; grant select on vma_file to public; grant index on vma_file to public; grant update on vma_file to public; grant delete on vma_file to public; grant insert on vma_file to public; |