Table tariqapro.queries
Data sources/queries to run on the search engines

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  √ 
newstickers_queries.query_id FK_newstickers_queries_queries C
queries_countries.query_id fk_queries_countries_queries C
queries_homepage.query_id fk_queries_homepage_queries C
queries_regions.query_id fk_queries_regions_queries R
queries_themes.query_id fk_queries_themes_queries C
topics_queries.query_id FK_topics_queries_queries R
weblogs.query_id weblogs_ibfk_1 R
source_id int unsigned 10
sources.source_id fk_queries_sources R
Data source
title varchar 255 Title of the data block
description text 65535  √  null Optional description of the block
query text 65535 Query to run amongst the search engine
time_range varchar 50 15 Time range (in days) for the queries
flavour_id int unsigned 10  √  null
flavours.flavour_id FK_queries_flavours R
The theme identifier
icon varchar 255  √  null

Analyzed at Wed Apr 25 13:31 CEST 2012

Indexes:
Column(s) Type Sort Constraint Name
query_id Primary key Asc PRIMARY
query_id Performance Asc ai_queries
flavour_id Performance Asc FK_queries_flavours
source_id Performance Asc fk_queries_sources

Close relationships  within of separation: