/* ================================================================================ 档案代号:zas_file 档案名称:SQL Wizard 条件式记录档 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table zas_file ( zas01 varchar2(80) NOT NULL, /*查询单id */ zas02 number(5) NOT NULL, /*条件式序号 */ zas03 varchar2(5), /*( */ zas04 varchar2(15), /*档案代码 */ zas05 varchar2(20), /*栏位代码 */ zas06 varchar2(5), /*条件式 */ zas07 varchar2(20), /*档案代码 */ zas08 varchar2(80), /*栏位代码/数值 */ zas09 varchar2(5), /*) */ zas10 varchar2(1), /*or/and */ zas11 varchar2(1) NOT NULL /*客制码 */ ); create unique index zas_pk on zas_file (zas01,zas02,zas11); alter table zas_file add constraint zas_pk primary key (zas01,zas02,zas11) enable validate; grant select on zas_file to public; grant index on zas_file to public; grant update on zas_file to public; grant delete on zas_file to public; grant insert on zas_file to public; |