SchemaSpy - Table zot.hubloc

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

hubloc_id

int unsigned

10

√

hubloc_guid

char

255

hubloc_guid_sig

text

65535

hubloc_hash

char

255

attach.hash	Defined in XML R
event.event_hash	Defined in XML R
groups.hash	Defined in XML R
hubloc.hubloc_hash	Defined in XML R
notify.hash	Defined in XML R
outq.outq_hash	Defined in XML R
profext.hash	Defined in XML R
register.hash	Defined in XML R
term.parent_hash	Defined in XML R
term.term_hash	Defined in XML R
updates.ud_hash	Defined in XML R
xchan.xchan_hash	Defined in XML R
xprof.xprof_hash	Defined in XML R
xtag.xtag_hash	Defined in XML R

hubloc.hubloc_hash	Defined in XML R
channel.channel_hash	Defined in XML R
xchan.xchan_hash	Defined in XML R

hubloc_addr

char

255

hubloc_network

char

32

hubloc_flags

int unsigned

10

0

hubloc_status

int unsigned

10

0

hubloc_url

char

255

hubloc_url_sig

text

65535

hubloc_host

char

255

hubloc_callback

char

255

hubloc_connect

char

255

hubloc_sitekey

text

65535

hubloc_updated

datetime

19

0000-00-00 00:00:00

hubloc_connected

datetime

19

0000-00-00 00:00:00

hubloc_primary

bit

0

0

hubloc_orphancheck

bit

0

0

hubloc_error

bit

0

0

hubloc_deleted

bit

0

0

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

Indexes:

Column(s)	Type	Sort	Constraint Name
hubloc_id	Primary key	Asc	PRIMARY
hubloc_addr	Performance	Asc	hubloc_addr
hubloc_connect	Performance	Asc	hubloc_connect
hubloc_connected	Performance	Asc	hubloc_connected
hubloc_deleted	Performance	Asc	hubloc_deleted
hubloc_error	Performance	Asc	hubloc_error
hubloc_flags	Performance	Asc	hubloc_flags
hubloc_guid	Performance	Asc	hubloc_guid
hubloc_host	Performance	Asc	hubloc_host
hubloc_network	Performance	Asc	hubloc_network
hubloc_orphancheck	Performance	Asc	hubloc_orphancheck
hubloc_primary	Performance	Asc	hubloc_primary
hubloc_status	Performance	Asc	hubloc_status
hubloc_updated	Performance	Asc	hubloc_updated
hubloc_url	Performance	Asc	hubloc_url