nejekom - Laravel Schema Designer

vendor

id increments
timestamps timestamps
softDeletes softDeletes
user_id integer
name_en string
name_ar string
phone string
email string
website string
longitude double
latitude double
description_en text
description_ar text
commission_rate double

user

id increments
timestamps timestamps
softDeletes softDeletes

notification

id increments
timestamps timestamps
softDeletes softDeletes
user_id integer
title_en string
title_ar string
message_en string
message_ar string
type string (100)
is_read boolean

patient

id increments
timestamps timestamps
softDeletes softDeletes
user_id integer
nationality_id integer
first_name string
last_name string
phone string
iqama_number string
relationship_id integer
dob date
age bigInteger
gender string
insurance_id integer

address

id increments
timestamps timestamps
softDeletes softDeletes
user_id string
name string
city text
address text
longitude double
latitude double
phone_number string
is_primary boolean

order

id increments
timestamps timestamps
softDeletes softDeletes
user_id integer
vendor_id integer
service_id integer
doctor_id integer
date date
slot_id bigInteger
address text
status string (100)
total double
quantity integer
price double
tax double
payment_method string
coupon_id integer
discount double

service

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

payment

id increments
timestamps timestamps
softDeletes softDeletes
user_id integer
order_id integer
transaction_id string
amount double
status string

review

id increments
timestamps timestamps
softDeletes softDeletes
order_id integer
vendor_id integer
user_id integer
rating integer
review_en text
review_ar text

doctor

id increments
timestamps timestamps
softDeletes softDeletes
name_en string
name_ar string
phone string
vendor_id integer
service_id integer
classification_id integer
biography text
experience smallInteger
license text
home_visit_price double
hospital_price double
status string

classification

id increments
timestamps timestamps
softDeletes softDeletes
name_en string
name_ar string

ticket

id increments
timestamps timestamps
softDeletes softDeletes
title_en string
title_ar string
message_en text
message_ar text
status string (100)
user_id integer

relationship

id increments
timestamps timestamps
softDeletes softDeletes
name_en string
name_ar string

country

id increments
timestamps timestamps
softDeletes softDeletes
name_en string
name_ar string
phone_code string

category

id increments
timestamps timestamps
softDeletes softDeletes
name_en string
name_ar string
status string (100)
description_en text
description_ar text
reservation boolean
order_service boolean
multi boolean
has_description boolean

vendor_service

id increments
timestamps timestamps
softDeletes softDeletes
vendor_id integer
service_id integer
price double
status string

slot

id increments
timestamps timestamps
softDeletes softDeletes
date datetime
hour string
duration integer
reserved boolean
category_id integer
doctor_id integer
service_id integer
vendor_id integer

order_patient

id increments
timestamps timestamps
softDeletes softDeletes
order_id integer
patient_id integer

vendor_category

id increments
timestamps timestamps
softDeletes softDeletes
vendor_id integer
category_id integer
status string

service_category

id increments
timestamps timestamps
softDeletes softDeletes
category_id integer
service_id integer

coupon

id increments
timestamps timestamps
code string (100)
value integer
type enum
expire date
max_use integer
usage integer

insurance

id increments
timestamps timestamps
company_en string
company_ar string

record

id increments
timestamps timestamps
name string
record_type_id integer
patient_id integer

record_type

id increments
timestamps timestamps
name_en string
name_ar string

lifestyle_question

id increments
timestamps timestamps
title_en string
title_ar string

lifestyle_answer

id increments
timestamps timestamps
answer_en text
answer_ar text

lifestyle

id increments
timestamps timestamps
patient_id integer
lifestyle_question_id integer
lifestyle_answer_id integer

medical_question

id increments
timestamps timestamps
title_en string
title_ar string
question_en text
question_ar text
suggestions_en text
suggestions_ar text

medical

id increments
timestamps timestamps
patient_id integer
medical_question_id integer
answer enum
answers text

medical_suggestion

id increments
timestamps timestamps
suggestion_en string (300)
suggestion_ar string (300)
medical_question_id integer

message

id increments
timestamps timestamps
order_id integer
user_id integer
staff_id integer
last_message text

schedule

id increments
timestamps timestamps
vendor_id integer
service_id integer
time_from datetime
time_to datetime
duration integer

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