/* ================================================================================ 档案代号:vzx_file 档案名称: 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table vzx_file ( vzx00 varchar2(10) DEFAULT '' NOT NULL, /*营运中心*/ vzx01 varchar2(10) DEFAULT '' NOT NULL, /*限定版本*/ vzx02 varchar2(10) DEFAULT '' NOT NULL, /*储存版本*/ vzx03 number(1) DEFAULT '0' NOT NULL, /*是否可排程*/ vzx04 date DEFAULT sysdate NOT NULL /*修改日期*/ ); create unique index vzx_pk on vzx_file (vzx00,vzx01,vzx02,vzx03,vzx04); alter table vzx_file add constraint vzx_pk primary key (vzx00,vzx01,vzx02,vzx03,vzx04) enable validate; grant select on vzx_file to public; grant index on vzx_file to public; grant update on vzx_file to public; grant delete on vzx_file to public; grant insert on vzx_file to public; |