evjar - Laravel Schema Designer

vehicles

id integer
name string (100)
brand_id ^FK integer
category_id ^FK integer
description text
primary_image text
360_view json
release_date date
created_at timestamp
updated_at timestamp

categories

id integer
name string (100)
description string (100)
created_at timestamp
updated_at timestamp

tags

id integer
name string (100)
slug string
created_at timestamp
updated_at timestamp

filters

id integer
name string (100)
slug string
created_at timestamp
updated_at timestamp

variant_tags

id integer
variant_id ^FK integer
tag_id ^FK integer
created_at timestamp
updated_at timestamp

category_filters

id integer
category_id ^FK integer
filter_id ^FK integer
value string (100)
created_at timestamp
updated_at timestamp

variants

id integer
vehicle_id ^FK integer
name string (100)
battery string (100)
range string (100)
charge_time string (100)
motor string (100)
riding_modes string (100)
max_loading_capacity string (100)
kerb_weight string (100)
brakes_type string (100)
storage_capacity string (100)
created_at timestamp
updated_at timestamp

location_prices

id integer
variant_id ^FK integer
location_id ^FK integer
base_price decimal
created_at timestamp
updated_at timestamp

color_options

id integer
variant_id ^FK integer
name string (100)
hex_code string
images json
created_at timestamp
updated_at timestamp

dealers

id integer
name string
location_id ^FK integer
contact_info text
geo_location string
address string

dealer_brands

id integer
brand_id ^FK integer
dealer_id ^FK integer
created_at timestamp
updated_at timestamp

locations

id integer
name string
parent_id integer
lft integer
rgt integer
depth integer
created_at timestamp
updated_at timestamp

collections

id integer
description text
slug string
created_at timestamp
updated_at timestamp

brands

id integer
name string
logo json
description text
created_at timestamp
updated_at timestamp

filter_tag

id integer
tag_id ^FK integer
filter_id ^FK integer
created_at timestamp
updated_at timestamp

adjustments

id integer
variant_id ^FK integer
location_id ^FK integer
type string
amount decimal
metadata json
created_at timestamp
updated_at timestamp

Laravel Schema Designer v0.7.1 follow me on twitter @okyn01