Table tariqapro.backup_queries
Backup of 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
backup_id int unsigned 10  √ 
query_id int unsigned 10
weblogs.query_id Implied Constraint R
source_id int unsigned 10
sources.source_id fk_backup_queries_sources C
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_backup_queries_flavours C
The theme identifier
icon varchar 255  √  null

Analyzed at Wed Apr 25 13:31 CEST 2012

Indexes:
Column(s) Type Sort Constraint Name
backup_id Primary key Asc PRIMARY
flavour_id Performance Asc fK_backup_queries_flavours
source_id Performance Asc fk_backup_queries_sources

Close relationships  within of separation: