Dar Afia - Laravel Schema Designer

user

id increments
timestamps timestamps
softDeletes softDeletes

client_old

id increments
timestamps timestamps
softDeletes softDeletes
name string
last_name string
mobile string
email string
iq string
nationality_id string (120)
gender enum
passport string
password string
user_id integer

category

id increments
timestamps timestamps
softDeletes softDeletes
name_en string
name_ar string
description_en text
description_ar text

service

id increments
timestamps timestamps
softDeletes softDeletes
name_en string
name_ar string
description_en text
description_ar text
price double
category_id integer
booking boolean
require_address boolean
require_reason boolean

order

id increments
timestamps timestamps
softDeletes softDeletes
service_id integer
branch_id integer
location_id integer
member_no integer
status enum
total double
price double
tax double
note text
client_id integer
user_id integer
address_id integer
reason_id integer

order_client

id increments
timestamps timestamps
softDeletes softDeletes
order_id integer
service_id integer
client_id integer
tax double
total double
note text

country

id increments
timestamps timestamps
softDeletes softDeletes
country_code string
country_name string
country_id string

branch

id increments
timestamps timestamps
softDeletes softDeletes
name_en string
name_ar string
address_en string
address_ar string

category_branch

id increments
timestamps timestamps
softDeletes softDeletes
branch_id integer
category_id integer

service_branch

id increments
timestamps timestamps
softDeletes softDeletes
branch_id integer
service_id integer

location

id increments
timestamps timestamps
softDeletes softDeletes
name_en string
name_ar string
time_en string
time_ar string

center

id increments
timestamps timestamps
softDeletes softDeletes
name_en string
name_ar string
mobile string
branch_id integer

page

id increments
timestamps timestamps
softDeletes softDeletes
name_en string
name_ar string
description_en text
description_ar text
center_id integer

degree

id increments
timestamps timestamps
softDeletes softDeletes
name_en string
name_ar string

specialty

id increments
timestamps timestamps
softDeletes softDeletes
name_en string
name_ar string

doctor

id increments
timestamps timestamps
softDeletes softDeletes
name_en string
name_ar string
gender enum
birthdate date
nationality_id integer
specialty_id integer
degree_id integer
certifications text
experiences text
positions text
years string
certifications_ar text
experiences_ar text
positions_ar text

doctor_branch

id increments
timestamps timestamps
softDeletes softDeletes
doctor_id integer
branch_id string

service_location

id increments
timestamps timestamps
softDeletes softDeletes
location_id integer
service_id integer

state

id increments
timestamps timestamps
softDeletes softDeletes
state_name string
state_id string
country_id string

city

id increments
timestamps timestamps
softDeletes softDeletes
city_id string
state_id string
city_name string

salutation

id increments
timestamps timestamps
softDeletes softDeletes
salutation string
gender enum
salutation_id string

client

id increments
timestamps timestamps
softDeletes softDeletes
patient_name string
middle_name string
middle_name2 string
last_name string
salutation string
patient_gender enum
dateofbirth date
patient_phone string
patient_category_id integer
patieatient_state string
patient_city string
patient_address text
country string
nationality_id string
government_identifier string
user_id integer
identifier_id integer
custom_field5 string
custom_list7_value string
custom_list5_value string
patient_group string
agein string
preferred_language string
patient_area string
file_number string

address

id increments
timestamps timestamps
softDeletes softDeletes
user_id integer
address_en string
address_ar string

reason

id increments
timestamps timestamps
softDeletes softDeletes
name_en text
name_ar text

archived_service

id increments
timestamps timestamps
softDeletes softDeletes
name_en string
name_ar string
description_en text
description_ar text
category_id integer

archived_category

id increments
timestamps timestamps
softDeletes softDeletes
name_en string
name_ar string
description_en text
description_ar text

archived_category_branch

id increments
timestamps timestamps
softDeletes softDeletes
branch_id integer
category_id integer

archived_service_branch

id increments
timestamps timestamps
softDeletes softDeletes
branch_id integer
service_id integer

nationality

id increments
timestamps timestamps
softDeletes softDeletes
name_en string
name_ar string

forget_history

id increments
timestamps timestamps
user_id integer
count integer
code string (30)