EDU API: Foreign keys as Endpoints in Different Tables

Sometimes endpoints will exist in other tables as foreign keys. Foreign keys exist in tables outside of their original table. 

Use this article as a reference for what different endpoints exist as foreign keys in different tables.

Topics:

• Students
• Employers
• Jobs
• Postings
• Career Fair Sessions
• Career Fair
• Event
• Industry
• Survey
• Other IDs

STUDENTS

The students table will have endpoints on student data (i.e. first name, last name, major etc.)

Look for the student_id foreign key in other tables to tie in student data. The student id endpoint exists in the following tables:

• Applications
• Appointments
• Career fair attendance
• Event attendance
• Experiences
• First destination responses
• Interview schedule slots
• Student interests
• Student labels
• Student skills

EMPLOYERS

The employers table has base line data on employers (i.e. description.) 

Look for the employer_id foreign key in other tables to tie in employer data. The employer id endpoint exists in the following tables: 

• Applications
• Career Fair Employer Engagement
• Collections (as a list) - the key is plural (e.g. employer_ids)
• Contacts
• Employer Labels
• Event Employer Engagement
• Events (found as host_id or owner_id if the host or owner type is Employer)
• Interview Schedules
• Jobs
• Meetings

JOBS

The jobs table will have endpoints on job data (i.e. title, description, etc.)

Look for the job_id foreign key in other tables to tie in job data. The job id endpoint exists in the following tables:

• Applications
• Collections (as a list) - the key is plural (e.g. job_ids)
• Interview Schedules (as a list) - the key is plural (e.g. job_ids)
• Job Labels
• Job Locations
• Job Role Group
• Job Student Qualifications
• Postings

POSTINGS

The postings table will have endpoints on job posting data (i.e. title, description, etc.)

Look for the posting_id foreign key in other tables to tie in job data. The posting id endpoint exists in the following tables:

• Job Student Qualifications

CAREER FAIR SESSIONS

The Career Fair Sessions table will have endpoints on fair session data (i.e. start time, etc.)

Look for the career_fair_sessions_id foreign key in other tables to tie in session data. The session id endpoint exists in the following tables:

• Career Fair Attendance
• Meetings

CAREER FAIR

The Career Fairs table will have endpoints on fair data (i.e. title, description, etc.)

Look for the career_fair_id foreign key in other tables to tie in fair data. The fair id endpoint exists in the following tables:

• Career Fair Sessions
• Career Fair Employer Engagement
• Collections (as a list) - the key is plural (e.g. career_fair_ids)

EVENT

The Events table will have endpoints on event data (i.e. title, description, etc.)

Look for the event_id foreign key in other tables to tie in fair data. The event id endpoint exists in the following tables:

• Collections (as a list) - the key is plural (e.g. event_ids)
• Event Attendance
• Event Employer Engagement
• Event Labels

INDUSTRY

The Industry table will have endpoints on industry data (i.e. title, e.g.)

Look for the industry_id foreign key in other tables to tie in fair data. The industry id endpoint exists in the following tables:

• Employers

SURVEY

The Survey table will have endpoints on surveys data (i.e. title, e.g.)

Look for the survey_id foreign key in other tables to tie in fair data. The survey id endpoint exists in the following tables:

• Events
• Career Fairs
• Survey Responses

Other IDs

• Host_ID and Owner_ID in the Events endpoint refers to the employer or school ID depending on the Host_type or Owner_type
• First_destination_survey_id is located in the First destination response endpoint
• Interview_slots_id is located in the Interview Schedule endpoint
• job_role_group_id - found in job role groups endpoint
• Question_id in survey responses