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