Extension:Echo/echo_notification table

A notification is a user being notified about a certain event. Multiple users can be notified about the same event.

Key to echo_event.event_id

Key to user.user_id

Timestamp when the notification was created

Timestamp when the user read the notification, or null if unread

Hash for bundling together similar notifications. Notifications that can be bundled together will have the same hash

mysql> describe echo_notification;
+----------------------------------+------------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+----------------------------------+------------------+------+-----+---------+-------+
| notification_event | int(10) unsigned | NO | PRI | NULL | |
| notification_user | int(10) unsigned | NO | PRI | NULL | |
| notification_timestamp | binary(14) | NO | | NULL | |
| notification_read_timestamp | binary(14) | YES | | NULL | |
| notification_bundle_hash | varbinary(32) | NO | | NULL | |
+----------------------------------+------------------+------+-----+---------+-------+

mysql> describe echo_notification;
+----------------------------------+------------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+----------------------------------+------------------+------+-----+---------+-------+
| notification_event | int(10) unsigned | NO | PRI | NULL | |
| notification_user | int(10) unsigned | NO | PRI | NULL | |
| notification_timestamp | binary(14) | NO | | NULL | |
| notification_read_timestamp | binary(14) | YES | | NULL | |
| notification_bundle_base | tinyint(1) | NO | | 1 | |
| notification_bundle_hash | varbinary(32) | NO | | NULL | |
| notification_bundle_display_hash | varbinary(32) | NO | | NULL | |
+----------------------------------+------------------+------+-----+---------+-------+

mysql> describe echo_notification;
+-----------------------------+------------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-----------------------------+------------------+------+-----+---------+-------+
| notification_event | int(10) unsigned | NO | PRI | NULL | |
| notification_user | int(10) unsigned | NO | PRI | NULL | |
| notification_timestamp | binary(14) | NO | | NULL | |
| notification_read_timestamp | binary(14) | YES | | NULL | |
+-----------------------------+------------------+------+-----+---------+-------+

• Wikimedia extension database tables
• Echo