/* ================================================================================ 档案代号:zh_file 档案名称:统计图型单身档 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table zh_file ( zh01 varchar2(5) NOT NULL, /*图形代号 */ zh02 number(5) NOT NULL, /*ITEM 序号 */ zh03 varchar2(255), /*资料来源-2 */ /* where ab01 = '1101' */ zh04 number(5) /*+/- */ ); create unique index zh_pk on zh_file (zh01,zh02); alter table zh_file add constraint zh_pk primary key (zh01,zh02) enable validate; grant select on zh_file to public; grant index on zh_file to public; grant update on zh_file to public; grant delete on zh_file to public; grant insert on zh_file to public; |