wasata - Laravel Schema Designer

users

id increments
timestamps timestamps
fullname string (191)
username string (191)
password string (191)
type enum
city_id ^FK integer
gender enum
address text
mobile string (191)
email string (191)
status enum
mobile_approved enum
vip enum
website_link string (191)
birthday date
nationality_id ^FK integer
disability_id ^FK integer
current_subscription_id ^FK integer

workers

id increments
timestamps timestamps
user_id ^FK integer
hired enum
social_affairs enum
social_warranty enum
height string (191)
weight string (191)
first_language string
firs_language_skill enum
second_language string (191)
second_language_skill enum
licence enum
licence_type string (191)
social_status enum
children integer
works_before enum
last_salary string (191)
last_salary_currency string (191)
university string (191)
college string (191)
graduate_year date
graduate_degree enum
last_degree_id integer
about_description text
courses_desc text
resume string (191)

companies

id increments
timestamps timestamps
user_id ^FK integer
hiring_responsible text
phone_responsible text
mobile_responsible text
transfers_responsible text
establishment_data date
company_field text
details text

settings

id increments
timestamps timestamps
email string (191)
site_name string (191)
meta_tags text
search_words text
twitter string (191)
youtube string (191)
facebook string (191)
job_condition text
video string (191)

disabilities

id increments
timestamps timestamps
name string (191)
status enum

job_articles

id increments
timestamps timestamps
title string (191)
image string (191)
body text
status enum

pages

id increments
timestamps timestamps
title string (191)
body text
flag enum

cities

id increments
timestamps timestamps
softDeletes softDeletes
name string (191)
parent_id ^FK integer
type enum

categories

id increments
timestamps timestamps
name string (191)
status enum
parent_id ^FK integer

jobs

id increments
timestamps timestamps
title string (191)
body text
skills text
end_date date
category_id ^FK integer
disability_id ^FK integer
job_start_date date
job_system enum
salary string (191)
salary_currency string (191)
transfer_salary string (191)
transfer_salary_currency string (191)
health_allowance enum
health_write string (191)
empty_jobs integer
region enum
city_id ^FK integer
company_id ^FK integer
prefer_exp enum
exp_years string (191)
settledown_country_id ^FK integer
gender enum
nationality_id ^FK integer
education_id ^FK integer
status enum
admin_opinion enum

educations

id increments
timestamps timestamps
name string (191)
status enum

banners

id increments
timestamps timestamps
title string (191)
image string (191)
url string (191)
position enum
notes text
status enum

user_docs

id increments
timestamps timestamps
user_id ^FK integer
type enum
link_image string (191)
approved enum

contacts

id increments
timestamps timestamps
name string (191)
email string (191)
country_id ^FK integer
reason string (191)
body text
read enum

subscriptions

id increments
timestamps timestamps
softDeletes softDeletes
name string (191)
ad_numbers integer
cv_count integer
price string (191)
website_interview enum

user_experiences

id increments
timestamps timestamps
user_id ^FK integer
start_job date
end_job date
company_name string (191)
company_field_id ^FK integer
job_title string (191)
company_address text
city_id ^FK integer
job_description text

prefered_jobs

id increments
timestamps timestamps
user_id ^FK integer
countries json
job_title string (191)
job_category_id ^FK integer
job_system enum
salary string (191)
salary_currency string (191)

user_skills

id increments
timestamps timestamps
user_id ^FK integer
title string (191)
level enum
experience string (191)
last_practice string (191)

job_history

id increments
timestamps timestamps
softDeletes softDeletes
user_id ^FK integer
hired enum
company_name string (191)
story text

worker_interests

id increments
timestamps timestamps
worker_id ^FK integer
company_id ^FK integer

worker_ignores

id increments
timestamps timestamps
worker_id ^FK integer
company_id ^FK integer

appointment_request

id increments
timestamps timestamps
worker_id ^FK integer
company_id ^FK integer
date date
approved enum
status enum

company_subscriptions

id increments
timestamps timestamps
company_id ^FK integer
subscription_id ^FK integer

questions

id increments
timestamps timestamps
question string (191)
answer text

messages

id increments
timestamps timestamps
room_id ^FK integer
sender_id ^FK integer
receiver_id ^FK integer
message text
seen enum

rooms

id increments
timestamps timestamps
name string (191)
date datetime
open enum
sender_id ^FK integer
receiver_id ^FK integer

notifications

id increments
timestamps timestamps
title string (191)
body text
user_id ^FK integer

favourites

id increments
timestamps timestamps
user_id ^FK integer
job_id ^FK integer

resumes

id increments
timestamps timestamps
user_id ^FK integer
fullname string (191)
disability_id ^FK integer
social_status enum
social_insurance string (191)
email string (191)
city string (191)
mobile string (191)
birthday date
gender enum
nationality string (191)
image string (191)

resume_qualifications

id increments
timestamps timestamps
resume_id ^FK integer
certificate_title string (191)
certificate_univercity string (191)
from date
to date

resume_experiences

id increments
timestamps timestamps
title string (191)
experience_place string (191)
from date
to date
resume_id ^FK integer

resume_courses

id increments
timestamps timestamps
title string (191)
course_place string (191)
from date
to date
resume_id ^FK integer

resume_skills

id increments
timestamps timestamps
title string (191)
details text
resume_id ^FK integer
from date
to date

header_tips

id increments
timestamps timestamps
title string (191)

applied_jobs

id increments
timestamps timestamps
user_id ^FK integer
job_id ^FK integer