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.