Schema:history

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.

• 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.