|

楼主 |
发表于 2008-8-22 15:46:42
|
显示全部楼层
create table TPERSON
(
FGUID VARCHAR2(32) not null,
FCLIENTACCOUNT VARCHAR2(64) not null,
FID VARCHAR2(64) not null,
FDISPLAYNAME VARCHAR2(64) not null,
FDEPTID VARCHAR2(64),
FLOGINID VARCHAR2(64),
FDELETELEVEL INTEGER not null,
FPROPERTY BLOB,
FACCOUNTCODE VARCHAR2(60),
ESEX INTEGER,
EBIRTHDAY DATE,
EJOINDATE DATE,
ENATIVEPLACE VARCHAR2(32),
EHIGHEDUCATION INTEGER,
ECOLLEGE VARCHAR2(32),
ESPECIALITY VARCHAR2(32),
EEDUCTIONALSYSTME VARCHAR2(8),
ETECHNICALTITLE VARCHAR2(32),
EMARRIED INTEGER,
EIDCARD VARCHAR2(20),
ETELPHONE1 VARCHAR2(16),
ETELPHONE2 VARCHAR2(16),
ETELPHONE3 VARCHAR2(16),
EREGISTEREDRESIDENCE VARCHAR2(64),
ERESIDENCE VARCHAR2(64),
EMAILNUMBER VARCHAR2(10),
EE_MAIL VARCHAR2(64),
EMSN VARCHAR2(32),
EQQ VARCHAR2(12),
EDESCRIPTION VARCHAR2(128)
)
alter table TPERSON
add primary key (FGUID, FCLIENTACCOUNT);
是这张表?那个字段保存密码的呢?还有密码的加密算法是什么?需要进行人员信息同步 |
|