/* ================================================================================ 档案代号:zaz_file 档案名称:Vprint 参数设定档 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table zaz_file ( zaz01 varchar2(10) NOT NULL, /*使用者 */ zaz02 varchar2(10) NOT NULL, /*权限类别 */ zaz03 varchar2(20) NOT NULL, /*程式代码 */ zaz04 varchar2(20) NOT NULL, /*报表列印的样板 */ zaz05 varchar2(80), /*印表机名称 */ zaz06 varchar2(1), /*缩小列印选项 */ zaz07 varchar2(1) /*立即列印否 */ ); create unique index zaz_pk on zaz_file (zaz01,zaz02,zaz03,zaz04); alter table zaz_file add constraint zaz_pk primary key (zaz01,zaz02,zaz03,zaz04) enable validate; grant select on zaz_file to public; grant index on zaz_file to public; grant update on zaz_file to public; grant delete on zaz_file to public; grant insert on zaz_file to public; |