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