X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;ds=sidebyside;f=doc%2Fdatabase%2Fdb_post-user.md;h=ce213941dac071e890e6c6b09a3d0eeae81fe6e6;hb=e5c24f33f0c3c51a153a23612fed88be660d0de0;hp=6d2f0c71b6c9f4e602e0b268b03cc174c9b41cbc;hpb=96f07c7288a0b9a2433ad66ee6cef21612d90264;p=friendica.git diff --git a/doc/database/db_post-user.md b/doc/database/db_post-user.md index 6d2f0c71b6..ce213941da 100644 --- a/doc/database/db_post-user.md +++ b/doc/database/db_post-user.md @@ -42,28 +42,29 @@ Fields Indexes ------------ -| Name | Fields | -|------|---------| -| PRIMARY | id | -| uid_uri-id | UNIQUE, uid, uri-id | -| uri-id | uri-id | -| parent-uri-id | parent-uri-id | -| thr-parent-id | thr-parent-id | -| external-id | external-id | -| owner-id | owner-id | -| author-id | author-id | -| causer-id | causer-id | -| vid | vid | -| contact-id | contact-id | -| event-id | event-id | -| psid | psid | -| author-id_uid | author-id, uid | -| author-id_received | author-id, received | -| parent-uri-id_uid | parent-uri-id, uid | -| uid_contactid | uid, contact-id | +| Name | Fields | +| -------------------- | ----------------------- | +| PRIMARY | id | +| uid_uri-id | UNIQUE, uid, uri-id | +| uri-id | uri-id | +| parent-uri-id | parent-uri-id | +| thr-parent-id | thr-parent-id | +| external-id | external-id | +| owner-id | owner-id | +| author-id | author-id | +| causer-id | causer-id | +| vid | vid | +| contact-id | contact-id | +| event-id | event-id | +| psid | psid | +| author-id_uid | author-id, uid | +| author-id_received | author-id, received | +| parent-uri-id_uid | parent-uri-id, uid | +| uid_wall_received | uid, wall, received | +| uid_contactid | uid, contact-id | | uid_unseen_contactid | uid, unseen, contact-id | -| uid_unseen | uid, unseen | -| uid_hidden_uri-id | uid, hidden, uri-id | +| uid_unseen | uid, unseen | +| uid_hidden_uri-id | uid, hidden, uri-id | Foreign Keys ------------