production2 - Laravel Schema Designer

pallets

id bigIncrements
code string (13)
date date
plan_id ^FK bigInteger
number integer
type integer
brand_id bigInteger
lot_id bigInteger
location_id bigInteger
wip tinyInteger
product_id ^FK bigInteger
size_id ^FK bigInteger
surface_id ^FK bigInteger
color_id ^FK bigInteger
weight_id ^FK bigInteger
timestamps timestamps

travelcards

id bigIncrements
code string (14)
date date
shift integer
plan_id ^FK bigInteger
line integer
tumble integer
product_id ^FK bigInteger
size_id ^FK bigInteger
surface_id ^FK bigInteger
color_id ^FK bigInteger
weight_id ^FK bigInteger
timestamps timestamps

plans

id bigIncrements
name string
abbr string
timestamps timestamps

products

id bigIncrements
name string
abbr string
timestamps timestamps

sizes

id bigIncrements
name string
abbr string
timestamps timestamps

surfaces

id bigIncrements
name string
abbr string
timestamps timestamps

colors

id bigIncrements
name string
abbr string
timestamps timestamps

weights

id bigIncrements
name string
abbr string
timestamps timestamps

travelcard_pallet

id bigIncrements
timestamps timestamps
pallet_id ^FK bigInteger
travelcard_id ^FK bigInteger
bags integer
cartons integer
from_pallet_id ^FK bigInteger

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