Início / Documentação / Banco de dados — Trabalhe Conosco
HTML estilizadov10Sem dependência externa
Ver Markdown originalVoltar ao Hub

Banco de dados — Trabalhe Conosco

Documento gerado a partir dos arquivos SQL do projeto. Não inclui senhas, dados reais nem dumps de produção.

users

Campo Definição
id INT UNSIGNED NOT NULL AUTO_INCREMENT
name VARCHAR(140) NOT NULL
email VARCHAR(180) NOT NULL
password_hash VARCHAR(255) NOT NULL
role ENUM('admin','rh') NOT NULL DEFAULT 'rh'
active TINYINT(1) NOT NULL DEFAULT 1
last_login_at DATETIME NULL
created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP
updated_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP

Índices/constraints:

  • PRIMARY KEY (id)
  • UNIQUE KEY users_email_unique (email)
  • KEY users_role_active_idx (role, active)

units

Campo Definição
id INT UNSIGNED NOT NULL AUTO_INCREMENT
external_id INT UNSIGNED NULL
name VARCHAR(160) NOT NULL
active TINYINT(1) NOT NULL DEFAULT 1
created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP
updated_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP

Índices/constraints:

  • PRIMARY KEY (id)
  • UNIQUE KEY units_external_id_unique (external_id)
  • KEY units_active_name_idx (active, name)

positions

Campo Definição
id INT UNSIGNED NOT NULL AUTO_INCREMENT
title VARCHAR(160) NOT NULL
active TINYINT(1) NOT NULL DEFAULT 1
created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP
updated_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP

Índices/constraints:

  • PRIMARY KEY (id)
  • UNIQUE KEY positions_title_unique (title)
  • KEY positions_active_title_idx (active, title)

candidates

Campo Definição
id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT
uuid CHAR(36) NOT NULL
nome_completo VARCHAR(180) NOT NULL
email VARCHAR(180) NOT NULL
telefone VARCHAR(40) NOT NULL
data_nascimento DATE NULL
cidade VARCHAR(120) NULL
estado CHAR(2) NULL
unidade_id INT UNSIGNED NULL
cargo_id INT UNSIGNED NULL
pretensao_salarial DECIMAL(10,2) NULL
disponibilidade VARCHAR(120) NULL
linkedin VARCHAR(255) NULL
portfolio VARCHAR(255) NULL
origem VARCHAR(120) NULL
experiencia TEXT NOT NULL
status VARCHAR(40) NOT NULL DEFAULT 'novo'
curriculo_original VARCHAR(255) NULL
curriculo_path VARCHAR(255) NULL
curriculo_mime VARCHAR(120) NULL
curriculo_size INT UNSIGNED NULL
lgpd_consentimento TINYINT(1) NOT NULL DEFAULT 0
ip_hash CHAR(64) NULL
user_agent VARCHAR(255) NULL
created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP
updated_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP

Índices/constraints:

  • PRIMARY KEY (id)
  • UNIQUE KEY candidates_uuid_unique (uuid)
  • KEY candidates_status_created_idx (status, created_at)
  • KEY candidates_created_idx (created_at)
  • KEY candidates_nome_idx (nome_completo)
  • KEY candidates_email_idx (email)
  • KEY candidates_unidade_status_idx (unidade_id, status)
  • KEY candidates_cargo_status_idx (cargo_id, status)
  • KEY candidates_curriculo_created_idx (curriculo_path, created_at)
  • KEY candidates_unidade_curriculo_idx (unidade_id, curriculo_path)
  • KEY candidates_cargo_curriculo_idx (cargo_id, curriculo_path)
  • CONSTRAINT candidates_unit_fk FOREIGN KEY (unidade_id) REFERENCES units(id) ON DELETE SET NULL
  • CONSTRAINT candidates_position_fk FOREIGN KEY (cargo_id) REFERENCES positions(id) ON DELETE SET NULL

candidate_notes

Campo Definição
id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT
candidate_id BIGINT UNSIGNED NOT NULL
user_id INT UNSIGNED NOT NULL
note TEXT NOT NULL
created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP

Índices/constraints:

  • PRIMARY KEY (id)
  • KEY candidate_notes_candidate_idx (candidate_id, created_at)
  • CONSTRAINT candidate_notes_candidate_fk FOREIGN KEY (candidate_id) REFERENCES candidates(id) ON DELETE CASCADE
  • CONSTRAINT candidate_notes_user_fk FOREIGN KEY (user_id) REFERENCES users(id) ON DELETE CASCADE

candidate_status_history

Campo Definição
id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT
candidate_id BIGINT UNSIGNED NOT NULL
user_id INT UNSIGNED NULL
status_from VARCHAR(40) NULL
status_to VARCHAR(40) NOT NULL
created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP

Índices/constraints:

  • PRIMARY KEY (id)
  • KEY candidate_status_history_candidate_idx (candidate_id, created_at)
  • CONSTRAINT candidate_status_history_candidate_fk FOREIGN KEY (candidate_id) REFERENCES candidates(id) ON DELETE CASCADE
  • CONSTRAINT candidate_status_history_user_fk FOREIGN KEY (user_id) REFERENCES users(id) ON DELETE SET NULL