kfetmanager - Laravel Schema Designer

event_products

id increments
product_id ^FK integer
event_id ^FK integer
cost float
price float
quantity_sold integer
quantity_bought integer
name string (255)

products

id increments
name string (255)
description text
price float
quantity integer
subcategory_id ^FK integer

staff

id increments
firstname string (255)
lastname string (255)
email string (255)
role string (255)

event_accessories

id increments
event_id ^FK integer
name string (255)
cost float
quantity integer

money_addings

id increments
date date
amount float
reason string (255)
description text

customers

id increments
firstname string (255)
lastname string (255)
staff_id ^FK integer
balance float

purchases

id increments
cost float
quantity integer
date date
description text

orders

id increments
customer_id ^FK integer
timestamps timestamps
menu_id ^FK integer
discount decimal

restockings

id increments
date date
cost float
description text

subcategories

id increments
category_id ^FK integer
name string (255)
price float

menus

id increments
name string (255)
description text
price float

product_restocking

id increments
product_id ^FK integer
quantity integer
restocking_id ^FK integer

kfet

id increments
balance float
reason_id integer
reason_table string (255)
timestamps timestamp
reason_type enum

events

id increments
date date
description text

category_menu

id increments
menu_id ^FK integer
category_id ^FK integer

categories

id increments
name string (255)

order_product

id increments
product_id ^FK integer
order_id ^FK integer
quantity integer

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