/*
================================================================================
档案代号: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;