plumpclinics - Laravel Schema Designer

settings

id bigIncrements
title string (255)
address string (255)
description text
timestamps timestamps

social_links

id bigIncrements
name string (255)
url string (255)
is_active tinyInteger
timestamps timestamps

specialties

id bigIncrements
name string (255)
description text
image string (255)
is_active tinyInteger
display_order integer
timestamps timestamps

service_procedures

id bigIncrements
service_id ^FK bigInteger
name string (255)
description text
price decimal (10,2)
image string (255)
is_active tinyInteger
duration_minutes integer
timestamps timestamps

services

id bigIncrements
name string (255)
description text
image string (255)
icon string (255)
display_order integer
is_active tinyInteger
timestamps timestamps

doctors

id bigIncrements
name string (255)
phone string (255)
image string (255)
position string (255)
is_active tinyInteger
specialty_id ^FK bigInteger
timestamps timestamps

specialty_doctor

id bigIncrements
specialty_id ^FK bigInteger
doctor_id ^FK bigInteger
timestamps timestamps

contacts

id bigIncrements
name string (255)
value string (255)
is_active tinyInteger
schedule longText
timestamps timestamps

features

id increments
name string (255)
description text
is_active tinyInteger
timestamps timestamps

team_members

id increments
name string (255)
position string (255)
specialization string (255)
phone string (255)
image string (255)
is_active tinyInteger
display_order integer
timestamps timestamps

team_services

id increments
name string (255)
description string
timestamps timestamps

pages

id bigIncrements
name string (255)
title string (255)
dscription text
image string (255)
timestamps timestamps

page_sections

id bigIncrements
title string (255)
subtitle string (255)
description longText
is_active tinyInteger
display_order integer
image string (255)
page_id ^FK bigInteger
timestamps timestamps

bookings

id increments
client_name string (255)
client_phone string (255)
client_email string (255)
notes string (255)
status string (255)
doctor_id ^FK bigInteger
specialty_id ^FK bigInteger
procedure_id ^FK bigInteger
timestamps timestamps
preferred_date date
preferred_time time

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