Columns
Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
---|---|---|---|---|---|---|---|---|
id | bigserial | 19 | √ | nextval('app_hvp_id_seq'::regclass) |
|
|
||
course | int8 | 19 | 0 |
|
|
|||
name | varchar | 255 | ''::character varying |
|
|
|||
intro | text | 2147483647 | √ | null |
|
|
||
introformat | int2 | 5 | 0 |
|
|
|||
json_content | text | 2147483647 | null |
|
|
|||
embed_type | varchar | 127 | ''::character varying |
|
|
|||
disable | int8 | 19 | 0 |
|
|
|||
main_library_id | int8 | 19 | null |
|
|
|||
content_type | varchar | 127 | √ | null |
|
|
||
text | 2147483647 | √ | null |
|
|
|||
source | varchar | 255 | √ | null |
|
|
||
year_from | int2 | 5 | √ | null |
|
|
||
year_to | int2 | 5 | √ | null |
|
|
||
license | varchar | 63 | √ | null |
|
|
||
license_version | varchar | 15 | √ | null |
|
|
||
changes | text | 2147483647 | √ | null |
|
|
||
license_extras | text | 2147483647 | √ | null |
|
|
||
text | 2147483647 | √ | null |
|
|
|||
default_language | varchar | 32 | √ | null |
|
|
||
filtered | text | 2147483647 | √ | null |
|
|
||
slug | varchar | 255 | ''::character varying |
|
|
|||
timecreated | int8 | 19 | 0 |
|
|
|||
timemodified | int8 | 19 | 0 |
|
|
|||
completionpass | int2 | 5 | 0 |
|
|
|||
int8 | 19 | 0 |
|
|
||||
synced | int8 | 19 | √ | null |
|
|
||
hub_id | int8 | 19 | √ | null |
|
|
||
a11y_title | varchar | 255 | √ | null |
|
|
Indexes
Constraint Name | Type | Sort | Column(s) |
---|---|---|---|
app_hvp_id_pk | Primary key | Asc | id |