/* ================================================================================ 档案代号:azc_file 档案名称:签核等级档 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table azc_file ( azc01 varchar2(4) NOT NULL, /*签核等级 */ azc02 number(5) NOT NULL, /*顺序 */ azc03 varchar2(10), /*人员代码 */ azc04 varchar2(255) /*备注 */ ); create unique index azc_pk on azc_file (azc01,azc02); alter table azc_file add constraint azc_pk primary key (azc01,azc02) enable validate; grant select on azc_file to public; grant index on azc_file to public; grant update on azc_file to public; grant delete on azc_file to public; grant insert on azc_file to public; |