Schema:history

From ISFDB

Jump to: navigation, search

Schema Summary

+--------------------+------------+------+-----+---------+----------------+
| Field              | Type       | Null | Key | Default | Extra          |
+--------------------+------------+------+-----+---------+----------------+
| history_id         | int(11)    | NO   | PRI | NULL    | auto_increment |
| history_time       | datetime   | YES  |     | NULL    |                |
| history_table      | int(11)    | YES  |     | NULL    |                |
| history_record     | int(11)    | YES  |     | NULL    |                |
| history_field      | int(11)    | YES  |     | NULL    |                |
| history_submission | int(11)    | YES  |     | NULL    |                |
| history_submitter  | int(11)    | NO   |     | 0       |                |
| history_reviewer   | int(11)    | NO   |     | 0       |                |
| history_from       | mediumtext | YES  |     | NULL    |                |
| history_to         | mediumtext | YES  |     | NULL    |                |
+--------------------+------------+------+-----+---------+----------------+


Description

The history table tracks change information in the ISFDB. NOTE that this was an experimental table created in the late 2000s. It was an attempt to make the ISFDB database more like a Wiki, which would allow users to view the history of bibliographic records.

  • history_id - Unique history ID.
  • history_time - The time the change occurred.
  • history_table - Describes the type of change.
  • history_record - This field contains the record number that was changed.
  • history_field - The field contains the field in the record that was changed.
  • history_submission - Submission number that induced this change.
  • history_submitter - The person who submitted the change.
  • history_reviewer - The moderator who integrated the change.
  • history_from - Field value prior to the change.
  • history_to - Field value after the change.
Personal tools