/*
================================================================================
档案代号:apswmm
档案名称:APS 工作模式
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table apswmm
(
wm_id       varchar2(32) NOT NULL,   /*工作模式                               */
st_t        number(16,4) NOT NULL,   /*每日的开始工作时段                     */
ed_t        number(16,4),            /*每日的结束工作时段                     */
wk_type     number(4),               /*工作模式型别                           */
wm_name     varchar2(60),            /*工作模式名称                           */
wm_des      varchar2(60)             /*工作模式描述                           */
);

create unique index apswmm_pk on apswmm (wm_id,st_t);
alter table apswmm add  constraint apswmm_pk primary key  (wm_id,st_t) enable validate;
grant select on apswmm to public;
grant index on apswmm to public;
grant update on apswmm to public;
grant delete on apswmm to public;
grant insert on apswmm to public;