Table notify
-============
-
-| Field | Description | Type | Null | Key | Default | Extra |
-| ---------- | --------------------------------- | ------------ | ---- | --- | ------------------- | --------------- |
-| id | sequential ID | int(11) | NO | PRI | NULL | auto_increment |
-| hash | | varchar(64) | NO | | | |
-| type | | int(11) | NO | | 0 | |
-| name | | varchar(255) | NO | | | |
-| url | | varchar(255) | NO | | | |
-| photo | | varchar(255) | NO | | | |
-| date | | datetime | NO | | 0001-01-01 00:00:00 | |
-| msg | | mediumtext | YES | | NULL | |
-| uid | user.id of the owner of this data | int(11) | NO | MUL | 0 | |
-| link | | varchar(255) | NO | | | |
-| iid | item.id | int(11) | NO | | 0 | |
-| parent | | int(11) | NO | | 0 | |
-| seen | | tinyint(1) | NO | | 0 | |
-| verb | | varchar(255) | NO | | | |
-| otype | | varchar(16) | NO | | | |
-| name_cache | Cached bbcode parsing of name | tinytext | YES | | NULL | |
-| msg_cache | Cached bbcode parsing of msg | mediumtext | YES | | NULL | |
+===========
+
+[Deprecated] User notifications
+
+Fields
+------
+
+| Field | Description | Type | Null | Key | Default | Extra |
+| ------------- | --------------------------------------------- | ------------------ | ---- | --- | ------------------- | -------------- |
+| id | sequential ID | int unsigned | NO | PRI | NULL | auto_increment |
+| type | | smallint unsigned | NO | | 0 | |
+| name | | varchar(255) | NO | | | |
+| url | | varbinary(383) | NO | | | |
+| photo | | varbinary(383) | NO | | | |
+| date | | datetime | NO | | 0001-01-01 00:00:00 | |
+| msg | | mediumtext | YES | | NULL | |
+| uid | Owner User id | mediumint unsigned | NO | | 0 | |
+| link | | varbinary(383) | NO | | | |
+| iid | | int unsigned | YES | | NULL | |
+| parent | | int unsigned | YES | | NULL | |
+| uri-id | Item-uri id of the related post | int unsigned | YES | | NULL | |
+| parent-uri-id | Item-uri id of the parent of the related post | int unsigned | YES | | NULL | |
+| seen | | boolean | NO | | 0 | |
+| verb | | varchar(100) | NO | | | |
+| otype | | varchar(10) | NO | | | |
+| name_cache | Cached bbcode parsing of name | tinytext | YES | | NULL | |
+| msg_cache | Cached bbcode parsing of msg | mediumtext | YES | | NULL | |
+
+Indexes
+------------
+
+| Name | Fields |
+| ------------- | -------------------- |
+| PRIMARY | id |
+| seen_uid_date | seen, uid, date |
+| uid_date | uid, date |
+| uid_type_link | uid, type, link(190) |
+| uri-id | uri-id |
+| parent-uri-id | parent-uri-id |
+
+Foreign Keys
+------------
+
+| Field | Target Table | Target Field |
+|-------|--------------|--------------|
+| uid | [user](help/database/db_user) | uid |
+| uri-id | [item-uri](help/database/db_item-uri) | id |
+| parent-uri-id | [item-uri](help/database/db_item-uri) | id |
Return to [database documentation](help/database)