Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| companyid | varchar | 36 | √ | null |
|
|
The ID of the learning site |
||||
| id | varchar | 36 | null |
|
|
Unique Identifier of the Testimonial |
|||||
| userid | varchar | 36 | √ | null |
|
|
The userid of the Testimonial |
||||
| userfirstname | varchar | 255 | √ | null |
|
|
The userfirstname of the Testimonial |
||||
| userlastname | varchar | 255 | √ | null |
|
|
The userlastname of the Testimonial |
||||
| useremail | varchar | 255 | √ | null |
|
|
The useremail of the Testimonial |
||||
| coursegroupid | varchar | 36 | √ | null |
|
|
The coursegroupid of the Testimonial |
||||
| coursegrouptitle | varchar | 1024 | √ | null |
|
|
The coursegrouptitle of the Testimonial |
||||
| rating | int4 | 10 | √ | null |
|
|
The rating of the Testimonial |
||||
| approved | bool | 1 | √ | null |
|
|
The approved of the Testimonial |
||||
| body | varchar | 65535 | √ | null |
|
|
The body of the Testimonial |
||||
| createdat | timestamp | 29,6 | √ | null |
|
|
The date and time the Testimonial was created |
||||
| updatedat | timestamp | 29,6 | √ | ('now'::text)::timestamp with time zone |
|
|
The date and time the Testimonial was created |
||||
| licenseid | varchar | 36 | √ | null |
|
|
|||||
| statusgroup | varchar | 256 | √ | null |
|
|
|||||
| statusgroupupdatedat | timestamp | 29,6 | √ | null |
|
|
Relationships
Close relationships within degrees of separation
