dsfood-bestellsystem - Laravel Schema Designer

accounts

id increments
number string
name string (255)
timestamps timestamps

customers

id increments
account_id ^FK integer
number string
name string (255)
street string (255)
zip string (255)
city string (255)
country string (255)
phone string (255)
email string (255)
phone_pin char (4)
timestamps timestamps

articles

id increments
sku string (255)
name string (255)
description string (255)
timestamps timestamps

orders

id increments
account_id ^FK integer
customer_id ^FK integer
source_id ^FK integer
is_confirmed boolean
is_exported boolean
confirmed_at datetime
exported_at datetime
timestamps timestamps

documents

id increments
order_id ^FK integer
name string (255)
path string (255)
type string (255)
timestamps timestamps

article_order

id increments
article_id ^FK integer
order_id ^FK integer
quantity integer

sources

id increments
name string
timestamps timestamps

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