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
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 1 513 rows at on aug 19 21:08 CEST 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