dear_day - Laravel Schema Designer

countries

id increments
name string (255)
key string (50)
image string (255)
softDeletes softDeletes
timestamps timestamps

regions

id increments
name string (255)
country_id ^FK integer
timestamps timestamps

cities

id increments
name string (255)
region_id ^FK integer
timestamps timestamps

addresses

id increments
country_id ^FK integer
region_id ^FK integer
city_id ^FK integer
timestamps timestamps

users

id increments
name string (255)
parent_name string (255)
sub_clan string (255)
gender string (255)
avater string (255)
generation_id ^FK integer
hijri_birth_date string (255)
date_birth string (255)
institutions_id ^FK integer
nick_name string (255)
timestamps timestamps

generations

id increments
name string (255)
start_year string (255)
end_year string (255)
color string (255)
timestamps timestamps

educational_institutions

id increments
name string (255)
level enum
is_official boolean
status enum
timestamps timestamps

specializations

id increments
name string (255)
institutions_id ^FK integer
another string (255)
status string (255)
timestamps timestamps

user_institutions

id increments
user_id ^FK integer
institutions_id ^FK integer
another string (255)
start_year string (255)
end_year string (255)
start_hijri_year string (255)
end_hijri_year string (255)
institutions_type string (255)
timestamps timestamps

jobs

id increments
job_name string (255)
specializations string (255)
timestamps timestamps
is_official boolean
status enum
added_by ^FK integer

users_job

id increments
job_id ^FK integer
another string (255)
start_year string (255)
status string (255)
start_year_type enum
employer_id ^FK integer
user_id ^FK integer
timestamps timestamps

user_courses

id increments
name string (255)
timestamps timestamps

Interests

id increments
name string (255)
is_official boolean
status enum
added_by ^FK integer
timestamps timestamps

user_interests

id increments
Interest_id ^FK integer
status string (255)
another string (255)
timestamps timestamps

memories

id increments
user_id ^FK integer
privacy enum
city_id ^FK integer
type enum
latitude string
longitude string
timestamps timestamps

memory_before_after

id increments
before_image string (255)
before_image_year string (255)
after_image string (255)
after_image_year string (255)
description longText
timestamps timestamps

memory_tags

id increments
user_id ^FK integer
memory_id ^FK integer
timestamps timestamps

memorial_persons

id increments
memory_id ^FK integer
full_name string (255)
birth_date string
birth_calendar enum
death_date string (255)
death_calendar enum
living_city_id ^FK integer
death_city_id ^FK integer
job_id ^FK integer
institutions_id ^FK integer
description longText
timestamps timestamps

memory_videos

id increments
memory_id ^FK integer
video_path string
Date_capture string
description longText
timestamps timestamps

memory_likes

id increments
user_id ^FK integer
likeable morphs
timestamps timestamps

comments

id increments
user_id ^FK integer
commentable morphs
comment longText
timestamps timestamps

pending_reference_values

id increments
reference_type string (255)
value string (255)
memory_id ^FK integer
user_id ^FK integer
status enum
admin_note longText
timestamps timestamps

friendships

id increments
user_id ^FK integer
friend_id ^FK integer
status enum
timestamps timestamps

user_photos

id increments
user_id ^FK integer
image_path string (255)
description longText
taken_at string (255)
calendar enum
city_id ^FK integer
timestamps timestamps

user_privacies

id increments
user_id ^FK integer
key string
privacy enum
timestamps timestamps

employers

id increments
name string (255)
is_official boolean
status enum
added_by ^FK integer
timestamps timestamps