Difference between revisions of "Schema:series"
Jump to navigation
Jump to search
(2016 update) |
|||
| Line 5: | Line 5: | ||
+------------------------+-------------+------+-----+---------+----------------+ | +------------------------+-------------+------+-----+---------+----------------+ | ||
| series_id | int(11) | NO | PRI | NULL | auto_increment | | | series_id | int(11) | NO | PRI | NULL | auto_increment | | ||
| − | | series_title | | + | | series_title | mediumtext | YES | MUL | NULL | | |
| series_parent | int(11) | YES | | NULL | | | | series_parent | int(11) | YES | | NULL | | | ||
| series_type | int(11) | YES | | NULL | | | | series_type | int(11) | YES | | NULL | | | ||
| − | | series_parent_position | int(11) | YES | | NULL | | | + | | series_parent_position | int(11) | YES | | NULL | | |
| + | | series_note_id | int(11) | YES | | NULL | | | ||
+------------------------+-------------+------+-----+---------+----------------+ | +------------------------+-------------+------+-----+---------+----------------+ | ||
==Description== | ==Description== | ||
| − | The | + | The series holds series-specific information |
| − | * '''series_id''' - | + | * '''series_id''' - Unique record id for the series table. |
| − | * '''series_title''' - | + | * '''series_title''' - The name of the series. |
| − | * '''series_parent''' - | + | * '''series_parent''' - Series ID of another series record which serves at this series' super-series. This allows hierarchical series structures of indefinite depth. |
| − | * '''series_type''' - | + | * '''series_type''' - At one point this column contained a value that indicated whether or not the series record was a terminating leaf. The supported values were 1 for "Terminated series" and 2 for "Parent Series". '''No longer used'''. |
| − | |||
| − | |||
| − | * '''series_parent_position''' - | + | * '''series_parent_position''' - An integer value used in combination with series_parent to provide ''ordered'' hierarchical series structures of indefinite depth. |
| + | |||
| + | * '''series_note_id''' - ID of the note record in the "notes" table associated with this series. | ||
Latest revision as of 20:11, 3 September 2016
Schema Summary
+------------------------+-------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +------------------------+-------------+------+-----+---------+----------------+ | series_id | int(11) | NO | PRI | NULL | auto_increment | | series_title | mediumtext | YES | MUL | NULL | | | series_parent | int(11) | YES | | NULL | | | series_type | int(11) | YES | | NULL | | | series_parent_position | int(11) | YES | | NULL | | | series_note_id | int(11) | YES | | NULL | | +------------------------+-------------+------+-----+---------+----------------+
Description
The series holds series-specific information
- series_id - Unique record id for the series table.
- series_title - The name of the series.
- series_parent - Series ID of another series record which serves at this series' super-series. This allows hierarchical series structures of indefinite depth.
- series_type - At one point this column contained a value that indicated whether or not the series record was a terminating leaf. The supported values were 1 for "Terminated series" and 2 for "Parent Series". No longer used.
- series_parent_position - An integer value used in combination with series_parent to provide ordered hierarchical series structures of indefinite depth.
- series_note_id - ID of the note record in the "notes" table associated with this series.