Job board & applicant tracking schema (DBML) template

Tables in this data model

• companies — 4 columns
• recruiters — 4 columns
• jobs — 8 columns
• candidates — 4 columns
• applications — 5 columns
• interviews — 6 columns
• offers — 5 columns

How to use this ER diagram template

1. Click Open in the editor. The ER diagram opens on a new page in FlowDiagram — nothing is uploaded and there is no sign-up.
2. Rename, add or delete shapes and drag them where you want; connectors stay attached as things move.
3. Drop in vendor logos from the library — 1,160 of them, including every AWS, Azure and Google Cloud service icon — or restyle it with the colour and theme controls.
4. Prefer text? Edit the DBML below and paste it in through ☰ → Import diagram; the finished model exports to SQL DDL or back to DBML.
5. Export to PNG, SVG or PDF, or press Ctrl+L for a link that carries the whole diagram.

DBML source

The whole template is the text below. Paste it into FlowDiagram, keep it in Git next to the code it describes, or hand it to an AI assistant to extend.

Table companies {
  id integer [pk]
  name varchar
  industry varchar
  website varchar
}

Table recruiters {
  id integer [pk]
  company_id integer [ref: > companies.id]
  name varchar
  email varchar [unique]
}

Table jobs {
  id integer [pk]
  company_id integer [ref: > companies.id]
  recruiter_id integer [ref: > recruiters.id]
  title varchar
  location varchar
  salary_min integer
  salary_max integer
  status varchar
}

Table candidates {
  id integer [pk]
  email varchar [unique]
  name varchar
  resume_url varchar
}

Table applications {
  id integer [pk]
  job_id integer [ref: > jobs.id]
  candidate_id integer [ref: > candidates.id]
  stage varchar
  applied_at timestamp
}

Table interviews {
  id integer [pk]
  application_id integer [ref: > applications.id]
  interviewer_id integer [ref: > recruiters.id]
  scheduled_at timestamp
  score integer
  feedback text
}

Table offers {
  id integer [pk]
  application_id integer [ref: > applications.id]
  base_salary integer
  start_date date
  status varchar
}

Related: Database schema diagram tool · All database & er models templates · All 521 templates