job_portal - Laravel Schema Designer

users

id increments
user_name string (255)
first_name string (255)
last_name string (255)
status tinyInteger
is_employee tinyInteger
is_recruiter tinyInteger
password string (255)
last_update timestamp
softDeletes softDeletes

users_log

id increments
user_name string (255)
first_name string (255)
last_name string (255)
status tinyInteger
is_employee tinyInteger
is_recruiter tinyInteger
password string (255)
last_update timestamp
softDeletes softDeletes

job_posting

id increments
user_id ^FK integer
job_title mediumText
job_profession string (255)
job_location_state string (255)
job_location_city string (255)
job_location_pincode char (10)
job_post_start_date date
job_post_end_date date
total_vacancy integer
status tinyInteger
timestamps timestamps
softDeletes softDeletes

users_contact_info

id increments
user_id ^FK integer
primary_mobile_number string (255)
seconadary_mobile_number string (255)
primary_email_address string (255)
secondary_email_address string (255)
timestamps timestamps
softDeletes softDeletes

job_posting_details

id increments
job_posting_id ^FK integer
job_description text
timestamps timestamps
softDeletes softDeletes

company_agency

id increments
company_agency_name string (255)
company_agency_address mediumText
company_agency_state string (255)
company_agency_city string (255)
company_agency_pincode string (255)
company_agency_contact_number_1 string (255)
company_agency_contact_number_2 string (255)
company_agency_contact_number_3 string
company_agency_fax_number_1 string (255)
company_agency_fax_number_2 string (255)
company_agency_website string (255)
is_active tinyInteger
softDeletes softDeletes
timestamps timestamps

company_agency_info

id increments
company_agency_id ^FK integer
company_agency_description text
year_of_establishment char (4)
status tinyInteger
timestamps timestamps
softDeletes softDeletes

company_agency_contacts_info

id increments
company_agency_id ^FK integer
company_agency_person_1_name string (255)
company_agency_person_1_number_1 string (255)
company_agency_person_1_number_2 string (255)
company_agency_person_1_extension string (255)
company_agency_person_1_email string (255)
company_agency_person_2_name string (255)
company_agency_person_2_number_1 string (255)
company_agency_person_2_number_2 string (255)
company_agency_person_2_extension string (255)
company_agency_person_2_email string (255)
timestamps timestamps
softDeletes softDeletes

user_company_agency_chats

id increments
job_posting_id ^FK integer
user_id ^FK integer
query_question mediumText
replier_id integer
date_time datetime
status tinyInteger
timestamps timestamps
softDeletes softDeletes

users_job_application

id increments
job_posting_id ^FK integer
user_id ^FK integer
date_time datetime
timestamps timestamps
softDeletes softDeletes

professional_speciality

id increments
profession string (255)
speciality string (255)
status tinyInteger
timestamps timestamps
softDeletes softDeletes

users_profile

id increments
user_id ^FK integer
dob date
total_experience float
expertise mediumText
about_me mediumText
description text
cv_upload_path string (255)
timestamps timestamps
softDeletes softDeletes

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