/* ================================================================================ 档案代号:zr_file 档案名称:程式档案关连档 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table zr_file ( zr01 varchar2(20) NOT NULL, /*程式编号 */ zr02 varchar2(15) NOT NULL, /*档案编号 */ zr03 varchar2(1) NOT NULL /*异动别 */ /*异动别 (Insert/Update/Delete/Select) */ ); create unique index zr_pk on zr_file (zr01,zr02,zr03); alter table zr_file add constraint zr_pk primary key (zr01,zr02,zr03) enable validate; grant select on zr_file to public; grant index on zr_file to public; grant update on zr_file to public; grant delete on zr_file to public; grant insert on zr_file to public; |