當(dāng)事人模型14頁

1、1.1. 當(dāng)事人模型1.1.1. 數(shù)據(jù)庫表清單名稱說明ADDRESS_MATCH_MAP地址匹配映射AFFILIATE聯(lián)盟PARTY當(dāng)事人表PARTY_ATTRIBUTE當(dāng)事人屬性表PARTY_CARRIER_ACCOUNT當(dāng)事人承運(yùn)賬戶表PARTY_CLASSIFICATION當(dāng)事人分類表PARTY_CLASSIFICATION_GROUP當(dāng)事人分類組表PARTY_CLASSIFICATION_TYPE當(dāng)事人分類類型表PARTY_CONTENT當(dāng)事人內(nèi)容表PARTY_CONTENT_TYPE當(dāng)事人內(nèi)容類型表PARTY_DATA_SOURCE當(dāng)事人數(shù)據(jù)源表PARTY_GEO_POINT當(dāng)事人地

2、理位置表PARTY_GROUP當(dāng)事人組表PARTY_ICS_AVS_OVERRIDE當(dāng)事人地址驗(yàn)證服務(wù)PARTY_INVITATION當(dāng)事人邀請表PARTY_INVITATION_GROUP_ASSOC當(dāng)事人邀請組關(guān)聯(lián)表PARTY_INVITATION_ROLE_ASSOC當(dāng)事人邀請角色關(guān)聯(lián)表PARTY_NAME_HISTORY當(dāng)事人名稱歷史表PARTY_NOTE當(dāng)事人注釋表PARTY_PROFILE_DEFAULT當(dāng)事人默認(rèn)概況表PARTY_RELATIONSHIP當(dāng)事人關(guān)系表PARTY_RELATIONSHIP_TYPE當(dāng)事人關(guān)系類型表PARTY_ROLE當(dāng)事人角色表PARTY_STATU

3、S當(dāng)事人狀態(tài)表PARTY_TYPE當(dāng)事人類型表PARTY_TYPE_ATTR當(dāng)事人類型屬性表PERSON人員表PRIORITY_TYPE優(yōu)先類型表ROLE_TYPE角色類型表ROLE_TYPE_ATTR角色類型屬性表VENDOR賣方記錄表1.1.2. ADDRESS_MATCH_MAP名稱說明數(shù)據(jù)類型主鍵/外鍵/非空MAP_KEY映射鍵VARCHAR(255)PMAP_VALUE映射值VARCHAR(255)PSEQUENCE_NUM序號數(shù)字DECIMAL(20)LAST_UPDATED_STAMP最后更新時(shí)間TIMESTAMPLAST_UPDATED_TX_STAMP最后更新事務(wù)時(shí)間TIME

4、STAMPCREATED_STAMP創(chuàng)建時(shí)間TIMESTAMPCREATED_TX_STAMP創(chuàng)建事務(wù)時(shí)間TIMESTAMP1.1.3. AFFILIATE名稱說明數(shù)據(jù)類型主鍵/外鍵/非空PARTY_ID當(dāng)事人編號VARCHAR(20)PAFFILIATE_NAME聯(lián)盟名稱VARCHAR(100)AFFILIATE_DESCRIPTION聯(lián)盟描述VARCHAR(255)YEAR_ESTABLISHED創(chuàng)建的年份VARCHAR(10)SITE_TYPE站點(diǎn)類型VARCHAR(255)SITE_PAGE_VIEWS站點(diǎn)頁面顯示VARCHAR(255)SITE_VISITORS站點(diǎn)訪問者VARCHA

5、R(255)DATE_TIME_CREATED創(chuàng)建日期時(shí)間TIMESTAMPDATE_TIME_APPROVED批準(zhǔn)日期時(shí)間TIMESTAMPLAST_UPDATED_STAMP最后更新時(shí)間TIMESTAMPLAST_UPDATED_TX_STAMP最后更新事務(wù)時(shí)間TIMESTAMPCREATED_STAMP創(chuàng)建時(shí)間TIMESTAMPCREATED_TX_STAMP創(chuàng)建事務(wù)時(shí)間TIMESTAMP1.1.4. PARTY名稱說明數(shù)據(jù)類型主鍵/外鍵/非空PARTY_ID當(dāng)事人標(biāo)識VARCHAR(20)PPARTY_TYPE_ID當(dāng)事人類型標(biāo)識VARCHAR(20)EXTERNAL_ID外部標(biāo)識VA

6、RCHAR(20)PREFERRED_CURRENCY_UOM_ID優(yōu)先使用幣種VARCHAR(20)DESCRIPTION描述VARCHAR(400)STATUS_ID狀態(tài)VARCHAR(20)CREATED_DATE創(chuàng)建日期TIMESTAMPCREATED_BY_USER_LOGIN創(chuàng)建的用戶登錄標(biāo)識VARCHAR(255)LAST_MODIFIED_DATE最后修改日期TIMESTAMPLAST_MODIFIED_BY_USER_LOGIN最后修改的用戶登錄標(biāo)識VARCHAR(255)DATA_SOURCE_ID數(shù)據(jù)源標(biāo)識VARCHAR(20)IS_UNREAD是否沒有人看的CHARAC

7、TER(1)LAST_UPDATED_STAMP最后更新時(shí)間TIMESTAMPLAST_UPDATED_TX_STAMP最后更新事務(wù)時(shí)間TIMESTAMPCREATED_STAMP創(chuàng)建時(shí)間TIMESTAMPCREATED_TX_STAMP創(chuàng)建事務(wù)時(shí)間TIMESTAMP1.1.5. PARTY_ATTRIBUTE名稱說明數(shù)據(jù)類型主鍵/外鍵/非空PARTY_ID會員標(biāo)識VARCHAR(20)PATTR_NAME屬性名VARCHAR(60)PATTR_VALUE屬性值VARCHAR(255)LAST_UPDATED_STAMP最后更新時(shí)間TIMESTAMPLAST_UPDATED_TX_STAMP最

8、后更新事務(wù)時(shí)間TIMESTAMPCREATED_STAMP創(chuàng)建時(shí)間TIMESTAMPCREATED_TX_STAMP創(chuàng)建事務(wù)時(shí)間TIMESTAMP1.1.6. PARTY_CARRIER_ACCOUNT名稱說明數(shù)據(jù)類型主鍵/外鍵/非空PARTY_ID當(dāng)事人標(biāo)識VARCHAR(20)PCARRIER_PARTY_ID送貨人員VARCHAR(20)PFROM_DATE開始日期TIMESTAMPPTHRU_DATE結(jié)束日期TIMESTAMPACCOUNT_NUMBER客戶或用戶的賬號,有時(shí)也作為承運(yùn)人編號VARCHAR(20)LAST_UPDATED_STAMP最后更新時(shí)間TIMESTAMPLAST

9、_UPDATED_TX_STAMP最后更新事務(wù)時(shí)間TIMESTAMPCREATED_STAMP創(chuàng)建時(shí)間TIMESTAMPCREATED_TX_STAMP創(chuàng)建事務(wù)時(shí)間TIMESTAMP1.1.7. PARTY_CLASSIFICATION名稱說明數(shù)據(jù)類型主鍵/外鍵/非空PARTY_ID當(dāng)事人標(biāo)識VARCHAR(20)PPARTY_CLASSIFICATION_GROUP_ID當(dāng)事人分組標(biāo)識VARCHAR(20)PFROM_DATE開始日期TIMESTAMPPTHRU_DATE結(jié)束日期TIMESTAMPLAST_UPDATED_STAMP最后更新時(shí)間TIMESTAMPLAST_UPDATED_TX

10、_STAMP最后更新事務(wù)時(shí)間TIMESTAMPCREATED_STAMP創(chuàng)建時(shí)間TIMESTAMPCREATED_TX_STAMP創(chuàng)建事務(wù)時(shí)間TIMESTAMP1.1.8. PARTY_CLASSIFICATION_GROUP名稱說明數(shù)據(jù)類型主鍵/外鍵/非空PARTY_CLASSIFICATION_GROUP_ID當(dāng)事人分組標(biāo)識VARCHAR(20)PPARTY_CLASSIFICATION_TYPE_ID當(dāng)事人分類類型標(biāo)識VARCHAR(20)FPARENT_GROUP_ID上級分組VARCHAR(20)DESCRIPTION描述VARCHAR(255)LAST_UPDATED_STAMP最

11、后更新時(shí)間TIMESTAMPLAST_UPDATED_TX_STAMP最后更新事務(wù)時(shí)間TIMESTAMPCREATED_STAMP創(chuàng)建時(shí)間TIMESTAMPCREATED_TX_STAMP創(chuàng)建事務(wù)時(shí)間TIMESTAMP1.1.9. PARTY_CLASSIFICATION_TYPE名稱說明數(shù)據(jù)類型主鍵/外鍵/非空PARTY_CLASSIFICATION_TYPE_ID當(dāng)事人分類類型標(biāo)識VARCHAR(20)PPARENT_TYPE_ID上級類型VARCHAR(20)HAS_TABLE有庫表CHARACTERDESCRIPTION描述VARCHAR(255)LAST_UPDATED_STAMP最

12、后更新時(shí)間TIMESTAMPLAST_UPDATED_TX_STAMP最后更新事務(wù)時(shí)間TIMESTAMPCREATED_STAMP創(chuàng)建時(shí)間TIMESTAMPCREATED_TX_STAMP創(chuàng)建事務(wù)時(shí)間TIMESTAMP1.1.10. PARTY_CONTENT名稱說明數(shù)據(jù)類型主鍵/外鍵/非空PARTY_ID當(dāng)事人標(biāo)識VARCHAR(20)PCONTENT_ID內(nèi)容標(biāo)識VARCHAR(20)PPARTY_CONTENT_TYPE_ID當(dāng)事人內(nèi)容類型標(biāo)識VARCHAR(20)PFROM_DATE開始日期TIMESTAMPPTHRU_DATE結(jié)束日期TIMESTAMPLAST_UPDATED_STA

13、MP最后更新時(shí)間TIMESTAMPLAST_UPDATED_TX_STAMP最后更新事務(wù)時(shí)間TIMESTAMPCREATED_STAMP創(chuàng)建時(shí)間TIMESTAMPCREATED_TX_STAMP創(chuàng)建事務(wù)時(shí)間TIMESTAMP1.1.11. PARTY_CONTENT_TYPE名稱說明數(shù)據(jù)類型主鍵/外鍵/非空PARTY_CONTENT_TYPE_ID當(dāng)事人內(nèi)容類型標(biāo)識VARCHAR(20)PPARENT_TYPE_ID上級類型標(biāo)識VARCHAR(20)DESCRIPTION描述VARCHAR(255)LAST_UPDATED_STAMP最后更新時(shí)間TIMESTAMPLAST_UPDATED_TX

14、_STAMP最后更新事務(wù)時(shí)間TIMESTAMPCREATED_STAMP創(chuàng)建時(shí)間TIMESTAMPCREATED_TX_STAMP創(chuàng)建事務(wù)時(shí)間TIMESTAMP1.1.12. PARTY_DATA_SOURCE名稱說明數(shù)據(jù)類型主鍵/外鍵/非空PARTY_ID當(dāng)事人標(biāo)識VARCHAR(20)PDATA_SOURCE_ID數(shù)據(jù)源標(biāo)識VARCHAR(20)PFROM_DATE開始日期TIMESTAMPPVISIT_ID訪問標(biāo)識VARCHAR(20)COMMENTS備注VARCHAR(255)IS_CREATE是否創(chuàng)建CHARACTERLAST_UPDATED_STAMP最后更新時(shí)間TIMESTAMP

15、LAST_UPDATED_TX_STAMP最后更新事務(wù)時(shí)間TIMESTAMPCREATED_STAMP創(chuàng)建時(shí)間TIMESTAMPCREATED_TX_STAMP創(chuàng)建事務(wù)時(shí)間TIMESTAMP1.1.13. PARTY_GEO_POINT名稱說明數(shù)據(jù)類型主鍵/外鍵/非空PARTY_ID當(dāng)事人標(biāo)識VARCHAR(20)PGEO_POINT_ID地理位置標(biāo)識VARCHAR(20)PFROM_DATE開始日期TIMESTAMPPTHRU_DATE結(jié)束日期TIMESTAMPLAST_UPDATED_STAMP最后更新時(shí)間TIMESTAMPLAST_UPDATED_TX_STAMP最后更新事務(wù)時(shí)間TIME

16、STAMPCREATED_STAMP創(chuàng)建時(shí)間TIMESTAMPCREATED_TX_STAMP創(chuàng)建事務(wù)時(shí)間TIMESTAMP1.1.14. PARTY_GROUP（會員>新建會員組）名稱說明數(shù)據(jù)類型主鍵/外鍵/非空PARTY_ID當(dāng)事人標(biāo)識VARCHAR(20)PGROUP_NAME組織名稱VARCHAR(100)GROUP_NAME_LOCAL組織名稱本地語言VARCHAR(100)OFFICE_SITE_NAME辦公地點(diǎn)VARCHAR(100)ANNUAL_REVENUE年收入DECIMAL(18,2)NUM_EMPLOYEES員工數(shù)DECIMAL(20)TICKER_SYMBOL股

17、票代碼VARCHAR(10)COMMENTS備注VARCHAR(255)LOGO_IMAGE_URLLogo圖地址VARCHAR(255)LAST_UPDATED_STAMP最后更新時(shí)間TIMESTAMPLAST_UPDATED_TX_STAMP最后更新事務(wù)時(shí)間TIMESTAMPCREATED_STAMP創(chuàng)建時(shí)間TIMESTAMPCREATED_TX_STAMP創(chuàng)建事務(wù)時(shí)間TIMESTAMP1.1.15. PARTY_ICS_AVS_OVERRIDE名稱說明數(shù)據(jù)類型主鍵/外鍵/非空PARTY_ID當(dāng)事人標(biāo)識VARCHAR(20)PAVS_DECLINE_STRING地址驗(yàn)證服務(wù)字符串VARCH

18、AR(255)LAST_UPDATED_STAMP最后更新時(shí)間TIMESTAMPLAST_UPDATED_TX_STAMP最后更新事務(wù)時(shí)間TIMESTAMPCREATED_STAMP創(chuàng)建時(shí)間TIMESTAMPCREATED_TX_STAMP創(chuàng)建事務(wù)時(shí)間TIMESTAMP1.1.16. PARTY_INVITATION名稱說明數(shù)據(jù)類型主鍵/外鍵/非空PARTY_INVITATION_ID當(dāng)事人邀請標(biāo)識VARCHAR(20)PPARTY_ID_FROM源當(dāng)事人標(biāo)識VARCHAR(20)PARTY_ID當(dāng)事人標(biāo)識VARCHAR(20)TO_NAME目標(biāo)名稱VARCHAR(100)EMAIL_ADDR

19、ESS郵件地址VARCHAR(255)STATUS_ID狀態(tài)標(biāo)識VARCHAR(20)LAST_INVITE_DATE最后邀請日期TIMESTAMPLAST_UPDATED_STAMP最后更新時(shí)間TIMESTAMPLAST_UPDATED_TX_STAMP最后更新事務(wù)時(shí)間TIMESTAMPCREATED_STAMP創(chuàng)建時(shí)間TIMESTAMPCREATED_TX_STAMP創(chuàng)建事務(wù)時(shí)間TIMESTAMP1.1.17. PARTY_INVITATION_GROUP_ASSOC名稱說明數(shù)據(jù)類型主鍵/外鍵/非空PARTY_INVITATION_ID當(dāng)事人邀請標(biāo)識VARCHAR(20)PPARTY_ID

20、_TO目標(biāo)當(dāng)事人標(biāo)識VARCHAR(20)PLAST_UPDATED_STAMP最后更新時(shí)間TIMESTAMPLAST_UPDATED_TX_STAMP最后更新事務(wù)時(shí)間TIMESTAMPCREATED_STAMP創(chuàng)建時(shí)間TIMESTAMPCREATED_TX_STAMP創(chuàng)建事務(wù)時(shí)間TIMESTAMP1.1.18. PARTY_INVITATION_ROLE_ASSOC名稱說明數(shù)據(jù)類型主鍵/外鍵/非空PARTY_INVITATION_ID當(dāng)事人邀請標(biāo)識VARCHAR(20)PROLE_TYPE_ID角色類型標(biāo)識VARCHAR(20)PLAST_UPDATED_STAMP最后更新時(shí)間TIMESTA

21、MPLAST_UPDATED_TX_STAMP最后更新事務(wù)時(shí)間TIMESTAMPCREATED_STAMP創(chuàng)建時(shí)間TIMESTAMPCREATED_TX_STAMP創(chuàng)建事務(wù)時(shí)間TIMESTAMP1.1.19. PARTY_NAME_HISTORY名稱說明數(shù)據(jù)類型主鍵/外鍵/非空PARTY_ID當(dāng)事人標(biāo)識VARCHAR(20)PCHANGE_DATE修改日期TIMESTAMPPGROUP_NAME組名VARCHAR(100)FIRST_NAME名VARCHAR(100)MIDDLE_NAME中間名VARCHAR(100)LAST_NAME姓VARCHAR(100)PERSONAL_TITLE個(gè)人

22、頭銜VARCHAR(100)SUFFIX后綴VARCHAR(100)LAST_UPDATED_STAMP最后更新時(shí)間TIMESTAMPLAST_UPDATED_TX_STAMP最后更新事務(wù)時(shí)間TIMESTAMPCREATED_STAMP創(chuàng)建時(shí)間TIMESTAMPCREATED_TX_STAMP創(chuàng)建事務(wù)時(shí)間TIMESTAMP1.1.20. PARTY_NOTE名稱說明數(shù)據(jù)類型主鍵/外鍵/非空PARTY_ID當(dāng)事人標(biāo)識VARCHAR(20)PNOTE_ID注釋標(biāo)識VARCHAR(20)PLAST_UPDATED_STAMP最后更新時(shí)間TIMESTAMPLAST_UPDATED_TX_STAMP最后

23、更新事務(wù)時(shí)間TIMESTAMPCREATED_STAMP創(chuàng)建時(shí)間TIMESTAMPCREATED_TX_STAMP創(chuàng)建事務(wù)時(shí)間TIMESTAMP1.1.21. PARTY_PROFILE_DEFAULT名稱說明數(shù)據(jù)類型主鍵/外鍵/非空PARTY_ID當(dāng)事人標(biāo)識VARCHAR(20)PPRODUCT_STORE_ID產(chǎn)品店鋪標(biāo)識VARCHAR(20)PDEFAULT_SHIP_ADDR缺省送貨地址VARCHAR(20)DEFAULT_BILL_ADDR缺省賬單地址VARCHAR(20)DEFAULT_PAY_METH缺省支付方式VARCHAR(20)DEFAULT_SHIP_METH缺省送貨方式

24、VARCHAR(20)LAST_UPDATED_STAMP最后更新時(shí)間TIMESTAMPLAST_UPDATED_TX_STAMP最后更新事務(wù)時(shí)間TIMESTAMPCREATED_STAMP創(chuàng)建時(shí)間TIMESTAMPCREATED_TX_STAMP創(chuàng)建事務(wù)時(shí)間TIMESTAMP1.1.22. PARTY_RELATIONSHIP名稱說明數(shù)據(jù)類型主鍵/外鍵/非空PARTY_ID_FROM源當(dāng)事人標(biāo)識VARCHAR(20)PPARTY_ID_TO目標(biāo)當(dāng)事人標(biāo)識VARCHAR(20)PROLE_TYPE_ID_FROM源當(dāng)事人角色類型標(biāo)識VARCHAR(20)PROLE_TYPE_ID_TO目標(biāo)當(dāng)事

25、人角色類型標(biāo)識VARCHAR(20)PFROM_DATE開始日期TIMESTAMPPTHRU_DATE結(jié)束日期TIMESTAMPSTATUS_ID狀態(tài)標(biāo)識VARCHAR(20)RELATIONSHIP_NAME當(dāng)事人關(guān)系名稱VARCHAR(100)SECURITY_GROUP_ID安全組標(biāo)識VARCHAR(20)FPRIORITY_TYPE_ID優(yōu)先類型標(biāo)識VARCHAR(20)PARTY_RELATIONSHIP_TYPE_ID當(dāng)事人關(guān)系類型標(biāo)識VARCHAR(20)FPERMISSIONS_ENUM_ID權(quán)限枚舉標(biāo)識VARCHAR(20)POSITION_TITLE職位頭銜VARCHAR(

26、100)COMMENTS說明VARCHAR(255)LAST_UPDATED_STAMP最后更新時(shí)間TIMESTAMPLAST_UPDATED_TX_STAMP最后更新事務(wù)時(shí)間TIMESTAMPCREATED_STAMP創(chuàng)建時(shí)間TIMESTAMPCREATED_TX_STAMP創(chuàng)建事務(wù)時(shí)間TIMESTAMP1.1.23. PARTY_RELATIONSHIP_TYPE名稱說明數(shù)據(jù)類型主鍵/外鍵/非空PARTY_RELATIONSHIP_TYPE_ID當(dāng)事人關(guān)系類型標(biāo)識VARCHAR(20)PPARENT_TYPE_ID上級類型標(biāo)識VARCHAR(20)HAS_TABLE有庫表CHARACTER

27、PARTY_RELATIONSHIP_NAME描述VARCHAR(100)DESCRIPTION當(dāng)事人關(guān)系名稱VARCHAR(255)ROLE_TYPE_ID_VALID_FROM有效的源角色類型標(biāo)識從VARCHAR(20)ROLE_TYPE_ID_VALID_TO有效的目標(biāo)角色類型標(biāo)識VARCHAR(20)LAST_UPDATED_STAMP最后更新時(shí)間TIMESTAMPLAST_UPDATED_TX_STAMP最后更新事務(wù)時(shí)間TIMESTAMPCREATED_STAMP創(chuàng)建時(shí)間TIMESTAMPCREATED_TX_STAMP創(chuàng)建事務(wù)時(shí)間TIMESTAMP1.1.24. PARTY_ROL

28、E名稱說明數(shù)據(jù)類型主鍵/外鍵/非空PARTY_ID當(dāng)事人標(biāo)識VARCHAR(20)PROLE_TYPE_ID角色類型標(biāo)識VARCHAR(20)PLAST_UPDATED_STAMP最后更新時(shí)間TIMESTAMPLAST_UPDATED_TX_STAMP最后更新事務(wù)時(shí)間TIMESTAMPCREATED_STAMP創(chuàng)建時(shí)間TIMESTAMPCREATED_TX_STAMP創(chuàng)建事務(wù)時(shí)間TIMESTAMP1.1.25. PARTY_STATUS名稱說明數(shù)據(jù)類型主鍵/外鍵/非空STATUS_ID狀態(tài)標(biāo)識VARCHAR(20)PPARTY_ID當(dāng)事人標(biāo)識VARCHAR(20)PSTATUS_DATE狀態(tài)日

29、期TIMESTAMPPLAST_UPDATED_STAMP最后更新時(shí)間TIMESTAMPLAST_UPDATED_TX_STAMP最后更新事務(wù)時(shí)間TIMESTAMPCREATED_STAMP創(chuàng)建時(shí)間TIMESTAMPCREATED_TX_STAMP創(chuàng)建事務(wù)時(shí)間TIMESTAMP1.1.26. PARTY_TYPE名稱說明數(shù)據(jù)類型主鍵/外鍵/非空PARTY_TYPE_ID當(dāng)事人類型標(biāo)識VARCHAR(20)PPARENT_TYPE_ID上級類型標(biāo)識VARCHAR(20)HAS_TABLE有庫表CHARACTERDESCRIPTION描述VARCHAR(255)LAST_UPDATED_STAMP

30、最后更新時(shí)間TIMESTAMPLAST_UPDATED_TX_STAMP最后更新事務(wù)時(shí)間TIMESTAMPCREATED_STAMP創(chuàng)建時(shí)間TIMESTAMPCREATED_TX_STAMP創(chuàng)建事務(wù)時(shí)間TIMESTAMP1.1.27. PARTY_TYPE_ATTR名稱說明數(shù)據(jù)類型主鍵/外鍵/非空PARTY_TYPE_ID當(dāng)事人類型標(biāo)識VARCHAR(20)PATTR_NAME屬性名VARCHAR(60)PLAST_UPDATED_STAMP最后更新時(shí)間TIMESTAMPLAST_UPDATED_TX_STAMP最后更新事務(wù)時(shí)間TIMESTAMPCREATED_STAMP創(chuàng)建時(shí)間TIMESTA

31、MPCREATED_TX_STAMP創(chuàng)建事務(wù)時(shí)間TIMESTAMP1.1.28. PERSON（會員>新建人員）名稱說明數(shù)據(jù)類型主鍵/外鍵/非空PARTY_ID當(dāng)事人標(biāo)識VARCHAR(20)PSALUTATION稱呼VARCHAR(100)FIRST_NAME名VARCHAR(100)MIDDLE_NAME中間名VARCHAR(100)LAST_NAME姓VARCHAR(100)PERSONAL_TITLE頭銜VARCHAR(100)SUFFIX后綴VARCHAR(100)NICKNAME昵稱VARCHAR(100)FIRST_NAME_LOCAL名本地語言VARCHAR(100)MI

32、DDLE_NAME_LOCAL中間名本地語言VARCHAR(100)LAST_NAME_LOCAL姓本地語言VARCHAR(100)OTHER_LOCAL其它本地語言VARCHAR(100)MEMBER_ID成員標(biāo)識VARCHAR(20)GENDER性別CHARACTERBIRTH_DATE生日DATEHEIGHT身高DECIMAL(18,6)WEIGHT體重DECIMAL(18,6)MOTHERS_MAIDEN_NAME母親娘家姓VARCHAR(255)MARITAL_STATUS婚姻狀態(tài)CHARACTERSOCIAL_SECURITY_NUMBER社保號VARCHAR(255)PASSPO

33、RT_NUMBER護(hù)照號VARCHAR(255)PASSPORT_EXPIRE_DATE護(hù)照過期時(shí)間DATETOTAL_YEARS_WORK_EXPERIENCE總工作年限D(zhuǎn)ECIMAL(18,6)COMMENTS備注VARCHAR(255)EMPLOYMENT_STATUS_ENUM_ID雇用狀態(tài)枚舉標(biāo)識VARCHAR(20)RESIDENCE_STATUS_ENUM_ID居住狀態(tài)枚舉標(biāo)識VARCHAR(20)OCCUPATION職業(yè)VARCHAR(100)YEARS_WITH_EMPLOYER雇用年數(shù)DECIMAL(20)MONTHS_WITH_EMPLOYER雇用月數(shù)DECIMAL(20)EXISTING_CUSTOMER存在的客戶CHARACTERLAST_UPDATED_STAMP最后更新時(shí)間TIMESTAMPLAST_UPDATED_TX_STAMP最后