/* ================================================================================ 档案代号:apsdcm 档案名称:APS 日行事历 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table apsdcm ( dcaln_id varchar2(32) NOT NULL, /*日行事历 */ d_date date NOT NULL, /*日期 */ wm_id varchar2(32) /*工作模式 */ ); create unique index apsdcm_pk on apsdcm (dcaln_id,d_date); alter table apsdcm add constraint apsdcm_pk primary key (dcaln_id,d_date) enable validate; grant select on apsdcm to public; grant index on apsdcm to public; grant update on apsdcm to public; grant delete on apsdcm to public; grant insert on apsdcm to public; |