/* ================================================================================ 档案代号:zbb_file 档案名称:客户人员档 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table zbb_file ( zbb01 varchar2(3) NOT NULL, /*客户编号 */ /*客户编号 Ex:GVC,EMC,TYC,AOC... */ zbb02 number(5), /*显示顺序 */ zbb03 varchar2(80) NOT NULL /*人员名称 */ ); create unique index zbb_pk on zbb_file (zbb01,zbb03); alter table zbb_file add constraint zbb_pk primary key (zbb01,zbb03) enable validate; grant select on zbb_file to public; grant index on zbb_file to public; grant update on zbb_file to public; grant delete on zbb_file to public; grant insert on zbb_file to public; |