Here is a suggestion on how to decompose the Vacancies table into Publications table also. To separate entities.
Vacancies
id
travels_id
companies_id
currencies_id
positions_id
consultants_id
categories_id
published – publication
name
experience_from
experience_to
distance
travel_ready
addresses_id
all_cities
workload_from
workload_to
lat
lng
start_date_text
date_publication – publication
date_start
date_end
introduction
task
profile
benefits_unique
price_from
price_to
jobs_ch – to remove?
slug
entity – to remove
vacancy_status – rename to status
age_from
age_to
publication_status – publication’s status
direct_link
parent_id – publication’s vacancies_id
wp_post_id – publication
date_modify
wp_post_date_modify – publication
platforms_id – ?
submitted
date_add
previews_id
active_updated_at
talent_id
wp_post_slug – publication
activated_at
last_tracking_time
new – should be replaced with Highlights
team_size
request_delete – both Vacancies and Publications
experience_level
leading_experience
process_type
Publications (suggestion)
id
vacancies_id
published
date_publication
status
wp_post_id
wp_post_date_modify
wp_post_slug
request_delete
Leave a Reply
You must be logged in to post a comment.