Table tariqapro.sources
Data sources (inside 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
source_id int unsigned 10  √ 
__q_country_queries.source_id Implied Constraint R
adv_search.source_id FK_adv_search_sources R
backup_queries.source_id fk_backup_queries_sources C
queries.source_id fk_queries_sources R
queries_tmp.source_id Implied Constraint R
quicksearch_sources.source_id FK_quicksearch_sources C
title varchar 255
description text 65535  √  null
engine_id varchar 32
engines.engine_id fk_sources_engines R
Search engine to which the current source is relying on
source_data varchar 255  √  null Data used to identify the source inside the search engine
doc_url varchar 255  √  null URL where to find information about the source
copyright varchar 255  √  null
disclaimer text 65535  √  null
logo_url varchar 255  √  null URL of the logo of the data provider
icon_url varchar 255  √  null URL of the icon (small logo) of the data provider

Analyzed at Wed Apr 25 13:31 CEST 2012

Indexes:
Column(s) Type Sort Constraint Name
source_id Primary key Asc PRIMARY
source_id Performance Asc ai_sources
engine_id Performance Asc fk_sources_engines

Close relationships  within of separation: