Table distribution

This is a draft table distribution for the new CRM and Talent.
Some tables will be removed as Enums are introduced.
Every table should be thoroughly thought out during implementation of a corresponding module (Candidates, Vacancies etc.)

CRM tables:
 - consultants
 - last_activites
 - login_histories
 - professions
 - business_units
 - consultant_categories?
 - business_units_categories?
 - highlights
 - notifications
 
 - paas_reports
 - active_sourcing
 - activites_feeds
 
 - mandates
 - mandates_staff
 - mandates_lists_staff
 - mandates_lists
 - mandates_companies

 - candidates_vacancy_requests
 - request_interview_dates
 - candidates_vacancy_requests_actions
 
 - cron_emails
 - comments
 - arhistory
 - email_history
 - contacts_history
 - statistic
 - manuals
 - manuals_categories
 
 - companies_cosultants
 
 - vacancies_consultants (new)
 
 - manuals
 - manuals_categories
 
 - cron_emails
 - comments
 - arhistory (or analog)
 - email_history
 - contacts_history 
 - statistic
 
 - sendgrid_webhooks

 - applications
 - applications_devices
 - applications_attachments

Talent tables:
 - countries
 - cities
 - regions_old?
 - zips
 - city_zip
 - addresses
 
 - companies
 - company_tracking_settings
 - company_industry
 - benefit_company
 - company_skill
 
 - staff
 - staff_drivers
 - staff_healths
 - staff_categories
 - staff_languages
 - vacancies_staff
 - staff_skills
  
 - vacancies
 - vacancies_keywords
 - employments_vacancies
 - language_vacancy
 - categories_vacancies
 - benefit_vacancy
 - city_vacancy
 - addresses_vacancies
 - degree_vacancies
 - vacancies_skills
 
 - surveys
 - survey_questions
 - questions
 - question_options
 - answers
 - answer_question_options
 - candidate_survey
 - interviews?
 - references?
 - interviews_cities?
 
 - residence_permits
 - currencies
 - marriages
 - hobbies
 - nationalities
 - employments
 - drivers
 - languages
 - language_levels
 - keywords
 - categories
 - travels
 - degrees
 - healths
 - platforms
 - industries
 - skills
 - benefits
 
 - candidates
 - candidates_hobbies
 - candidates_cities
 - candidates_nationalities
 - employments_candidates
 - candidates_drivers
 - candidates_categories
 - candidates_languages
 - candidates_healths
 - candidates_platforms
 - candidates_industries
 - skills_candidates
 - previous_jobs
 - educations
 - attachments
 - attachments_previous_jobs
 - attachments_educations
 - previews

Comments

Leave a Reply