Table tariqapro.queries_countries
Associates Data sources and Countries

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_countries_queries C
country_id varchar 2
countries.country_id fk_queries_countries_countries R
label varchar 255  √  null Optional label for the data block
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
flavours.flavour_id FK_queries_countries_flavours R
The query flavour identifier

Analyzed at Wed Apr 25 13:31 CEST 2012

Indexes:
Column(s) Type Sort Constraint Name
query_id + country_id + flavour_id Primary key Asc/Asc/Asc PRIMARY
country_id Performance Asc fk_queries_countries_countries
flavour_id Performance Asc FK_queries_countries_flavours

Close relationships  within of separation: