test - Laravel Schema Designer

patient

id increments
doctor_id ^FK integer
name string (250)
email string (250)
password string (250)
last_name string (250)
age integer
city string (250)
phone_number integer
fb_login boolean
gender string (250)
photo string (250)
last_login_at datetime
last_login_ip_address string (250)
doctor_last_edit datetime
timestamps timestamps

user_family

id increments
patient_id ^FK integer
sub_disease_id ^FK integer
family_relationship_id ^FK integer
condition string (250)
name string (250)
age integer
timestamps timestamps

family_relationships

id increments
relationship_name_en string (250)
relationship_name_ar string (250)
timestamps timestamps

user_allegries

id increments
allegries_id ^FK integer
patient_id ^FK integer
doctor_id ^FK integer
still_has boolean
status integer
other_allegries string (250)
timestamps timestamps

allegries

id increments
creator_id ^FK integer
name_en string (250)
name_ar string (250)
timestamps timestamps

specialities

id increments
creator_id ^FK integer
name_en string (250)
name_ar string (250)
consultation_minuts integer
timestamps timestamps

sub_disease

id increments
speciality_id ^FK integer
creator_id ^FK integer
name_en string (250)
name_ar string (250)
timestamps timestamps

user_disease

id increments
patient_id ^FK integer
disease_id ^FK integer
creator_id ^FK integer
still_have boolean
condition string (250)
age_injury integer
treatment string (250)
doctor_id ^FK integer
status integer
other_disease string (250)
timestamps timestamps

patient_medicine

id increments
patient_id ^FK integer
consultation_id ^FK integer
case_id ^FK integer
doctor_id ^FK integer
duration string (250)
frequency string (250)
condition string (250)
comment string (250)
typ string (250)
doctor_comment string (250)
name string (250)
dosage string (250)
timestamps timestamps

doctor_information

id increments
speciality_id ^FK integer
photo string
consultation_fees integer
experience string (250)
bio string (250)
timestamps timestamps

qualifications

id increments
creator_id ^FK integer
name string (250)
timestamps timestamps

doctor_qualifications

id increments
doctor_id ^FK integer
creator_id ^FK integer
qualification_id ^FK integer
timestamps timestamps

patient_feedback

id increments
patient_id ^FK integer
note string (250)
feedback text
timestamps timestamps

uploaded

id increments
sub_disease_id ^FK integer
case_id ^FK integer
patient_id ^FK integer
date datetime
type string (250)
img string (250)
timestamps timestamps

consultation_logs

id increments
doctor_id ^FK integer
patient_id ^FK integer
date datetime
case_id string (250)
duration string (250)
timestamps timestamps

questions

id increments
patient_id ^FK integer
speciality_id ^FK integer
question string (250)
status integer
slug string (250)
timestamps timestamps

answers

id increments
question_id ^FK integer
doctor_id ^FK integer
answer text
status integer
timestamps timestamps

favorite_doctor

id increments
doctor_id ^FK integer
patient_id ^FK integer
timestamps timestamps

prescription

id increments
patient_id ^FK integer
doctor_id ^FK integer
case_id ^FK integer
consultation_id ^FK integer
img string (250)
timestamps timestamps

lab_test_user

id increments
lab_sub_id ^FK integer
doctor_id ^FK integer
patient_id ^FK integer
case_id ^FK integer
frequency string (250)
timestamps timestamps

labs

id increments
creator_id ^FK integer
name string (250)
timestamps timestamps

lab_subcategries

id increments
lab_id ^FK integer
creator_id ^FK integer
name string (250)
timestamps timestamps

doctor_clinic

id increments
doctor_id ^FK integer
creator_id ^FK integer
place_name string (250)
latitude string (250)
longitude string (250)
max_num integer
fees string (250)
timestamps timestamps

consultation_details

id increments
consultation_history_id ^FK integer
doctor_comment string (250)
prescription_id ^FK integer
medicine_id ^FK integer
lab_test_user_id ^FK integer
comment string (250)
diagnosis text
is_completed boolean
timestamps timestamps

clinic_time

id increments
doctor_id ^FK integer
status integer
clinic_id ^FK integer
start_time datetime
end_time datetime
timestamps timestamps

patient_clinic

id increments
case_id string (250)
patient_id ^FK integer
clinic_time_id ^FK integer
fees string (250)
timestamps timestamps

canceled_appointment

id increments
patient_clinic_id ^FK integer
case_id ^FK integer
request string (250)
status integer
timestamps timestamps

case_refrence

id increments
code string (250)
type string (250)
timestamps timestamps

roles

id increments
name string (250)
display_name string (250)
description text
timestamps timestamps

role_user

id integer
user_id ^FK integer
role_id ^FK integer
timestamps timestamps

permissions

id increments
name string (250)
display_name string (250)
description text
timestamps timestamps

permission_role

id increments
permession_id ^FK integer
role_id ^FK integer
timestamps timestamps

vaccination

id increments
creator_id ^FK integer
name_en string (250)
name_ar string (250)
timestamps timestamps

user_vaccination

id increments
vaccination_id ^FK integer
patient_id ^FK integer
doctor_id ^FK integer
other_vaccination string (250)
status integer
still_has boolean
timestamps timestamps

doctor

id increments
name string (250)
email string (250)
password string (250)
age integer
city string (250)
phone_number integer
gender string (250)
photo string (250)
consultation_minuts integer
timestamps timestamps

admin

id increments
name string (250)
email string (250)
password string (250)
photo string (250)
timestamps timestamps

doctor_feedback

id increments
doctor_id ^FK integer
feedback text
note string (250)
timestamps timestamps

promo_codes

id increments
code string (250)
precentag string (250)
from datetime
to datetime
no_uses integer
timestamps timestamps

user_promo

id increments
promo_id ^FK integer
patient_id ^FK integer
timestamps timestamps

setting

id increments
logo text
description_en text
keywords_ar string (250)
keywords_en string (250)
description_ar text
site_name_en string (250)
site_name_ar string (250)
facebook string (250)
twitter string (250)
youtube string (250)
address_en string (250)
address_ar string (250)
copy_right string (250)
mobile string (250)
timestamps timestamps

doctor_fees

id increments
speciality_id ^FK integer
doctor_id ^FK integer
from time
to time
percentage integer
timestamps timestamps