erp_employment_procedures - Laravel Schema Designer

cvs

id increments
first_name string (35)
second_name string (35)
third_name string (35)
last_name string (35)
identification_number string (10)
phone string (10)
job_id ^FK integer
cv_file string
status integer
reject_resone string (50)
deactivated_at date
timestamps timestamps

interviews

id increments
cv_id ^FK integer
date date
from_time time
to_time time
status integer
audio string
location string
attend_date datetime
deactivated_at date
timestamps timestamps

reception_employments

id increments
timestamps timestamps
identification_number string (10)
attendance_date datetime
deactivated_at date
examination_cv_result_id ^FK integer

applied_employees

id increments
image string
cv_id integer
interview_id ^FK integer
identity_source string
identity_date date
nationality_id integer
gender enum
date_of_birth date
marital_status enum
email string (60)
city string (35)
region string (35)
timestamps timestamps
deactivated_at date

applied_employee_attachments

id increments
timestamps timestamps

qualifications

id increments
timestamps timestamps
educational_qualification enum
university_name string
specialization string
graduation_year date
applied_employee_id ^FK integer

exprences

id increments
timestamps timestamps
applied_employee_id ^FK integer
company_name string
job_title string

apply_questions

id increments
content text
timestamps timestamps

apply_answers

id increments
content string
timestamps timestamps

answar_applied_employee_question

applied_employee_id ^FK integer
apply_answer_id ^FK integer
apply_question_id ^FK integer
timestamps timestamps
id increments

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