Table tariqapro.queries_homepage
Associates Data sources and Homepage

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
query_id int unsigned 10
queries.query_id fk_queries_homepage_queries C
description text 65535  √  null Optional description of the data block
display_order int unsigned 10 0 The higher, the closer to the top of the page will the block be displayed
flavour_id int unsigned 10
homepage_flavours.flavour_id fk_homepage_flavours R

Analyzed at Wed Apr 25 13:31 CEST 2012

Indexes:
Column(s) Type Sort Constraint Name
query_id + flavour_id Primary key Asc/Asc PRIMARY
flavour_id Performance Asc fk_queries_homepage_flavours
query_id Performance Asc fk_queries_homepage_queries

Close relationships  within of separation: