Redmatrix Documentation

abook_idSequential IDint(10) unsignedNOPRINULLauto_increment
abook_accountaccount.account_id of the channel which owns this recordint(10) unsignedNOMULNULL
abook_channelchannel.channel_id of the channel which owns this recordint(10) unsignedNOMULNULL
abook_xchanxchan.xchan_hash of the target identity (this channel's connection)char(255)NOMUL
abook_my_permsbitfield of all specific permissions granted this connectionint(11)NOMUL0
abook_their_permsbitfield of all permissions granted to you by this connectionint(11)NOMUL0
abook_closeness"closeness" value for optional affinity tool, 0-99tinyint(3) unsignedNOMUL99
abook_ratingThe channel owner's (public) rating of this connection -10 to +10, default 0 or unratedint(11)NOMUL0
abook_rating_textThe channel owner's (public) rating of this connection free form texttextNOMUL
abook_createdDatetime this record was createddatetimeNOMUL0000-00-00 00:00:00
abook_updatedDatetime this record was modifieddatetimeNOMUL0000-00-00 00:00:00
abook_connecteddatetime of last successful "poll" for this connectiondatetimeNOMUL0000-00-00 00:00:00
abook_dobDatetime of connection's birthday converted from *their* timezone to UTCdatetimeNOMUL0000-00-00 00:00:00
abook_flagsBitfield containing blocked(0x1), ignored(0x2), hidden(0x4), archived(0x8), pending(0x10), unconnected(0x20), self(0x80), feed(0x100)int(11)NOMUL0
abook_profileprofile.guid of profile to display to this connection if authenticatedchar(64)NOMUL


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