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