Schema:submissions

Schema Summary

+---------------+-------------------+------+-----+---------+----------------+
| Field         | Type              | Null | Key | Default | Extra          |
+---------------+-------------------+------+-----+---------+----------------+
| sub_id        | int(11)           | NO   | PRI | NULL    | auto_increment |
| sub_state     | enum('N','R','I') | YES  |     | NULL    |                |
| sub_type      | int(11)           | YES  |     | NULL    |                |
| sub_data      | mediumtext        | YES  |     | NULL    |                |
| sub_time      | datetime          | YES  |     | NULL    |                |
| sub_reviewed  | datetime          | YES  |     | NULL    |                |
| sub_submitter | int(11)           | NO   |     | 0       |                |
| sub_reviewer  | int(11)           | NO   |     | 0       |                |
| sub_reason    | mediumtext        | YES  |     | NULL    |                |
| sub_holdid    | int(11)           | NO   |     | 0       |                |
+---------------+-------------------+------+-----+---------+----------------+

Description

The submission table holds XML records of new, updated, and deleted ISFDB records. The format of the XML records can be found in the article Data Submission Formats.

• sub_id - This column is the unique record id for the submissions table. A submission may be referred to by this unique id.

• sub_state - A submission may be in one of three states: New, Rejected, or Integrated. When data is submitted into the table, the record is placed into the New state. After review by a moderator, the moderator may either choose to Integrate or Reject the submission.

• sub_type - This column holds the submission type:
  • 1 = AuthorMerge
  • 2 = AuthorUpdate
  • 3 = AuthorDelete
  • 4 = PubUpdate
  • 5 = PubMerge
  • 6 = PubDelete
  • 7 = PubNew
  • 8 = TitleUpdate
  • 9 = TitleMerge
  • 10 = TitleDelete
  • 11 = TitleNew
  • 12 = TitleUnmerge
  • 13 = SeriesUpdate
  • 14 = ContentUpdate
  • 15 = VariantTitle
  • 16 = MakeVariant
  • 17 = TitleRemove
  • 18 = ClonePub
  • 19 = MakePseudonym
  • 20 = NewAward
  • 21 = AwardUpdate
  • 22 = AwardDelete
  • 23 - PublisherUpdate
  • 24 - PublisherMerge
  • 25 - LinkReview

• sub_data - The XML string of the submission is stored here.

• sub_time - This field contains the time of the submission.

• sub_reviewed - This field contains the date/time the submission was reviewed.

• sub_submitter - This field contains the user id of the submitter.

• sub_reviewer - This field contains the user id of the reviewer.

• sub_reason - This field contains the reason why the submission was rejected.

• sub_holdid - This field contains the user id of the reviewer who placed the submission on hold.