Extension:Echo/echo_notification テーブル
Appearance
A notification is a user being notified about a certain event. Multiple users can be notified about the same event.
フィールド
notification_event
echo_event.event_id
へのキー
notification_user
user.user_id
へのキー
notification_timestamp
通知が作成されたときのタイムスタンプ
notification_read_timestamp
利用者が通知を読んだときのタイムスタンプ、または未読の場合は null
notification_bundle_hash
Hash for bundling together similar notifications. Notifications that can be bundled together will have the same hash
スキーマの要約
MediaWiki バージョン: | ≧ 1.33 |
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 | | +----------------------------------+------------------+------+-----+---------+-------+
MediaWiki バージョン: | 1.22 – 1.32 |
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 | | +----------------------------------+------------------+------+-----+---------+-------+
MediaWiki バージョン: | 1.20 – 1.21 |
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 | | +-----------------------------+------------------+------+-----+---------+-------+