Schema:submissions
Jump to navigation
Jump to search
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
- 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.