/*
================================================================================
档案代号:gen_file
档案名称:员工姓名资料
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table gen_file
(
gen01       varchar2(10) NOT NULL,   /*员工编号                               */
gen02       varchar2(40),            /*员工姓名                               */
gen03       varchar2(10),            /*所属部门编号                           */
gen04       varchar2(80),            /*职称                                   */
gen05       varchar2(5),             /*分机                                   */
gen06       varchar2(80),            /*E-mail                                 */
                                     /*E-mail #03/02/11 add                   */
genacti     varchar2(1),             /*资料有效码                             */
genuser     varchar2(10),            /*资料所有者                             */
gengrup     varchar2(10),            /*资料所有部门                           */
genmodu     varchar2(10),            /*资料修改者                             */
gendate     date                     /*最近修改日                             */
);

create unique index gen_pk on gen_file (gen01);
alter table gen_file add  constraint gen_pk primary key  (gen01) enable validate;
grant select on gen_file to public;
grant index on gen_file to public;
grant update on gen_file to public;
grant delete on gen_file to public;
grant insert on gen_file to public;