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 many 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 a Unit, if the entity option is enabled)
• 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

Manager #

A Manager is someone who works in a Company. They have at least an email address. They also have attributes like a first_name, a last_name or an avatar_url.

A Manager:

• Belongs to a Company (or a Unit, if the entity option is enabled)

Entity & Unit #

Entities and units are optional and depend on the type of contract subscribed with Kelio ATS.

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.

An Entity:

• Belongs to a Company
• Has many Units
• Has their own set of application statuses
• Have their own Channels (diffusion on jobboards)

Unit #

A Unit is a part of an Entity.

A Unit :

• Has many campaigns
• Has many managers