Table tariqapro.queries_themes
Associates Data sources and Themes

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_themes_queries C
theme_id int unsigned 10
themes.theme_id fk_queries_themes_themes C
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

Analyzed at Wed Apr 25 13:31 CEST 2012

Indexes:
Column(s) Type Sort Constraint Name
query_id + theme_id Primary key Asc/Asc PRIMARY
theme_id Performance Asc fk_queries_themes_themes

Close relationships  within of separation: