Home
Skofi ERD
Fork
Export all
Schema
Model
Controller
Seeding
Form
Laravel 4.2
Add to favorites
Comments (0)
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
×
Comments for Skofi ERD
No comments have been made yet.
Laravel Schema Designer v0.7.1
follow me on twitter
@okyn01