/* ================================================================================ 档案代号:zob_file 档案名称: 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table zob_file ( zob01 varchar2(10) NOT NULL, /*资料代号 */ zob02 varchar2(15) NOT NULL, /*档案代号 */ zob03 varchar2(1), /*必要否 */ zob04 varchar2(1), /*汇入否 */ zob05 varchar2(1) /*仅汇出人工输入字段 */ ); create unique index zob_pk on zob_file (zob01,zob02); alter table zob_file add constraint zob_pk primary key (zob01,zob02) enable validate; grant select on zob_file to public; grant index on zob_file to public; grant update on zob_file to public; grant delete on zob_file to public; grant insert on zob_file to public; |