eswing - Laravel Schema Designer

students

id increments
name string
lastname string
email string
password string
gender enum
profile_img_path string
country_id ^FK bigInteger
city_id ^FK bigInteger
description text
timestamps timestamps
softDeletes softDeletes

countries

id increments
code string (2)
name string
nationality string
continent_code string (2)
timestamps timestamps

cities

id increments
timestamps timestamps
name string
country_id ^FK bigInteger

languages

id increments
code string (2)
name string
timestamps timestamps

languageable

id increments
languageable_id bigInteger
languageable_type string
language_id ^FK bigInteger
timestamps timestamps
softDeletes softDeletes

specializables

id increments
self_evaluation smallInteger
specialty_id ^FK bigInteger
specializables_id bigInteger
specializables_type string
timestamps timestamps
softDeletes softDeletes

specialties

id increments
name string
timestamps timestamps
softDeletes softDeletes

golf_attributes

id increments
timestamps timestamps
preferred_grip enum
height enum
index smallInteger
game_level_index smallInteger
handicap enum
model_id bigInteger
model_type string
softDeletes softDeletes

coaches

id increments
gender enum
country_id ^FK bigInteger
city_id ^FK bigInteger
profile_img_path string
auto_accept boolean
description text
name string
lastname string
password string
email string
timestamps timestamps
softDeletes softDeletes
total_revenue bigIncrements
total_analysis bigIncrements

coach_student

id increments
timestamps timestamps
softDeletes softDeletes
student_id ^FK bigInteger
coach_id ^FK bigInteger

offers

id increments
type enum
price integer
duration integer
coach_id ^FK bigInteger
description text
timestamps timestamps
softDeletes softDeletes

slots

id increments
start_date datetime
end_date datetime
coach_id ^FK bigInteger
agenda_id ^FK bigInteger
participants smallInteger
recurence_id bigInteger
timestamps timestamps
softDeletes softDeletes

slot_offer

id increments
slot_id bigInteger
offer_id bigInteger
timestamps timestamps
softDeletes softDeletes

addresses

id increments
address string
latitude decimal (11,8)
longitude decimal (11,8)
model_type string
model_id bigInteger
timestamps timestamps
softDeletes softDeletes

agendas

id increments
coach_id ^FK bigInteger
timestamps timestamps
softDeletes softDeletes

reservations

id increments
student_id ^FK bigInteger
coach_id ^FK bigInteger
slot_id bigInteger
has_digital_analysis boolean
status enum
feedback mediumText
stripe_payment_intent_id string
timestamps timestamps
softDeletes softDeletes
amount decimal
currency string

conversations

id increments
reservation_id bigInteger
is_active boolean
timestamps timestamps
softDeletes softDeletes

messages

id increments
conversation_id string
sender_id bigInteger
reciviver_id bigInteger
sender_type string
recivier_type string
unread boolean
timestamps timestamps
softDeletes softDeletes

participants

id increments
email string
reservation_id bigInteger
student_id ^FK bigInteger
timestamps timestamps
softDeletes softDeletes

media

id increments
model_type string
model_id integer
timestamps timestamps
softDeletes softDeletes

promo_codes

id increments
code string
coach_id ^FK bigInteger
timestamps timestamps
softDeletes softDeletes

notification_settings

id increments
model_type string
model_id bigInteger
timestamps timestamps
softDeletes softDeletes
request_accepted_notifications boolean
messages_notifications boolean
new_evaluation_notifications boolean
request_accepted_emails boolean
messages_emails boolean
new_evaluation_emails boolean

golf_clubs

id increments
timestamps timestamps
softDeletes softDeletes

recurrences

id increments
start_date date
recurrence_interval enum
timestamps timestamps
softDeletes softDeletes

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