aboutsummaryrefslogtreecommitdiffstats
path: root/doc/database/db_groups.bb
diff options
context:
space:
mode:
authorredmatrix <redmatrix@redmatrix.me>2015-11-08 20:02:35 -0800
committerredmatrix <redmatrix@redmatrix.me>2015-11-08 20:02:35 -0800
commit5e1b61eb02272698023204a29c1d96e5350f4ceb (patch)
tree14dd8ad1ab684d277cfe760004fe91a7ccb32123 /doc/database/db_groups.bb
parent4e1c308162877d7d6cd79c066f15b4d761e14853 (diff)
downloadvolse-hubzilla-5e1b61eb02272698023204a29c1d96e5350f4ceb.tar.gz
volse-hubzilla-5e1b61eb02272698023204a29c1d96e5350f4ceb.tar.bz2
volse-hubzilla-5e1b61eb02272698023204a29c1d96e5350f4ceb.zip
some more db doco
Diffstat (limited to 'doc/database/db_groups.bb')
-rw-r--r--doc/database/db_groups.bb12
1 files changed, 6 insertions, 6 deletions
diff --git a/doc/database/db_groups.bb b/doc/database/db_groups.bb
index 03e4fe2d7..078d96464 100644
--- a/doc/database/db_groups.bb
+++ b/doc/database/db_groups.bb
@@ -1,17 +1,17 @@
[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]id[/td][td][/td][td]int(10) unsigned[/td][td]NO[/td][td]PRI[/td][td]NULL[/td][td]auto_increment
+[tr][td]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]hash[/td][td][/td][td]char(255)[/td][td]NO[/td][td]MUL[/td][td][/td][td]
+[tr][td]hash[/td][td]unique hash representing this group with the group name appended[/td][td]char(255)[/td][td]NO[/td][td]MUL[/td][td][/td][td]
[/td][/tr]
-[tr][td]uid[/td][td][/td][td]int(10) unsigned[/td][td]NO[/td][td]MUL[/td][td]NULL[/td][td]
+[tr][td]uid[/td][td]channel.channel_id owning this data[/td][td]int(10) unsigned[/td][td]NO[/td][td]MUL[/td][td]NULL[/td][td]
[/td][/tr]
-[tr][td]visible[/td][td][/td][td]tinyint(1)[/td][td]NO[/td][td]MUL[/td][td]0[/td][td]
+[tr][td]visible[/td][td]1 indicates the member list is not private[/td][td]tinyint(1)[/td][td]NO[/td][td]MUL[/td][td]0[/td][td]
[/td][/tr]
-[tr][td]deleted[/td][td][/td][td]tinyint(1)[/td][td]NO[/td][td]MUL[/td][td]0[/td][td]
+[tr][td]deleted[/td][td]1 indicates the group has been deleted[/td][td]tinyint(1)[/td][td]NO[/td][td]MUL[/td][td]0[/td][td]
[/td][/tr]
-[tr][td]name[/td][td][/td][td]char(255)[/td][td]NO[/td][td][/td][td]NULL[/td][td]
+[tr][td]name[/td][td]human readable name of group[/td][td]char(255)[/td][td]NO[/td][td][/td][td]NULL[/td][td]
[/td][/tr]
[/table]