db_catering - Laravel Schema Designer

users_table

id bigIncrements
first_name string (64)
last_name string (64)
user_name string (128)
contact string (64)
email string (64)
password string (64)
address string (128)
role string (32)
balance integer
status string (32)
softDeletes softDeletes
timestamps timestamps

items_table

id bigIncrements
category_id ^FK integer
name string (64)
price integer
image string (64)
softDeletes softDeletes
timestamps timestamps

categories_table

id bigIncrements
timestamps timestamps
name string (32)
description string (32)
slug string (64)
softDeletes softDeletes

packages

id increments
item_id ^FK integer
price string (32)
promo_price string (32)
name string (32)
timestamps timestamps
softDeletes softDeletes

orders

id increments
user_id float
vat integer
total string (32)
quantity integer
charge string
to_date datetime
from_date datetime
timestamps timestamps
softDeletes softDeletes

order_details_table

id increments
order_id ^FK integer
price float
due float
package_id ^FK integer
timestamps timestamps
softDeletes softDeletes
subtotal integer

payments_table

id bigIncrements
order_id ^FK integer
type string
status string
amount string
timestamps timestamps
softDeletes softDeletes

package_details_table

id increments
package_id ^FK integer
item_id ^FK integer
quantity integer
remarks string (32)
timestamps timestamps
softDeletes softDeletes

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