Table zot.abook Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
abook_id int unsigned 10  √ 
abook_account int unsigned 10 0
abook_channel int unsigned 10 0
abook_xchan char 255
xchan.xchan_hash Defined in XML R
abook_my_perms int 10 0
abook_their_perms int 10 0
abook_closeness tinyint unsigned 3 99
abook_created datetime 19 0000-00-00 00:00:00
abook_updated datetime 19 0000-00-00 00:00:00
abook_connected datetime 19 0000-00-00 00:00:00
abook_dob datetime 19 0000-00-00 00:00:00
abook_flags int 10 0
abook_blocked tinyint 3 0
abook_ignored tinyint 3 0
abook_hidden tinyint 3 0
abook_archived tinyint 3 0
abook_pending tinyint 3 0
abook_unconnected tinyint 3 0
abook_self tinyint 3 0
abook_feed tinyint 3 0
abook_profile char 64
abook_incl text 65535
abook_excl text 65535

Table contained 685 rows at fr nov 06 17:11 CET 2015

Indexes:
Column(s) Type Sort Constraint Name
abook_id Primary key Asc PRIMARY
abook_account Performance Asc abook_account
abook_archived Performance Asc abook_archived
abook_blocked Performance Asc abook_blocked
abook_channel Performance Asc abook_channel
abook_closeness Performance Asc abook_closeness
abook_connected Performance Asc abook_connected
abook_created Performance Asc abook_created
abook_dob Performance Asc abook_dob
abook_feed Performance Asc abook_feed
abook_flags Performance Asc abook_flags
abook_hidden Performance Asc abook_hidden
abook_ignored Performance Asc abook_ignored
abook_my_perms Performance Asc abook_my_perms
abook_pending Performance Asc abook_pending
abook_profile Performance Asc abook_profile
abook_self Performance Asc abook_self
abook_their_perms Performance Asc abook_their_perms
abook_unconnected Performance Asc abook_unconnected
abook_updated Performance Asc abook_updated
abook_xchan Performance Asc abook_xchan

Close relationships  within of separation: