Tables
| Table / View | Children | Parents | Columns | Type | Comments |
|---|---|---|---|---|---|
| locations | 4 | 1 | 13 | Table | A list of all locations. |
| candidate_nationalities | 0 | 2 | 7 | Table | A list of all candidate nationalities. |
| screening_question_answers | 0 | 4 | 11 | Table | A list of all screening question answers. |
| email_activities | 0 | 5 | 14 | Table | A list of all email activities. |
| pipeline_templates | 2 | 3 | 10 | Table | A list of all pipeline templates. |
| talent_pool_activities | 0 | 3 | 11 | Table | A list of all talent pool activities. |
| task_assignments | 0 | 3 | 6 | Table | A list of all task assignments. |
| candidate_date_of_births | 0 | 2 | 6 | Table | A list of candidate date of births. |
| offer_activities | 1 | 3 | 12 | Table | A list of all job/talent pool activities. |
| evaluation_question_answers | 0 | 3 | 9 | Table | A list of all answers to questions within the evaluation. |
| interviews | 2 | 8 | 22 | Table | A list of all interviews. |
| screening_question_templates | 2 | 3 | 9 | Table | A list of all screening question templates. |
| requisition_openings | 0 | 3 | 9 | Table | A list of all requisition openings. |
| candidates | 30 | 3 | 28 | Table | A list of all candidates. |
| questionnaire_answers | 0 | 3 | 9 | Table | A list of all questionnaire answers. |
| candidate_language_skills | 0 | 2 | 8 | Table | A list of all candidate language skills. |
| acquisition_channels | 1 | 0 | 2 | Table | A list of all acquisition channels. |
| candidate_phones | 0 | 2 | 6 | Table | A list of all candidate phones. |
| offer_lifetime_statuses | 0 | 3 | 10 | Table | A list of all job/talent pool lifecycle activities. |
| candidate_genders | 0 | 2 | 6 | Table | A list of candidate genders. |
| candidate_pipeline_stages | 0 | 8 | 17 | Table | A list of all candidate pipeline activities. |
| candidate_emails | 0 | 2 | 6 | Table | A list of all candidate emails. |
| referral_referrers | 1 | 3 | 6 | Table | A list of all referrers. |
| offer_locations | 0 | 3 | 6 | Table | A list of all location assignments to offers. |
| acquisition_campaigns | 1 | 3 | 10 | Table | A list of all acquisition campaigns. |
| email_participations | 0 | 5 | 11 | Table | A list of all email participations. |
| interview_assignments | 0 | 3 | 7 | Table | A list of admin assignments to interviews. |
| tags | 1 | 1 | 7 | Table | A list of all tags. |
| evaluations | 2 | 5 | 11 | Table | A list of all candidate evaluations. |
| offer_salaries | 0 | 2 | 9 | Table | A list of offer salaries. |
| admin_roles | 1 | 1 | 7 | Table | A list of all admin roles. |
| admins | 34 | 2 | 9 | Table | A list of all active admins. |
| candidate_social_links | 0 | 2 | 6 | Table | A list of all candidate social links. |
| tag_assignments | 0 | 4 | 7 | Table | A list of all tag assignments. |
| departments | 3 | 1 | 6 | Table | A list of all departments in the organization. |
| referral_question_answers | 0 | 2 | 8 | Table | A list of all referral question answers. |
| talent_pools | 6 | 3 | 15 | Table | A list of all talent pools. |
| tasks | 2 | 3 | 10 | Table | A list of all tasks. |
| acquisition_line_items | 0 | 3 | 11 | Table | A list of all acquisition ordered items. |
| notes | 0 | 7 | 10 | Table | A list of all notes. |
| candidate_skills | 0 | 2 | 6 | Table | A list of all candidate skills. |
| referral_applications | 1 | 4 | 11 | Table | A list of all referral applications. |
| stages | 6 | 2 | 9 | Table | A list of all stages. |
| requisition_locations | 0 | 3 | 6 | Table | A list of all location assignments to requisitions. |
| companies | 65 | 0 | 6 | Table | A list of all companies in the organization. |
| dynamic_requisition_fields | 0 | 3 | 8 | Table | A list of all dynamic requisition fields. |
| requisition_activities | 0 | 3 | 10 | Table | A list of all requisition activities. |
| offers | 19 | 7 | 44 | Table | A list of all jobs/talent pools. |
| task_activities | 0 | 4 | 12 | Table | A list of all task activities. |
| email_messages | 2 | 2 | 6 | Table | A list of all email messages. |
| placements | 3 | 9 | 24 | Table | A list of placements in jobs/talent pools. |
| candidate_profile_fields | 0 | 2 | 8 | Table | A list of all candidate profile fields. |
| external_users | 1 | 1 | 7 | Table | A list of external users. |
| dynamic_fields | 2 | 1 | 7 | Table | A list of all dynamic fields. |
| requisition_salaries | 0 | 2 | 9 | Table | A list of requisition salaries. |
| email_threads | 3 | 1 | 5 | Table | A list of all email threads. |
| dynamic_job_fields | 0 | 3 | 8 | Table | A list of all dynamic job fields. |
| candidate_activities | 1 | 6 | 16 | Table | A list of all candidate activities. |
| placement_locations | 0 | 3 | 6 | Table | A list of all location assignments to placements. |
| candidate_addresses | 0 | 2 | 6 | Table | A list of all candidate addresses. |
| requisition_offers | 0 | 3 | 6 | Table | A list of all requisition - offer pair assignments. |
| candidate_links | 0 | 2 | 6 | Table | A list of all candidate links. |
| candidate_educations | 0 | 2 | 10 | Table | A list of all candidate educations. |
| questionnaires | 2 | 3 | 7 | Table | A list of all questionnaires. |
| requisitions | 7 | 6 | 37 | Table | A list of all requisitions. |
| candidate_employments | 0 | 2 | 11 | Table | A list of all candidate employments. |
| interview_activities | 0 | 6 | 16 | Table | A list of all interview activities. |
| acquisition_products | 1 | 1 | 3 | Table | A list of all acquisition products. |