/*
================================================================================
档案代号:aps_sae
档案名称:APS 工作模式
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table aps_sae
(
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 aps_sae_pk on aps_sae (wm_id,st_t);
alter table aps_sae add  constraint aps_sae_pk primary key  (wm_id,st_t) enable validate;
grant select on aps_sae to public;
grant index on aps_sae to public;
grant update on aps_sae to public;
grant delete on aps_sae to public;
grant insert on aps_sae to public;