test - Laravel Schema Designer

users

id increments
name string (255)
email string
password string (8)
role string
timestamps timestamps

services

id increments
name string
description string
timestamps timestamps
softDeletes softDeletes

orders

id increments
user_id ^FK integer
name string
status enum
total_price string
timestamps timestamps

payments

id increments
amount decimal
status enum
user_id ^FK integer
order_id ^FK integer
softDeletes softDeletes
timestamps timestamps

settings

id increments
slug string
data json
timestamps timestamps

reports

id increments
user_id ^FK integer
timestamps timestamps

subscriptions

id increments
user_id ^FK integer
service_id ^FK integer
start_date date
end_date date
softDeletes softDeletes
timestamps timestamps
package_id ^FK integer
plan_id ^FK integer
vet_amount double

packages

id increments
service_id ^FK integer
name string
softDeletes softDeletes
timestamps timestamps
description string

prices

id increments
package_id ^FK integer
feature_id ^FK integer
plan_id ^FK integer
fixed_price double
timestamps timestamps
softDeletes softDeletes

features

id increments
package_id ^FK integer
description json
softDeletes softDeletes
timestamps timestamps

order_items

id increments
order_id ^FK integer
service_id ^FK integer
package_id ^FK integer
feature_id ^FK integer
item_price double
quantity integer
total_price double
timestamps timestamps

plans

id increments
type enum
price double
timestamps timestamps

invoices

id increments
invoice_number string
order_id ^FK integer
payment_id ^FK integer
total_amount decimal
payment_status string
timestamps timestamps

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