Fixed documentation/SQL dump with ./bin/console dbstructure dump

[friendica.git] / doc / database / db_notify.md

diff --git a/doc/database/db_notify.md b/doc/database/db_notify.md
index a9eac5a3c8ad37f4e88d292b047c81abd10e9d52..88d814c0408ca5ce035428470252de10b7a1dfc1 100644 (file)
--- a/doc/database/db_notify.md
+++ b/doc/database/db_notify.md
@@ -1,7 +1,10 @@
 Table notify
 ===========
 
-notifications
+[Deprecated] User notifications
+
+Fields
+------
 
 | Field         | Description                                   | Type               | Null | Key | Default             | Extra          |
 | ------------- | --------------------------------------------- | ------------------ | ---- | --- | ------------------- | -------------- |
@@ -24,4 +27,25 @@ notifications
 | 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)