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.