/*
================================================================================
档案代号:zmm_file
档案名称:使用者我的最爱目录档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table zmm_file
(
zmm01       varchar2(10) NOT NULL,   /*使用者代号                             */
zmm03       varchar2(20) NOT NULL    /*程式代号                               */
                                     /*程式代号(Program code)                 */
);

create unique index zmm_pk on zmm_file (zmm01,zmm03);
alter table zmm_file add  constraint zmm_pk primary key  (zmm01,zmm03) enable validate;
grant select on zmm_file to public;
grant index on zmm_file to public;
grant update on zmm_file to public;
grant delete on zmm_file to public;
grant insert on zmm_file to public;