Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| id | bigserial | 19 | √ | nextval('app_hvp_xapi_results_id_seq'::regclass) |
|
|
||
| content_id | int8 | 19 | null |
|
|
|||
| user_id | int8 | 19 | null |
|
|
|||
| parent_id | int8 | 19 | √ | null |
|
|
||
| interaction_type | varchar | 127 | ''::character varying |
|
|
|||
| description | text | 2147483647 | null |
|
|
|||
| correct_responses_pattern | text | 2147483647 | null |
|
|
|||
| response | text | 2147483647 | null |
|
|
|||
| additionals | text | 2147483647 | null |
|
|
|||
| raw_score | int4 | 10 | √ | null |
|
|
||
| max_score | int4 | 10 | √ | null |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| app_hvpxapiresu_id_pk | Primary key | Asc | id |
| app_hvpxapiresu_conuse_ix | Performance | Asc/Asc | content_id + user_id |
Relationships
Close relationships within degrees of separation
