|abook_id||Sequential ID||int(10) unsigned||NO||PRI||NULL||auto_increment|
|abook_account||account.account_id of the channel which owns this record||int(10) unsigned||NO||MUL||NULL|
|abook_channel||channel.channel_id of the channel which owns this record||int(10) unsigned||NO||MUL||NULL|
|abook_xchan||xchan.xchan_hash of the target identity (this channel's connection)||char(255)||NO||MUL|
|abook_my_perms||bitfield of all specific permissions granted this connection||int(11)||NO||MUL||0|
|abook_their_perms||bitfield of all permissions granted to you by this connection||int(11)||NO||MUL||0|
|abook_closeness||"closeness" value for optional affinity tool, 0-99||tinyint(3) unsigned||NO||MUL||99|
|abook_rating||The channel owner's (public) rating of this connection -10 to +10, default 0 or unrated||int(11)||NO||MUL||0|
|abook_rating_text||The channel owner's (public) rating of this connection free form text||text||NO||MUL|
|abook_created||Datetime this record was created||datetime||NO||MUL||0000-00-00 00:00:00|
|abook_updated||Datetime this record was modified||datetime||NO||MUL||0000-00-00 00:00:00|
|abook_connected||datetime of last successful "poll" for this connection||datetime||NO||MUL||0000-00-00 00:00:00|
|abook_dob||Datetime of connection's birthday converted from *their* timezone to UTC||datetime||NO||MUL||0000-00-00 00:00:00|
|abook_flags||Bitfield containing blocked(0x1), ignored(0x2), hidden(0x4), archived(0x8), pending(0x10), unconnected(0x20), self(0x80), feed(0x100)||int(11)||NO||MUL||0|
|abook_profile||profile.guid of profile to display to this connection if authenticated||char(64)||NO||MUL|
ABOOK_FLAGS_BLOCKED - Bi-directional communications with this channel are blocked, regardless of other permissions.
ABOOK_FLAGS_IGNORED - Incoming communications from this channel are blocked, regardless of other permissions.
ABOOK_FLAGS_HIDDEN - This connection will not be shown as a connection to anybody but the channel owner
ABOOK_FLAGS_ARCHIVED - This connection is likely non-functioning and the entry and conversations are preserved, but further polled communications will not be attempted.
ABOOK_FLAGS_PENDING - A connection request was received from this channel but has not been approved by the channel owner, public communications may still be visible but no additional permissions have been granted.
ABOOK_FLAGS_UNCONNECTED - currently unused. Projected usage is to indicate "one-way" connections which were insitgated on this end but are still pending on the remote end.
ABOOK_FLAGS_SELF is a special case where the owner is the target. Every channel has one abook entry with ABOOK_FLAGS_SELF with a target abook_xchan set to channel.channel_hash . When this flag is present, abook_my_perms is the default permissions granted to all new connections and several other fields are unused.
ABOOK_FLAGS_FEED - indicates this connection is an RSS/Atom feed and may trigger special handling.
Return to database documentation