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.