Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| id | BIGINT | 19 | √ | null |
|
|
||||||||||||
| machinename | VARCHAR | 255 |
|
|
||||||||||||||
| title | VARCHAR | 255 |
|
|
||||||||||||||
| majorversion | SMALLINT | 5 | null |
|
|
|||||||||||||
| minorversion | SMALLINT | 5 | null |
|
|
|||||||||||||
| patchversion | SMALLINT | 5 | null |
|
|
|||||||||||||
| runnable | BIT | 1 | null |
|
|
|||||||||||||
| fullscreen | BIT | 1 | 0 |
|
|
|||||||||||||
| embedtypes | VARCHAR | 255 |
|
|
||||||||||||||
| preloadedjs | LONGTEXT | 2147483647 | √ | null |
|
|
||||||||||||
| preloadedcss | LONGTEXT | 2147483647 | √ | null |
|
|
||||||||||||
| droplibrarycss | LONGTEXT | 2147483647 | √ | null |
|
|
||||||||||||
| semantics | LONGTEXT | 2147483647 | √ | null |
|
|
||||||||||||
| addto | LONGTEXT | 2147483647 | √ | null |
|
|
||||||||||||
| coremajor | SMALLINT | 5 | √ | null |
|
|
||||||||||||
| coreminor | SMALLINT | 5 | √ | null |
|
|
||||||||||||
| metadatasettings | LONGTEXT | 2147483647 | √ | null |
|
|
||||||||||||
| tutorial | LONGTEXT | 2147483647 | √ | null |
|
|
||||||||||||
| example | LONGTEXT | 2147483647 | √ | null |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PRIMARY | Primary key | Asc | id |
| h5plibr_macmajminpatrun2_ix | Performance | Asc/Asc/Asc/Asc/Asc | machinename + majorversion + minorversion + patchversion + runnable |
Relationships
Close relationships within degrees of separation
