lastbox - Laravel Schema Designer

users

id increments
timestamps timestamps
type smallInteger

user_types

id increments
timestamps timestamps

items

id increments
timestamps timestamps
article_external string
name string
description string
image string
price_initial decimal

item_tags

id increments
timestamps timestamps
name string

item_has_tags

id increments
timestamps timestamps
item_id ^FK integer
tag_id ^FK integer

shops

id increments
timestamps timestamps
name string
address_dadata string
image string

shop_offers

id increments
timestamps timestamps
ends_at timestampsTz
status smallInteger
shop_id ^FK integer
item_id ^FK integer
qty smallInteger
price decimal

customers

id increments
timestamps timestamps
name string
email string
phone string (20)

orders

id increments
timestamps timestamps
status smallInteger
number string (16)
customer_id ^FK integer
shop_id ^FK integer

order_items

id increments
timestamps timestamps
order_id ^FK integer
offer_id ^FK integer
qty smallInteger

shop_has_users

id increments
timestamps timestamps
shop_id ^FK integer
user_id ^FK integer

payments

id increments
timestamps timestamps
order_id ^FK integer
status smallInteger

status_log

id increments
timestamps timestamps
model string (255)
model_id integer
old_status smallInteger
new_status smallInteger

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