closest_competitor


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
version BIGINT 19 √ null
brand VARCHAR 255 √ null
route_distance_in_miles DECIMAL 6,2 √ null
route_time_in_minutes DECIMAL 6,2 √ null
straight_line_distance_in_miles DECIMAL 6,2 √ null
is_closest_by_drivetime BIT 1 √ null
is_closest_by_straight_line BIT 1 √ null
closest_of_channel_by_drivetime VARCHAR 255 √ null
closest_of_channel_by_straight_line VARCHAR 255 √ null
site_id INT 10 null
site.id closest_competitor_ibfk_1 R

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
site_id Performance Asc site_id

Relationships

Close relationships within degrees of separation