/* ================================================================================ 档案代号:oce_file 档案名称:客户联络人档 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table oce_file ( oce01 varchar2(10) NOT NULL, /*客户编号 */ oce02 varchar2(40), /*职务 */ oce03 varchar2(40) NOT NULL, /*联络人 */ oce04 varchar2(40), /*联络电话 */ oce05 varchar2(80), /*E-mail address */ oce06 date, /*No Use */ oce07 varchar2(40), /*住宅号码 */ oce08 varchar2(40), /*传真号码 */ oce09 varchar2(255), /*身份证地址 */ oce10 varchar2(20) /*身份证号码 */ ); create unique index oce_pk on oce_file (oce01,oce03); alter table oce_file add constraint oce_pk primary key (oce01,oce03) enable validate; grant select on oce_file to public; grant index on oce_file to public; grant update on oce_file to public; grant delete on oce_file to public; grant insert on oce_file to public; |