Mn-Hena-Database - Laravel Schema Designer

users

id increments
timestamps timestamps
softDeletes softDeletes
name_en string
name_ar string
email string
password string
phone_number string
role_id ^FK integer

sliders

id increments
timestamps timestamps
softDeletes softDeletes
slug string
title_en string
title_ar string
meta_title_en string
meta_title_ar string
description_en text
description_ar text
meta_descriotion_en text
meta_descriotion_ar text
items json
order integer

projects

id increments
timestamps timestamps
softDeletes softDeletes
slug string
project_number integer
title_en string
title_ar string
description_en longText
description_ar longText
delivery_date date
finishing_status_id ^FK integer
developer_id ^FK integer
area_from integer
area_to integer
price_from integer
price_to integer
down_payment_from integer
down_payment_to string
number_of_installments_from integer
number_of_installments_to integer
country_id ^FK integer
region_id ^FK integer
fininshing_date date
city_id ^FK integer
seo_index boolean
longitude string
latitude string
is_featured boolean
currency_id ^FK integer
number_blocks integer
moderation_status enum

units

id increments
timestamps timestamps
softDeletes softDeletes
slug string
title_en string
title_ar string
meta_title_en string
meta_title_ar string
description_en longText
description_ar longText
meta_descriotion_en text
meta_descriotion_ar text
price integer
down_payment string
number_of_installments integer
area integer
garden_area integer
plot_area integer
terrace_area integer
roof_area integer
project_id ^FK integer
building_number_id ^FK integer
position_id ^FK integer
view_id ^FK integer
bedroom_number_id ^FK integer
bathroom_number_id ^FK integer
floor_number_id ^FK integer
purpose_id ^FK integer
purpose_type_id ^FK integer
offering_type_id ^FK integer
area_unit_id ^FK integer
unit_type_id ^FK integer
furnishing_status_id ^FK integer
fininshing_status_id ^FK integer
design_type_id ^FK integer
payment_method_id ^FK integer
views_count string
is_featured boolean
is_active boolean
country_id ^FK integer
region_id ^FK integer
city_id ^FK integer
seo_index boolean
latitude string
longitude string
buyer_id ^FK integer
currency_id ^FK integer
moderation_status enum

lookups

id increments
timestamps timestamps
softDeletes softDeletes
parent_id ^FK integer
name_en string
name_ar string
slug string
description_en text
description_ar text
is_active boolean
is_editable boolean

locations

id increments
timestamps timestamps
softDeletes softDeletes
parent_id ^FK integer
name_en string
name_ar string
slug string
is_active boolean
order integer
code string

blogs

id increments
timestamps timestamps
softDeletes softDeletes
title_en string
title_ar string
meta_title_en string
meta_title_ar string
description_en longText
description_ar longText
meta_descriotion_en text
meta_descriotion_ar text
is_featured boolean
is_published boolean
views integer
type enum

contact_us

id increments
timestamps timestamps
softDeletes softDeletes
full_name string
email string
phone_number string
message longText
is_readed boolean
link mediumText
best_time_to_call_from date
best_time_to_call_to date

careers

id increments
timestamps timestamps
softDeletes softDeletes
title_en string
title_ar string
meta_title_en string
meta_title_ar string
description_en text
description_ar text
meta_descriotion_en text
meta_descriotion_ar text
type enum
salary_range json
number_of_available_vacancies integer
is_active boolean
show_salary boolean
seo_index boolean

events

id increments
timestamps timestamps
softDeletes softDeletes
title_en string
title_ar string
meta_title_en string
meta_title_ar string
description_en longText
description_ar longText
meta_descriotion_en text
meta_descriotion_ar text
is_featured boolean
start_date datetime
end_date datetime
seo_index boolean

packages

id increments
timestamps timestamps
softDeletes softDeletes
name_en string
name_ar string
description_en text
description_ar text
is_active boolean
price integer
discount integer
final_price integer
duration integer
ad_limit_per_month integer
is_recommanded boolean
order tinyInteger
currency_id ^FK integer

subscriptions

id increments
timestamps timestamps
softDeletes softDeletes
user_id ^FK integer
package_id ^FK integer
status enum
start_date datetime
end_date datetime
amount integer
number_of_months integer

developers

id increments
timestamps timestamps
softDeletes softDeletes
title_en string
title_ar string
meta_title_en string
meta_title_ar string
description_en text
description_ar text
meta_descriotion_en text
meta_descriotion_ar text
country_id ^FK integer
city_id ^FK integer
region_id ^FK integer
developer_id ^FK integer
seo_index boolean
is_featured boolean

package_items

id increments
timestamps timestamps
softDeletes softDeletes
title_en string
title_ar string
description_en text
description_ar text
package_id ^FK integer

organization

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

services

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

applicants

id increments
timestamps timestamps
softDeletes softDeletes
name string
email string
phone_number string
career_id ^FK integer
status enum
gender enum

testimonials

id increments
timestamps timestamps
softDeletes softDeletes
user_id ^FK integer
feedback text

organization_user

id increments
timestamps timestamps
user_id ^FK integer
organization_id ^FK integer
is_owner boolean

faqs

id increments
timestamps timestamps
softDeletes softDeletes
question string
answer text
faqsable morphs

currencies

id increments
timestamps timestamps
softDeletes softDeletes
priority integer
iso_code string
name_en string
name_ar string
symbol string
subunit string
subunit_to_unit integer
symbol_first tinyInteger
html_entity string
decimal_mark string
thousands_separator string
iso_numeric integer
exchange_rate integer

favorites

id increments
timestamps timestamps
softDeletes softDeletes
favoritable morphs
user_id ^FK integer

notifications

id increments
timestamps timestamps
softDeletes softDeletes
notifiable morphs
data text
read_at datetime

facility_distances

id increments
distance integer
distanciable morphs
lookup_id ^FK integer
timestamps timestamps
softDeletes softDeletes

rejection_reasons

id increments
timestamps timestamps
softDeletes softDeletes
reason text
reasonable morphs

messages

id increments
user_id ^FK integer
message text
subject string
timestamps timestamps
softDeletes softDeletes

comments

id increments
timestamps timestamps
softDeletes softDeletes
commentable morphs
content longText
parent_id ^FK integer
user_id ^FK integer

social_posts

id increments
timestamps timestamps
softDeletes softDeletes
user_id ^FK integer
body longText
like_count integer

likes

id increments
timestamps timestamps
softDeletes softDeletes
user_id ^FK integer
likeable morphs