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