Database overview #

Company #

The Company is the most important table in our database.

A Company:

• Has many campaigns
• Has many applicants
• Has many managers
• Optionally (depending on the contract subscribed with Kelio ATS), it might have some entities.

Campaign #

A Campaign represents a job offer. A Campaign has for example a job description, an address or a salary.

A Campaign:

• Belongs to a Company (or an Entity)
• Has many applications

Applicant #

An Applicant refers to a person, it’s the candidate who applies to jobs offer (Campaign). They have attributes like a email, a last_name or an avatar_url.

An Applicant:

• Belongs to a Company
• Has many applications

Application #

An Application is a request for a specific job (Campaign) from an Applicant. They have for example a source (from where they found the job offer) and a status.

An Application:

• Belongs to an Applicant
• Belongs to a Campaign

Entity #

An Entity is the equivalent of a brand. The logo and the name are different from the Company. In a large firm, the Company would be the headquarters, and the entities would be the subsidiaries.

The entities are optional and depend on the type of contract subscribed with Kelio ATS.

An Entity:

• Belongs to a Company
• Have their own Channels (diffusion on jobboards)