logo
ExamplesEditorPricingDocs
37.1kSign in

Applicant tracking & recruiting database schema

An ATS modelled end to end: jobs with openings and hiring teams, candidates separate from applications, per-job pipeline stages, interviews with panels, structured scorecards, offers with approval chains and a talent pool of near misses.

Applicant Tracking ER diagram

Applicant tracking & recruiting database schema n1 n1 n1 n1 n1 n1 n1 n1 n1 n1 n1 n1 n1 n1 n1 n1 n1 n1 n1 n1 n1 n1 n1 n1 n1 n1 n1 users idBIGINT emailVARCHAR full_nameVARCHAR job_titleVARCHAR departmentVARCHAR timezoneVARCHAR is_activeBOOLEAN jobs idBIGINT titleVARCHAR departmentVARCHAR locationVARCHAR employment_typeVARCHAR statusVARCHAR openings_countSMALLINT filled_countSMALLINT recruiter_user_idBIGINT hiring_manager_us…BIGINT salary_min_minorBIGINT salary_max_minorBIGINT currency_codeCHAR opened_atTIMESTAMP closed_atTIMESTAMP hiring_team_members job_idBIGINT user_idBIGINT team_roleVARCHAR can_view_scorecar…BOOLEAN added_atTIMESTAMP candidates idBIGINT emailVARCHAR first_nameVARCHAR last_nameVARCHAR phoneVARCHAR locationVARCHAR linkedin_urlVARCHAR sourceVARCHAR referred_by_user_…BIGINT consent_expires_atTIMESTAMP created_atTIMESTAMP job_stages idBIGINT job_idBIGINT nameVARCHAR positionSMALLINT stage_typeVARCHAR scorecard_attribu…JSONB is_terminalBOOLEAN applications idBIGINT candidate_idBIGINT job_idBIGINT current_stage_idBIGINT statusVARCHAR sourceVARCHAR rejection_reasonVARCHAR rejection_stage_idBIGINT rejected_by_user_…BIGINT applied_atTIMESTAMP last_activity_atTIMESTAMP interviews idBIGINT application_idBIGINT stage_idBIGINT titleVARCHAR scheduled_startTIMESTAMP scheduled_endTIMESTAMP timezoneVARCHAR locationVARCHAR meeting_urlVARCHAR statusVARCHAR created_by_user_idBIGINT interview_panelists interview_idBIGINT user_idBIGINT panel_roleVARCHAR invite_responseVARCHAR is_requiredBOOLEAN scorecards idBIGINT interview_idBIGINT interviewer_user_…BIGINT application_idBIGINT overall_recommend…VARCHAR notesTEXT submitted_atTIMESTAMP scorecard_ratings scorecard_idBIGINT attributeVARCHAR ratingSMALLINT commentTEXT offers idBIGINT application_idBIGINT statusVARCHAR versionSMALLINT base_salary_minorBIGINT currency_codeCHAR signing_bonus_min…BIGINT equity_unitsINTEGER start_dateDATE expires_atTIMESTAMP sent_atTIMESTAMP responded_atTIMESTAMP declined_reasonVARCHAR created_by_user_idBIGINT offer_approvals idBIGINT offer_idBIGINT approver_user_idBIGINT step_orderSMALLINT decisionVARCHAR decided_atTIMESTAMP commentTEXT talent_pool_entries idBIGINT candidate_idBIGINT source_applicatio…BIGINT pool_nameVARCHAR added_by_user_idBIGINT reasonTEXT revisit_afterDATE removed_atTIMESTAMP added_atTIMESTAMP

Related database schemas

SQL Server
Internal tools

HR and payroll database schema

How an HR system models data that must never be overwritten: employees, positions and reporting lines as dated rows, compensation history, payroll runs and itemised payslips, tax withholding, time off as a ledger, and benefits enrolment.

SQL Server
Internal tools

IT asset management database schema

How an IT estate is tracked end to end: models versus serialised assets, custody history, software licences and seat allocation with compliance counts, warranties and support contracts, maintenance, depreciation, audits and disposal.

PostgreSQL
Internal tools

Sales CRM & pipeline database schema

A sales CRM modelled end to end: accounts and contacts, leads converted into an account, contact and deal, deals moving through stages with full stage history, activities, quotes, forecasts, territories and custom fields.

MySQL
Internal tools

IT helpdesk and service desk database schema

An internal service desk modelled properly: a service catalogue, incidents and requests, ordered approval chains, change requests with risk and rollback plans, linked assets, versioned knowledge base articles, SLA clocks that pause, and satisfaction ratings.