/* ================================================================================ 档案代号:apscmm 档案名称:APS 顾客 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table apscmm ( cm_id varchar2(32) NOT NULL, /*客户代号 */ cmg_id varchar2(40) NOT NULL, /*客户群组编号 */ cm_name varchar2(32), /*客户名称 */ cmg_name varchar2(32) /*客户群组名称 */ ); create unique index apscmm_pk on apscmm (cm_id,cmg_id); alter table apscmm add constraint apscmm_pk primary key (cm_id,cmg_id) enable validate; grant select on apscmm to public; grant index on apscmm to public; grant update on apscmm to public; grant delete on apscmm to public; grant insert on apscmm to public; |