Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| journal_id | BIGINT | 19 | √ | null |
|
|
|||||||||||||||||||||||
| path | VARCHAR | 32 | null |
|
|
||||||||||||||||||||||||
| seq | DOUBLE | 8,2 | 0.00 |
|
|
Used to order lists of journals |
|||||||||||||||||||||||
| primary_locale | VARCHAR | 14 | null |
|
|
||||||||||||||||||||||||
| enabled | SMALLINT | 5 | 1 |
|
|
Controls whether or not the journal is considered “live” and will appear on the website. (Note that disabled journals may still be accessible, but only if the user knows the URL.) |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PRIMARY | Primary key | Asc | journal_id |
| journals_path | Must be unique | Asc | path |
Relationships
Close relationships within degrees of separation
