/* ================================================================================ 档案代号:zab_file 档案名称:报表备注维护作业 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table zab_file ( zab01 varchar2(6) NOT NULL, /*备注代码 */ zab02 varchar2(80), /*备注名称 */ zab03 varchar2(1) NOT NULL, /*行序 */ zab04 varchar2(1) NOT NULL, /*语言别 */ zab05 varchar2(1000) /*备注内容 */ ); create unique index zab_pk on zab_file (zab01,zab03,zab04); alter table zab_file add constraint zab_pk primary key (zab01,zab03,zab04) enable validate; grant select on zab_file to public; grant index on zab_file to public; grant update on zab_file to public; grant delete on zab_file to public; grant insert on zab_file to public; |