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