Table tariqapro.queries_regions
Associates Data sources and Regions

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_regions_queries R
region_id int unsigned 10 0
regions.region_id fk_queries_regions_regions 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  √  null
flavours.flavour_id FK_queries_regions_flavours R
The query flavour identifier

Analyzed at Wed Apr 25 13:31 CEST 2012

Indexes:
Column(s) Type Sort Constraint Name
query_id + region_id Primary key Asc/Asc PRIMARY
flavour_id Performance Asc FK_queries_regions_flavours
region_id Performance Asc fk_queries_regions_regions

Close relationships  within of separation: