Skofi ERD - Laravel Schema Designer

pets

id increments
name string (250)
user_id integer
breed string (100)
date_of_birth date
health_status text
timestamps timestamps

employees

id increments
first_name string (250)
email string
last_name string (250)
gender enum
role string
status enum
branch_id bigInteger
timestamps timestamps

service_discounts

id increments
service_id bigInteger
discount_type enum
discount_percentage decimal (5,2)
total_discount decimal (10,2)
number_of integer
timestamps timestamps

branches

id increments
name string (250)
timestamps timestamps

subtype_services

id increments
name string (250)
service_id bigInteger
feature string (250)
variations string (250)
start_date date
end_date date
price decimal (10,2)
timestamps timestamps

service_addons

id increments
service_id bigInteger
price decimal (10,2)
name string (250)
timestamps timestamps

notifications

id increments
user_id bigInteger
admin_id bigInteger
booking_id bigInteger
subscription_id bigInteger
messages text
notification_type enum
timestamps timestamps

packages

id increments
name string (250)
description text
price decimal (10,2)
status enum
timestamps timestamps

subscriptions

id increments
user_id bigInteger
package_id bigInteger
start_date date
end_date date
total_price decimal (10,2)
branch_id bigInteger
payment_status enum
status enum
timestamps timestamps

users

id increments
first_name string (255)
last_name string (250)
email string (50)
timestamps timestamps
tenant_id bigInteger
type enum

services

id increments
name string (250)
description text
start_date date
end_date date
status enum
branch_id integer
display_in_app boolean
timestamps timestamps

bookings

id increments
user_id bigInteger
pet_id bigInteger
service_id bigInteger
date date
time time
pickup_time time
dropoff_time time
price decimal (10,2)
subtype_id bigInteger
status enum
branch_id bigInteger
booking_id bigInteger
timestamps timestamps
has_transportation boolean
employee_id bigInteger
dropoff_location string
pickup_location string

package_services

id increments
timestamps timestamps
package_id bigInteger
service_id bigInteger

payments

id increments
timestamps timestamps
user_id bigInteger
amount string
method enum
status enum
subscription_id bigInteger

addresses

id increments
addressable_id bigInteger
addressable_type string
address text
city string
state string
country string
latitude decimal (10,8)
longitude decimal (11,8)
timestamps timestamps

phones

id increments
phoneable_id bigInteger
phoneable_type string
country_code string (10)
number string (20)
timestamps timestamps

pet_types

id increments
timestamps timestamps
name string
status enum
created_by bigInteger

breeds

id increments
name string
pettype_id bigInteger
description text
status enum
timestamps timestamps

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