Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| requestid | varchar | 36 | √ | null |
|
|
The requestid of the Session |
||||
| timestamp | timestamp | 29,6 | √ | ('now'::text)::timestamp with time zone |
|
|
The date and time the Session was created |
||||
| companyid | varchar | 36 | √ | null |
|
|
The ID of the learning site |
||||
| companysubdomain | varchar | 255 | √ | null |
|
|
The companysubdomain of the Session |
||||
| companyhost | varchar | 255 | √ | null |
|
|
The companyhost of the Session |
||||
| userid | varchar | 36 | √ | null |
|
|
The ID of the User associated with the Session |
||||
| userexternalcustomerid | varchar | 255 | √ | null |
|
|
The userexternalcustomerid of the Session |
||||
| useremail | varchar | 255 | √ | null |
|
|
The useremail of the Session |
||||
| userfirstname | varchar | 255 | √ | null |
|
|
The userfirstname of the Session |
||||
| userlastname | varchar | 255 | √ | null |
|
|
The userlastname of the Session |
||||
| userref1 | varchar | 255 | √ | null |
|
|
The userref1 of the Session |
||||
| userref2 | varchar | 255 | √ | null |
|
|
The userref2 of the Session |
||||
| userref3 | varchar | 255 | √ | null |
|
|
The userref3 of the Session |
||||
| sfaccountid | varchar | 18 | √ | null |
|
|
The sfaccountid of the Session |
||||
| sfcontactid | varchar | 18 | √ | null |
|
|
The sfcontactid of the Session |
||||
| userip | varchar | 255 | √ | null |
|
|
The userip of the Session |
||||
| geolat | float8 | 17,17 | √ | null |
|
|
The geolat of the Session |
||||
| geolong | float8 | 17,17 | √ | null |
|
|
The geolong of the Session |
||||
| geocode | varchar | 255 | √ | null |
|
|
The geocode of the Session |
||||
| geocountry | varchar | 255 | √ | null |
|
|
The geocountry of the Session |
||||
| georegion | varchar | 255 | √ | null |
|
|
The georegion of the Session |
||||
| geocity | varchar | 255 | √ | null |
|
|
The geocity of the Session |
||||
| geozip | varchar | 255 | √ | null |
|
|
The geozip of the Session |
||||
| geotimezone | varchar | 255 | √ | null |
|
|
The geotimezone of the Session |
||||
| useragent | varchar | 512 | √ | null |
|
|
The useragent of the Session |
||||
| event | varchar | 255 | √ | null |
|
|
The event of the Session |
||||
| keenid | varchar | 24 | √ | null |
|
|
The keenid of the Session |
Relationships
Close relationships within degrees of separation
