X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=doc%2Fdatabase%2Fdb_post-thread-user.md;h=a89d94c96fa09fa7346cc2a0836014b9072a9f7c;hb=4fb8a4c6a8bda9cbac06da2e456a6412bde9e313;hp=e4f5e39bdae85b91733a3698f68a53c094bf4ef4;hpb=19529e2aa19a41dae560c999f6f3dda4e319d722;p=friendica.git diff --git a/doc/database/db_post-thread-user.md b/doc/database/db_post-thread-user.md index e4f5e39bda..a89d94c96f 100644 --- a/doc/database/db_post-thread-user.md +++ b/doc/database/db_post-thread-user.md @@ -36,25 +36,31 @@ Fields Indexes ------------ -| Name | Fields | -| ----------------- | ------------------- | -| PRIMARY | uid, uri-id | -| uri-id | uri-id | -| conversation-id | conversation-id | -| owner-id | owner-id | -| author-id | author-id | -| causer-id | causer-id | -| uid | uid | -| contact-id | contact-id | -| psid | psid | -| post-user-id | post-user-id | -| commented | commented | -| received | received | -| uid_received | uid, received | -| uid_wall_received | uid, wall, received | -| uid_commented | uid, commented | -| uid_starred | uid, starred | -| uid_mention | uid, mention | +| Name | Fields | +| -------------------- | --------------------- | +| PRIMARY | uid, uri-id | +| uri-id | uri-id | +| conversation-id | conversation-id | +| owner-id | owner-id | +| author-id | author-id | +| causer-id | causer-id | +| uid | uid | +| contact-id | contact-id | +| psid | psid | +| post-user-id | post-user-id | +| commented | commented | +| received | received | +| author-id_created | author-id, created | +| owner-id_created | owner-id, created | +| uid_received | uid, received | +| uid_wall_received | uid, wall, received | +| uid_commented | uid, commented | +| uid_created | uid, created | +| uid_starred | uid, starred | +| uid_mention | uid, mention | +| contact-id_commented | contact-id, commented | +| contact-id_received | contact-id, received | +| contact-id_created | contact-id, created | Foreign Keys ------------