/* ================================================================================ 档案代号:vzv_file 档案名称: 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table vzv_file ( vzv00 varchar2(10) DEFAULT '' NOT NULL, /*营运中心*/ vzv01 varchar2(10) DEFAULT '' NOT NULL, /*限定版本*/ vzv02 varchar2(10) DEFAULT '' NOT NULL, /*储存版本*/ vzv03 date DEFAULT sysdate NOT NULL, /*讯息接收时间*/ vzv04 varchar2(30), /*讯息代号 */ vzv05 varchar2(80), /*讯息说明 */ vzv06 varchar2(1), /*讯息状态 */ vzv07 varchar2(1), /*tiptop执行结果 */ vzv08 varchar2(10) /*操作人员代号 */ ); create unique index vzv_pk on vzv_file (vzv00,vzv01,vzv02,vzv03); alter table vzv_file add constraint vzv_pk primary key (vzv00,vzv01,vzv02,vzv03) enable validate; grant select on vzv_file to public; grant index on vzv_file to public; grant update on vzv_file to public; grant delete on vzv_file to public; grant insert on vzv_file to public; |