Guest dimension table
bi_dimguest
Field | Description | Field Type | Primary Key |
|---|---|---|---|
acceptedtandc | integer | ||
address1 | varchar ( 256 ) | ||
address2 | varchar ( 256 ) | ||
anniversarydate | timestamp without time zone | ||
centerid | varchar ( 36 ) | ||
city | varchar ( 128 ) | ||
countrydname | varchar ( 4000 ) | ||
countrysname | varchar ( 4000 ) | ||
creationdt | timestamp without time zone | ||
culturecode | varchar ( 4000 ) | ||
culturedispname | varchar ( 4000 ) | ||
customerapplogin | integer | ||
dob | timestamp without time zone | ||
dob_incompleteyear | varchar ( 20 ) | ||
varchar ( 512 ) | |||
firstname | varchar ( 160 ) | ||
gender | integer | ||
guestwid | bigint | ||
homecountrydname | varchar ( 4000 ) | ||
homecountrysname | varchar ( 4000 ) | ||
homephone | varchar ( 64 ) | ||
langcode | varchar ( 4000 ) | ||
langdispname | varchar ( 4000 ) | ||
lastlogin | timestamp without time zone | ||
lastname | varchar ( 256 ) | ||
middlename | varchar ( 128 ) | ||
mobilecountrydname | varchar ( 4000 ) | ||
mobilecountrysname | varchar ( 4000 ) | ||
mobilephone | varchar ( 64 ) | ||
nationalityfk | integer | ||
organizationid | varchar ( 36 ) | ||
otherpreferences | varchar ( 65535 ) | ||
passwordupdatedon | timestamp without time zone | ||
preferedcenerid | varchar ( 36 ) | ||
preferredroom | varchar ( 36 ) | ||
preferredtherapist | varchar ( 36 ) | ||
receivemarketingemail | A flag that indicates whether the guest opted for marketing emails. - True: Opted - False: Not opted | boolean | |
receivemarketingsms | A flag that indicates whether the guest opted for marketing SMSs. - True: Opted - False: Not opted | boolean | |
receivetransactionalemail | A flag that indicates whether the guest opted for transactional emails. - True: Opted - False: Not opted | boolean | |
receivetransactionalsms | A flag that indicates whether the guest opted for transactional SMSs. - True: Opted - False: Not opted | boolean | |
referralsourceid | varchar ( 36 ) | ||
referredby | varchar ( 36 ) | ||
registrationsource | integer | ||
roomno | varchar ( 80 ) | ||
statecode | varchar ( 40 ) | ||
statedispname | varchar ( 4000 ) | ||
stateother | varchar ( 128 ) | ||
stateshortname | varchar ( 4000 ) | ||
unsubscribetomarketingemail | boolean | ||
unsubscribetotransactionalemail | boolean | ||
usercode | varchar ( 128 ) | ||
userid | varchar ( 36 ) | ||
username | varchar ( 512 ) | ||
userpk | numeric | ||
usertypeid | varchar ( 36 ) | ||
usertypename | varchar ( 128 ) | ||
void | boolean | ||
workcountrydname | varchar ( 4000 ) | ||
workcountrysname | varchar ( 4000 ) | ||
workphone | varchar ( 64 ) | ||
zipcode | varchar ( 32 ) |