omnya_care - Laravel Schema Designer

patients

id increments
first_name string
last_name string
email string
password string
dob date
image string
pob_city string
pob_province string
tax_code string
mobile_number string
google_auth_id string
google_auth_token string
facebook_auth_id string
facebook_auth_token string
referal_code string
referred_by_id bigInteger
points_to_referrer integer
invoice_name string
invoice_surname string
invoice_email string
invoice_vat string
timestamps timestamps
softDeletes softDeletes

medical_profiles

id increments
patient_id ^FK bigInteger
blood_type string
weight double
height integer
gender enum
currently_pregnant boolean
has_previous_pathologies boolean
previous_pathologies text
has_current_pathologies boolean
current_pathologies text
has_previous_therapies boolean
previopus_therapies text
has_current_therapies boolean
current_therapies text
has_previous_surgeries boolean
previous_surgeries text
has_allergies boolean
allergies text
notes longText
timestamps timestamps
softDeletes softDeletes

medical_files

id increments
patient_id ^FK bigInteger
parent_id bigInteger
type enum
name string
size bigInteger
mime_type string
creator_id bigInteger
timestamps timestamps
path string
creator_type string
softDeletes softDeletes

medical_file_shares

id increments
medical_file_id bigInteger
recipient_id bigInteger
recipient_type string
shared_for_days integer
sender_id bigInteger
sender_type string
timestamps timestamps
softDeletes softDeletes

suppliers

id increments
type enum
subscription_cost integer
booking_fee_percentage integer
uploads_cap integer
first_name string
last_name string
image string
specialisation string
company_name string
timestamps timestamps
softDeletes softDeletes

users

id increments
supplier_id bigInteger
name string (255)
email string (255)
password string (255)
image string (255)
active integer
timestamps timestamps
type enum

sites

id increments
supplier_id bigInteger
city string
zip string
street_name string
street_number string
description text
is_primary boolean
timestamps timestamps
softDeletes softDeletes

site_user

id increments
site_id bigInteger
user_id bigInteger
timestamps timestamps

schedules

id increments
site_id bigInteger
monday_from_am time
monday_to_am time
monday_from_pm time
monday_to_pm time
tuesday_from_am time
tuesday_to_am time
tuesday_from_pm time
tuesday_to_pm time
wednesday_from_am time
wednesday_to_am time
wednesday_from_pm time
wednesday_to_pm time
thursday_from_am time
thursday_to_am time
thursday_from_pm string
thursday_to_pm time
friday_from_am time
friday_to_am time
friday_from_pm time
friday_to_pm time
saturday_from_am time
saturday_to_am time
saturday_from_pm time
saturday_to_pm time
sunday_from_am time
sunday_to_am time
sunday_from_pm time
sunday_to_pm time
timestamps timestamps
softDeletes softDeletes

unavailable_slots

id increments
timestamps timestamps
softDeletes softDeletes
site_id bigInteger
from datetime
to datetime

services

id increments
name string
type enum
duration_in_minutes integer
active boolean
softDeletes softDeletes
timestamps timestamps

service_site

id increments
cost integer
description text
payable_in_cash boolean
service_id bigInteger
site_id bigInteger
timestamps timestamps

appointments

id increments
patient_id integer
supplier_id integer
service_site_id bigInteger
status string
cost integer
has_shared_files boolean
video_call_link string
video_call_short_link string
patient_address string
medical_file_id integer
scheduled_at datetime
softDeletes softDeletes
timestamps timestamps

contact_requests

id increments
name string
email string
phone string
subject string
message text
softDeletes softDeletes
timestamps timestamps

collaboration_requests

id increments
type enum
name string
city string
email string
phone string
specialisation string
message text
timestamps timestamps
softDeletes softDeletes

patient_reminders

id increments
patient_id bigInteger
supplier_id bigInteger
appointment_id integer
message text
completed boolean
date date
every_days integer
last_notified_at date
timestamps timestamps
softDeletes softDeletes

medical_file_sharing_requests

id increments
fullfilled boolean
patient_id bigInteger
appointment_id bigInteger
supplier_id bigInteger
timestamps timestamps
softDeletes softDeletes

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