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    |                |
+---------------+-------------+------+-----+---------+----------------+

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