Table tariqa3.app_log 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
log_id int 10  √ 
app_log_d.log_id Implied Constraint R
app_log_details.log_id app_log_details_ibfk_1 C
app_log_dt.log_id Implied Constraint R
app_log_enginefullactivity.log_id Implied Constraint R
app_log_realusage.log_id Implied Constraint R
app_log_unvoluntarysearches.log_id Implied Constraint R
app_log_usageoffiltering_inner.log_id Implied Constraint R
app_log_voluntaryarticles.log_id Implied Constraint R
app_log_voluntarysearches.log_id Implied Constraint R
app_log_voluntarysearchesandarticles.log_id Implied Constraint R
rss_log.log_id Implied Constraint R
user_id varchar 16  √  null
known_users.user_id app_log_ibfk_1 N
url text 65535
time timestamp 19 CURRENT_TIMESTAMP

Analyzed at Wed Apr 25 13:30 CEST 2012

Indexes:
Column(s) Type Sort Constraint Name
log_id Primary key Asc PRIMARY
time Performance Asc ixTime
url Performance Asc ixUrl
user_id Performance Asc user_id

Close relationships  within of separation: