/*
================================================================================
档案代号:aps_sad
档案名称:APS 日行事历维护档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table aps_sad
(
dcaln_id    varchar2(32) NOT NULL,   /*日行事历                               */
d_date      date NOT NULL,           /*日期                                   */
wm_id       varchar2(32)             /*工作模式                               */
);

create unique index aps_sad_pk on aps_sad (dcaln_id,d_date);
alter table aps_sad add  constraint aps_sad_pk primary key  (dcaln_id,d_date) enable validate;
grant select on aps_sad to public;
grant index on aps_sad to public;
grant update on aps_sad to public;
grant delete on aps_sad to public;
grant insert on aps_sad to public;