packages - Laravel Schema Designer

packages

id increments
state_id ^FK integer
package_type_id ^FK integer
duration integer
slug string
name string
is_active boolean
is_school_only boolean
timestamps timestamps

package_types

id increments
name string

products

id increments
product_type_id ^FK integer
state_id ^FK integer
slug string
name string
description text
is_optional boolean
price float
renewal_price float
meta json
min_hours float
timestamps timestamps

product_types

id increments
name string

states

id increments
name string
abbrev string

purchases

id increments
user_id ^FK integer
package_id ^FK integer
total float
coupon_id integer
notes text
webhook_data json
expires_on timestamp
timestamps timestamps

users

id increments
school_id ^FK integer
state_id ^FK integer
notes text
is_active boolean
first_name string
last_name string
email string
password string
last_login_at timestamp
timestamps timestamps
softDeletes softDeletes

coupons

id increments
timestamps timestamps

schools

id increments
key string
subdomain string
user_id ^FK integer
is_active boolean
name string
notes text
style_meta json
timestamps timestamps

notes

id increments
user_id ^FK integer
notable_id integer
notable_type string
notes text
timestamps timestamps

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