Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| id | bigserial | 19 | √ | nextval('app_hvp_libraries_id_seq'::regclass) |
|
|
||
| machine_name | varchar | 255 | ''::character varying |
|
|
|||
| title | varchar | 255 | ''::character varying |
|
|
|||
| major_version | int2 | 5 | null |
|
|
|||
| minor_version | int2 | 5 | null |
|
|
|||
| patch_version | int2 | 5 | null |
|
|
|||
| runnable | int2 | 5 | null |
|
|
|||
| fullscreen | int2 | 5 | 0 |
|
|
|||
| embed_types | varchar | 255 | ''::character varying |
|
|
|||
| preloaded_js | text | 2147483647 | √ | null |
|
|
||
| preloaded_css | text | 2147483647 | √ | null |
|
|
||
| drop_library_css | text | 2147483647 | √ | null |
|
|
||
| semantics | text | 2147483647 | null |
|
|
|||
| restricted | int2 | 5 | 0 |
|
|
|||
| tutorial_url | varchar | 1000 | √ | null |
|
|
||
| has_icon | int2 | 5 | 0 |
|
|
|||
| add_to | text | 2147483647 | √ | null |
|
|
||
| metadata_settings | text | 2147483647 | √ | null |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| app_hvplibr_id_pk | Primary key | Asc | id |
| app_hvplibr_macmajminpatrun_ix | Performance | Asc/Asc/Asc/Asc/Asc | machine_name + major_version + minor_version + patch_version + runnable |
Relationships
Close relationships within degrees of separation
