| abook_id | Sequential ID | int(10) unsigned | NO | PRI | NULL |
| abook_account | account.account_id of the channel which owns this record | int(10) unsigned | NO | MUL | 0 |
| abook_channel | channel.channel_id of the channel which owns this record | int(10) unsigned | NO | MUL | 0 |
| abook_xchan | xchan.xchan_hash of the target identity (this channel’s connection) | char(191) | 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_created | Datetime this record was created | datetime | NO | MUL | 0001-01-01 00:00:00 |
| abook_updated | Datetime this record was modified | datetime | NO | MUL | 0001-01-01 00:00:00 |
| abook_connected | datetime of last successful “poll” for this connection | datetime | NO | MUL | 0001-01-01 00:00:00 |
| abook_dob | Datetime of connection’s birthday converted from their timezone to UTC | datetime | NO | MUL | 0001-01-01 00:00:00 |
| abook_flags | No longer used | int(11) | NO | MUL | 0 |
| abook_blocked | Bi-directional communications with this channel are blocked, regardless of other permissions. | tinyint(4) | NO | MUL | 0 |
| abook_ignored | Incoming communications from this channel are blocked, regardless of other permissions. | tinyint(4) | NO | MUL | 0 |
| abook_hidden | This connection will not be shown as a connection to anybody but the channel owner | tinyint(4) | NO | MUL | 0 |
| abook_archived | This connection is likely non-functioning and the entry and conversations are preserved, but further polled communications will not be attempted. | tinyint(4) | NO | MUL | 0 |
| abook_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. | tinyint(4) | NO | MUL | 0 |
| abook_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. | tinyint(4) | NO | MUL | 0 |
| abook_self | is a special case where the owner is the target. Every channel has one abook entry with abook_self and 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. | tinyint(4) | NO | MUL | 0 |
| abook_feed | indicates this connection is an RSS/Atom feed and may trigger special handling. | tinyint(4) | NO | MUL | 0 |
| abook_not_here | | tinyint(4) | NO | MUL | 0 |
| abook_profile | | char(191) | NO | MUL | |
| abook_incl | connection filter allow rules separated by LF | text | NO | | |
| abook_excl | connection filter deny rules separated by LF | text | NO | | |
| abook_instance | comma separated list of site urls of all channel clones that this connection is connected with (used only for singleton networks which don’t support cloning) | text | NO | | |
| abook_role | | char(191) | NO | MUL | |