diff options
| author | redmatrix <redmatrix@redmatrix.me> | 2015-11-08 20:02:35 -0800 |
|---|---|---|
| committer | redmatrix <redmatrix@redmatrix.me> | 2015-11-08 20:02:35 -0800 |
| commit | 5e1b61eb02272698023204a29c1d96e5350f4ceb (patch) | |
| tree | 14dd8ad1ab684d277cfe760004fe91a7ccb32123 /doc/database/db_item_id.bb | |
| parent | 4e1c308162877d7d6cd79c066f15b4d761e14853 (diff) | |
| download | volse-hubzilla-5e1b61eb02272698023204a29c1d96e5350f4ceb.tar.gz volse-hubzilla-5e1b61eb02272698023204a29c1d96e5350f4ceb.tar.bz2 volse-hubzilla-5e1b61eb02272698023204a29c1d96e5350f4ceb.zip | |
some more db doco
Diffstat (limited to 'doc/database/db_item_id.bb')
| -rw-r--r-- | doc/database/db_item_id.bb | 10 |
1 files changed, 5 insertions, 5 deletions
diff --git a/doc/database/db_item_id.bb b/doc/database/db_item_id.bb index b77ae2d1a..ba4cca247 100644 --- a/doc/database/db_item_id.bb +++ b/doc/database/db_item_id.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]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]iid[/td][td][/td][td]int(11)[/td][td]NO[/td][td]MUL[/td][td]NULL[/td][td] +[tr][td]iid[/td][td]item.id of the referenced item[/td][td]int(11)[/td][td]NO[/td][td]MUL[/td][td]NULL[/td][td] [/td][/tr] -[tr][td]uid[/td][td][/td][td]int(11)[/td][td]NO[/td][td]MUL[/td][td]NULL[/td][td] +[tr][td]uid[/td][td]channel.channel_id of the owner of this data[/td][td]int(11)[/td][td]NO[/td][td]MUL[/td][td]NULL[/td][td] [/td][/tr] -[tr][td]sid[/td][td][/td][td]char(255)[/td][td]NO[/td][td]MUL[/td][td]NULL[/td][td] +[tr][td]sid[/td][td]an additional identifier to attach or link to the referenced item (often used to store a message_id from another system in order to suppress duplicates)[/td][td]char(255)[/td][td]NO[/td][td]MUL[/td][td]NULL[/td][td] [/td][/tr] -[tr][td]service[/td][td][/td][td]char(255)[/td][td]NO[/td][td]MUL[/td][td]NULL[/td][td] +[tr][td]service[/td][td]the name or description of the service which generated this identifier[/td][td]char(255)[/td][td]NO[/td][td]MUL[/td][td]NULL[/td][td] [/td][/tr] [/table] |