discovering_therapy - Laravel Schema Designer

roles

id increments
timestamps timestamps
name string (255)

users

id increments
dt_id string (100)
name string (255)
email string (255)
password string (255)
role_id ^FK integer
telephone string (255)
address string (255)
city string (255)
country string (255)
postal_code string
website string (255)
birth_date date
active boolean
email_verified_at string
timestamps timestamps
softDeletes softDeletes
location_type_id ^FK integer
wallet_amount decimal (8,2)

users_meta

id increments
timestamps timestamps
user_id integer
key string (500)
value text

profile_image_approvals

id increments
timestamps timestamps
user_id ^FK integer
status enum
image_url text

plans

id increments
timestamps timestamps
softDeletes softDeletes
price_monthly decimal (8,2)
price_yearly decimal (8,2)

features

id increments
timestamps timestamps
softDeletes softDeletes
name text

plans_features

id increments
timestamps timestamps
plan_id ^FK integer
feature_id ^FK integer

users_plans

id increments
timestamps timestamps
user_id ^FK integer
plan_id ^FK integer
expires_on datetimeTz
plan_type enum

reviews

id increments
timestamps timestamps
softDeletes softDeletes
patient_id ^FK integer
therapist_id ^FK integer
text text
rate_count smallInteger

therapy_categories

id increments
name string (255)
slug string (255)
timestamps timestamps
softDeletes softDeletes
created_by ^FK integer
active boolean

therapy_types

id increments
name string (255)
slug string (255)
timestamps timestamps
softDeletes softDeletes
created_by integer
active boolean

therapy_languages

id increments
name string (255)
slug string (255)
timestamps timestamps
softDeletes softDeletes
created_by integer
active boolean

location_types

id increments
name string (255)
timestamps timestamps
softDeletes softDeletes

users_locations

id increments
timestamps timestamps
softDeletes softDeletes
official_name string (255)
customized_name string (255)
address string (500)
city string (255)
country string (255)
postal_code string (255)
website string (255)
phone string (255)
user_id ^FK integer
price_per_session decimal (8,2)

currencies

id increments
timestamps timestamps
softDeletes softDeletes
name string (255)
symbol string

users_session_type_prices

id increments
timestamps timestamps
session_type_id ^FK integer
user_id ^FK integer
amount decimal (8,2)

therapist_packages

id increments
timestamps timestamps
softDeletes softDeletes
name string (255)
therapy_type_id ^FK integer
number_of_sessions integer
price decimal (8,2)
therapist_id ^FK integer

sessions

id increments
timestamps timestamps
softDeletes softDeletes
therapist_id ^FK integer
patient_id ^FK integer
starts_at datetimeTz
ends_at datetimeTz
status enum
length integer
location_id ^FK integer

bank_accounts

id increments
timestamps timestamps
softDeletes softDeletes
beneficiary_name string (255)
iban string (255)
bank_account_number string (500)
swift_code string (255)
user_id ^FK integer

session_refunds

id increments
timestamps timestamps
session_id ^FK integer
amount decimal (8,2)

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