laundrybox - Laravel Schema Designer

items

id increments
timestamps timestamps
barcode string (30)
sku string (32)
color string (30)
size string (5)
brand string (30)
remark text
status_id ^FK bigInteger
order_id string (20)
type string (100)
machine_type_id bigInteger
wash_program_id bigInteger
drying_rotation_id bigInteger
wash_type string (80)

statuses

id increments
name string (50)

users

id increments
timestamps timestamps
username string (80)
password string (100)
role bigInteger

orders

id increments
timestamps timestamps
due_date datetime
remarks text
is_packed boolean
bag_id string (80)

machine_types

id increments
name string (80)

wash_program

id increments
name string (80)

drying_rotations

id increments
name string (80)

order_item

id increments
order_id bigInteger
item_id bigInteger

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