/* ================================================================================ 档案代号:zar_file 档案名称:SQL Wizard Field 记录档 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table zar_file ( zar01 varchar2(80) NOT NULL, /*查询单id */ zar02 varchar2(15) NOT NULL, /*档案代码 */ zar03 varchar2(20) NOT NULL, /*栏位代码 */ zar04 number(5) NOT NULL, /*序号 */ zar05 varchar2(1) NOT NULL /*客制码 */ ); create unique index zar_pk on zar_file (zar01,zar02,zar03,zar05); alter table zar_file add constraint zar_pk primary key (zar01,zar02,zar03,zar05) enable validate; grant select on zar_file to public; grant index on zar_file to public; grant update on zar_file to public; grant delete on zar_file to public; grant insert on zar_file to public; |