Table s_change_event |
Description: Records all database events (ie. insert, update, delete). Gets purged after each export |
PRIMARY KEY | ||
s_table_name_c
varchar (64) NOT NULL | Name of the database table where the event occurred | |
s_rowid_c
varchar (40) NOT NULL | Rowid of the record that the event applied to | |
s_change_type_c
varchar (2) NOT NULL | Type of event (I, U or D - Insert, Update, Delete) | |
s_natural_key_c
varchar (2000) NOT NULL | Concatenation of the natural key values for the affected record (the primary key is not enough where a surrogate key is used as this is not meaningful across sites) | |
s_date_d
date NOT NULL | Date on which the event took place | |
s_time_i
integer NOT NULL | Time at which event took place | |
s_date_created_d
date default: CURRENT_DATE | The date the record was created. | |
s_created_by_c
varchar (20) | User ID of who created this record. | s_user |
s_date_modified_d
date | The date the record was modified. | |
s_modified_by_c
varchar (20) | User ID of who last modified this record. | s_user |
s_modification_id_t
timestamp default: CURRENT_TIMESTAMP | This identifies the current version of the record. | |
FOREIGN KEY s_change_event_fkcr: s_created_by_c => s_user s_change_event_fkmd: s_modified_by_c => s_user |