X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=doc%2Fdatabase%2Fdb_post-thread-user.md;h=a89d94c96fa09fa7346cc2a0836014b9072a9f7c;hb=4fb8a4c6a8bda9cbac06da2e456a6412bde9e313;hp=9026370491c7bf061bf2eddee5472b862ba4fbca;hpb=a5d679ea959a4317be76efd8cad99bf00ba6e3d0;p=friendica.git diff --git a/doc/database/db_post-thread-user.md b/doc/database/db_post-thread-user.md index 9026370491..a89d94c96f 100644 --- a/doc/database/db_post-thread-user.md +++ b/doc/database/db_post-thread-user.md @@ -36,24 +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 | -| 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 ------------