Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| requestid | varchar | 36 | √ | null |
|
|
The requestid of the Email Capture |
||||
| timestamp | timestamp | 29,6 | √ | ('now'::text)::timestamp with time zone |
|
|
The date and time the Email Capture was created |
||||
| companyid | varchar | 36 | null |
|
|
The ID of the learning site |
|||||
| companysubdomain | varchar | 255 | √ | null |
|
|
The companysubdomain of the Email Capture |
||||
| companyhost | varchar | 255 | √ | null |
|
|
The companyhost of the Email Capture |
||||
| useremail | varchar | 255 | √ | null |
|
|
The useremail of the Email Capture |
||||
| notifiabletype | varchar | 255 | √ | null |
|
|
The notifiabletype of the Email Capture |
||||
| notifiableid | varchar | 36 | √ | null |
|
|
The notifiableid of the Email Capture |
||||
| source | varchar | 255 | √ | null |
|
|
The source of the Email Capture |
||||
| courseid | varchar | 36 | √ | null |
|
|
The courseid of the Email Capture |
||||
| coursetitle | varchar | 255 | √ | null |
|
|
The coursetitle of the Email Capture |
||||
| coursesku | varchar | 255 | √ | null |
|
|
The coursesku of the Email Capture |
||||
| anonymousid | varchar | 36 | √ | null |
|
|
The anonymousid of the Email Capture |
||||
| keenid | varchar | 24 | √ | null |
|
|
The keenid of the Email Capture |
Relationships
Close relationships within degrees of separation
