Table zot.hubloc 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
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

Close relationships  within of separation: