Dr-Banhawy - Laravel Schema Designer

users

id increments
name string
user_type_id ^FK integer
phone string
password string
email string
phone_verified tinyInteger
status tinyInteger
api_token string
device_token string
device_type string
state_id ^FK integer
city_id ^FK integer
timestamps timestamps

user_types

id increments

user_type_translations

id increments
user_type_id ^FK integer
title string
locale string

doctors

id increments
gender tinyInteger
birthday date
profile string
biography string

patients

id increments
code string
address string
gender tinyInteger
birthday date

assistant

id increments

assistant_doctors

id increments
assistant_id ^FK integer
doctor_id ^FK integer

specializations

id increments
status tinyInteger

specialization_translations

id increments
specialization_id ^FK integer
title string
locale string

states

id increments
status tinyInteger

state_translations

id increments
state_id ^FK integer
title string
locale string

cities

id increments
status tinyInteger

city_translations

id increments
city_id ^FK integer
title string
locale string

doctor_specializtions

id increments
doctor_id ^FK integer
specialization_id ^FK integer

operation_names

id increments
status tinyInteger

operation_name_translations

id increments
operation_name_id ^FK integer
title string
locale string

test

id increments
timestamps timestamps

operations

id increments
doctor_id ^FK integer
patient_id ^FK integer
operation_name_id ^FK integer
workspace_id ^FK integer
daily_instructions tinyInteger
medical_prescription tinyInteger
notes text
timestamps timestamps

drugs

id increments
video text
status tinyInteger

drug_translations

id increments
drug_id ^FK integer
name string
locale string

drug_strengths

id increments
number string
status tinyInteger

drug_strength_translations

id increments
drug_strength_id ^FK integer
text string
locale string

drug_types

id increments
status tinyInteger

drug_type_translations

id increments
drug_type_id ^FK integer
title string
locale string

drug_repeats

id increments
status tinyInteger

drug_repeat_translations

id increments
drug_repeat_id ^FK integer
title string
locale string

operation_drugs

id increments
operation_id ^FK integer
drug_id ^FK integer
drug_strength_id ^FK integer
drug_type_id ^FK integer
drug_repeat_id ^FK integer
dose string
condition tinyInteger
start_date date
end_date date

chats

id increments
from_user_id ^FK integer
to_user_id ^FK integer
message text
timestamps timestamps

workspaces

id increments
status tinyInteger

workspace_translations

id increments
workspace_id ^FK integer
title string
locale string

notifications

id increments
user_id ^FK integer
text text
image string
timestamps timestamps

questions

id increments
status tinyInteger

question_translations

id increments
question_id ^FK integer
question string
answer string
locale string

sliders

id increments
image string
status tinyInteger

slider_translations

id increments
slider_id ^FK integer
title string
text string
locale string

settings

id increments
name string

setting_translations

id increments
setting_id ^FK integer
value longText
locale string