vacancies

2571 rows


Description

Stores vacancy(jobs) data

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id VARCHAR 36 null
title VARCHAR 125 null
company VARCHAR 75 √ null
state_id VARCHAR 36 √ null
district_id VARCHAR 36 √ null
area VARCHAR 50 √ null
last_date_to_apply DATETIME 19 √ null
expected_salary INT 10 √ null
shift_timings VARCHAR 50 √ null
skills MEDIUMTEXT 16777215 √ null
education_qualification_id VARCHAR 100 √ null
vacancy_type_id VARCHAR 36 √ null
reference_contact_name VARCHAR 100 √ null
reference_contact_designation VARCHAR 50 √ null
reference_contact_phone VARCHAR 30 √ null
reference_contact_email VARCHAR 50 √ null
contact_details LONGTEXT 2147483647 √ null
website VARCHAR 50 √ null
openings INT 10 √ null
created_by VARCHAR 36 √ null
created_at TIMESTAMP 19 √ null
updated_at TIMESTAMP 19 √ null
status INT 10 √ 1

0:Inactive,1:Active

is_approved INT 10 √ 0

1:Approved,0:Not Approved

deleted_at TIMESTAMP 19 √ null
old_data_id INT 10 √ null
tenant_id VARCHAR 36 null
updated_by VARCHAR 36 √ null
expected_salary_range INT 10 √ null
next_notify_on TIMESTAMP 19 √ null
deleted_by VARCHAR 36 √ null
additional_information LONGTEXT 2147483647 √ null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
area Performance Asc area
district_id Performance Asc district_id
last_date_to_apply Performance Asc last_date_to_apply
state_id Performance Asc state_id
tenant_id Performance Asc tenant_id
vacancy_type_id Performance Asc vacancy_type_id

Relationships