/* ================================================================================ 档案代号:dpg_file 档案名称:员工体检资料单头档 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table dpg_file ( dpg01 varchar2(10) NOT NULL, /*员工代号 */ dpg02 date NOT NULL, /*体检日期 */ dpg03 varchar2(6) NOT NULL, /*体检项目 */ dpg04 varchar2(1), /*正常否 */ dpg05 varchar2(80), /*状况说明 */ dpg06 varchar2(1) /*No Use */ ); create unique index dpg_pk on dpg_file (dpg01,dpg02,dpg03); alter table dpg_file add constraint dpg_pk primary key (dpg01,dpg02,dpg03) enable validate; grant select on dpg_file to public; grant index on dpg_file to public; grant update on dpg_file to public; grant delete on dpg_file to public; grant insert on dpg_file to public; |