Schema:series

Schema Summary

+------------------------+-------------+------+-----+---------+----------------+
| Field                  | Type        | Null | Key | Default | Extra          |
+------------------------+-------------+------+-----+---------+----------------+
| series_id              | int(11)     | NO   | PRI | NULL    | auto_increment |
| series_title           | varchar(64) | YES  | MUL | NULL    |                |
| series_parent          | int(11)     | YES  |     | NULL    |                |
| series_type            | int(11)     | YES  |     | NULL    |                |
| series_parent_position | int(11)     | YES  |     | NULL    |                | 	
+------------------------+-------------+------+-----+---------+----------------+

Description

The submissions table holds data submissions

• series_id - This column is the unique record id for the series table. A series may be referred to by this unique id.

• series_title - This column holds the name of the series.

• series_parent - This column holds an integer which can point to another series record. This allows hierarchical series structures of indefinite depth.

• series_type - This column contains a value that indicates whether or not the series record is a terminating leaf.
  • 1 = Terminated Series
  • 2 = Parent Series

• series_parent_position - This column holds an integer which can be used in combination with series_parent to provide ordered hierarchical series structures of indefinite depth.