Table openx.ox_variables 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
variableid mediumint unsigned 8  √ 
ox_data_bkt_a_var.tracker_variable_id Defined in XML
ox_data_intermediate_ad_variable_value.tracker_variable_id Defined in XML
ox_data_raw_tracker_variable_value.tracker_variable_id Defined in XML
ox_variable_publisher.variable_id Defined in XML
trackerid mediumint 7 0
ox_trackers.trackerid Defined in XML
name varchar 250
description varchar 250  √  null
datatype enum 8 numeric
purpose enum 13  √  null
reject_if_empty smallint unsigned 5 0
is_unique int 10 0
unique_window int 10 0
variablecode varchar 255
hidden enum 2 f
updated datetime 0

Table contained 0 rows at Sat Feb 28 16:58 EST 2009

Indexes:
Column(s) Type Sort Constraint Name
variableid Primary key Asc PRIMARY
is_unique Performance Asc ox_variables_is_unique
trackerid Performance Asc ox_variables_trackerid

Close relationships  within of separation: