Table zot.updates 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
ud_id int unsigned 10  √ 
ud_hash char 128
hubloc.hubloc_hash Defined in XML R
channel.channel_hash Defined in XML R
xchan.xchan_hash Defined in XML R
ud_guid char 255
ud_date datetime 19 0000-00-00 00:00:00
ud_last datetime 19 0000-00-00 00:00:00
ud_flags int 10 0
ud_addr char 255

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

Indexes:
Column(s) Type Sort Constraint Name
ud_id Primary key Asc PRIMARY
ud_addr Performance Asc ud_addr
ud_date Performance Asc ud_date
ud_flags Performance Asc ud_flags
ud_guid Performance Asc ud_guid
ud_hash Performance Asc ud_hash
ud_last Performance Asc ud_last

Close relationships  within of separation: