Schema:series

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.