/* ================================================================================ 档案代号:zaw_file 档案名称:CR报表格式设定档 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table zaw_file ( zaw01 varchar2(20) NOT NULL, /*程式代号 */ zaw02 varchar2(30) NOT NULL, /*样板代号 */ zaw03 varchar2(1) NOT NULL, /*客制否 */ zaw04 varchar2(10) NOT NULL, /*权限类别 */ zaw05 varchar2(10) NOT NULL, /*使用者 */ zaw06 varchar2(1) NOT NULL, /*语言别 */ zaw07 number(5) NOT NULL, /*序号 */ zaw08 varchar2(80), /*cr样板名称(.rpt) */ zaw09 varchar2(80), /*cr样板说明 */ zaw10 varchar2(10) DEFAULT 'std' NOT NULL, /*行业别*/ zaw11 varchar2(1), /*no use */ zaw12 varchar2(1), /*no use */ zawdate date, /*最近修改日 */ zawgrup varchar2(10), /*资料所有部门 */ zawmodu varchar2(10), /*资料修改者 */ zawuser varchar2(10) /*资料所有者 */ ); create unique index zaw_pk on zaw_file (zaw01,zaw02,zaw03,zaw04,zaw05,zaw06,zaw07,zaw10); alter table zaw_file add constraint zaw_pk primary key (zaw01,zaw02,zaw03,zaw04,zaw05,zaw06,zaw07,zaw10) enable validate; grant select on zaw_file to public; grant index on zaw_file to public; grant update on zaw_file to public; grant delete on zaw_file to public; grant insert on zaw_file to public; |