SchemaSpy - Table zot.abook

Generated by
SchemaSpy

Legend:

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