/* ================================================================================ 档案代号:cpz_file 档案名称:员工基本资料备注档 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table cpz_file ( cpz01 varchar2(10) NOT NULL, /*员工代号 */ cpz02 number(5) NOT NULL, /*行序 */ cpz03 varchar2(120) /*说明 */ ); create unique index cpz_pk on cpz_file (cpz01,cpz02); alter table cpz_file add constraint cpz_pk primary key (cpz01,cpz02) enable validate; grant select on cpz_file to public; grant index on cpz_file to public; grant update on cpz_file to public; grant delete on cpz_file to public; grant insert on cpz_file to public; |