aboutsummaryrefslogtreecommitdiffstats
path: root/doc/database/db_chat.bb
diff options
context:
space:
mode:
authorredmatrix <redmatrix@redmatrix.me>2015-11-06 23:43:48 -0800
committerredmatrix <redmatrix@redmatrix.me>2015-11-06 23:43:48 -0800
commit44fa4d10813b2909fb7b5aa1f904784294568682 (patch)
tree646b8655f70f03c0325a89c3746b58cd8c5184c1 /doc/database/db_chat.bb
parent81544538032500c05a14fc90902e2930b1c4b03a (diff)
downloadvolse-hubzilla-44fa4d10813b2909fb7b5aa1f904784294568682.tar.gz
volse-hubzilla-44fa4d10813b2909fb7b5aa1f904784294568682.tar.bz2
volse-hubzilla-44fa4d10813b2909fb7b5aa1f904784294568682.zip
more db schema doco
Diffstat (limited to 'doc/database/db_chat.bb')
-rw-r--r--doc/database/db_chat.bb10
1 files changed, 5 insertions, 5 deletions
diff --git a/doc/database/db_chat.bb b/doc/database/db_chat.bb
index 6221f36e2..1aac2bd15 100644
--- a/doc/database/db_chat.bb
+++ b/doc/database/db_chat.bb
@@ -1,15 +1,15 @@
[table]
[tr][th]Field[/th][th]Description[/th][th]Type[/th][th]Null[/th][th]Key[/th][th]Default[/th][th]Extra
[/th][/tr]
-[tr][td]chat_id[/td][td][/td][td]int(10) unsigned[/td][td]NO[/td][td]PRI[/td][td]NULL[/td][td]auto_increment
+[tr][td]chat_id[/td][td]sequential ID[/td][td]int(10) unsigned[/td][td]NO[/td][td]PRI[/td][td]NULL[/td][td]auto_increment
[/td][/tr]
-[tr][td]chat_room[/td][td][/td][td]int(10) unsigned[/td][td]NO[/td][td]MUL[/td][td]0[/td][td]
+[tr][td]chat_room[/td][td]chatroom.cr_id for this chat[/td][td]int(10) unsigned[/td][td]NO[/td][td]MUL[/td][td]0[/td][td]
[/td][/tr]
-[tr][td]chat_xchan[/td][td][/td][td]char(255)[/td][td]NO[/td][td]MUL[/td][td][/td][td]
+[tr][td]chat_xchan[/td][td]author xchan_hash[/td][td]char(255)[/td][td]NO[/td][td]MUL[/td][td][/td][td]
[/td][/tr]
-[tr][td]chat_text[/td][td][/td][td]mediumtext[/td][td]NO[/td][td][/td][td]NULL[/td][td]
+[tr][td]chat_text[/td][td]the text of the chat message[/td][td]mediumtext[/td][td]NO[/td][td][/td][td]NULL[/td][td]
[/td][/tr]
-[tr][td]created[/td][td][/td][td]datetime[/td][td]NO[/td][td]MUL[/td][td]0000-00-00 00:00:00[/td][td]
+[tr][td]created[/td][td]timestamp of this message[/td][td]datetime[/td][td]NO[/td][td]MUL[/td][td]0000-00-00 00:00:00[/td][td]
[/td][/tr]
[/table]