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

Banco de dados — Ficha de Admissão

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

admin_users

Campo Definição
id INT UNSIGNED AUTO_INCREMENT PRIMARY KEY
name VARCHAR(150) NOT NULL
email VARCHAR(190) NOT NULL UNIQUE
password_hash VARCHAR(255) NOT NULL
role VARCHAR(20) NOT NULL DEFAULT 'admin'
is_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

admissions

Campo Definição
id INT UNSIGNED AUTO_INCREMENT PRIMARY KEY
consent TINYINT(1) NOT NULL DEFAULT 0
race VARCHAR(50) NOT NULL
unit_name VARCHAR(150) NOT NULL
job_title VARCHAR(150) NOT NULL
full_name VARCHAR(190) NOT NULL
father_name VARCHAR(190) NULL
mother_name VARCHAR(190) NOT NULL
birth_date DATE NOT NULL
marital_status VARCHAR(50) NOT NULL
is_student TINYINT(1) NOT NULL DEFAULT 0
education_level VARCHAR(100) NOT NULL
nationality VARCHAR(100) NOT NULL
place_of_birth VARCHAR(150) NULL
personal_email VARCHAR(190) NOT NULL
phone VARCHAR(20) NOT NULL
emergency_contact VARCHAR(20) NOT NULL
address_line VARCHAR(190) NOT NULL
address_number VARCHAR(20) NOT NULL
neighborhood VARCHAR(120) NOT NULL
zip_code VARCHAR(12) NOT NULL
city VARCHAR(120) NOT NULL
address_extra VARCHAR(190) NULL
state CHAR(2) NOT NULL
rg_number VARCHAR(30) NOT NULL
rg_issue_date DATE NOT NULL
rg_issuer VARCHAR(80) NOT NULL
birth_city VARCHAR(120) NOT NULL
birth_state CHAR(2) NOT NULL
cpf VARCHAR(14) NOT NULL UNIQUE
pis_number VARCHAR(20) NOT NULL
pis_issue_date DATE NOT NULL
has_dependents TINYINT(1) NOT NULL DEFAULT 0
dependent_has_disability TINYINT(1) NOT NULL DEFAULT 0
uses_transport_voucher TINYINT(1) NOT NULL DEFAULT 0
transport_voucher_daily_value DECIMAL(10,2) NULL
uniform_size VARCHAR(10) NULL
cref_number VARCHAR(30) NULL
professor_mei_cnpj VARCHAR(18) NULL
employment_function VARCHAR(150) NULL
admission_date DATE NULL
dismissal_date DATE NULL
workload_hours VARCHAR(30) NULL
work_schedule VARCHAR(120) NULL
work_schedule_hours VARCHAR(120) NULL
salary_amount DECIMAL(10,2) NULL
salary_type VARCHAR(20) NULL
bank_payment_method VARCHAR(20) NOT NULL DEFAULT 'pix'
bank_agency VARCHAR(30) NULL
bank_account VARCHAR(40) NULL
pix_key VARCHAR(190) NULL
status VARCHAR(40) NOT NULL DEFAULT 'recebido'
internal_notes TEXT NULL
lgpd_consent_at DATETIME NULL
submitted_ip VARCHAR(45) NULL
created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP
updated_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP

Índices/constraints:

  • INDEX idx_admissions_status (status)
  • INDEX idx_admissions_created_at (created_at)
  • INDEX idx_admissions_status_created_at (status, created_at)
  • INDEX idx_admissions_full_name (full_name)
  • INDEX idx_admissions_unit (unit_name)
  • INDEX idx_admissions_job (job_title)

dependents

Campo Definição
id INT UNSIGNED AUTO_INCREMENT PRIMARY KEY
admission_id INT UNSIGNED NOT NULL
full_name VARCHAR(190) NOT NULL
birth_date DATE NOT NULL
cpf VARCHAR(14) NOT NULL
birth_city VARCHAR(120) NOT NULL
has_disability TINYINT(1) NOT NULL DEFAULT 0
created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP
updated_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP

Índices/constraints:

  • CONSTRAINT fk_dependents_admission FOREIGN KEY (admission_id) REFERENCES admissions(id) ON DELETE CASCADE

academic_infos

Campo Definição
id INT UNSIGNED AUTO_INCREMENT PRIMARY KEY
admission_id INT UNSIGNED NOT NULL
internship_nature VARCHAR(120) NOT NULL
academic_level VARCHAR(120) NOT NULL
institution_name VARCHAR(190) NOT NULL
institution_cnpj VARCHAR(18) NOT NULL
institution_address VARCHAR(190) NOT NULL
institution_neighborhood VARCHAR(120) NOT NULL
institution_number VARCHAR(20) NOT NULL
institution_zip VARCHAR(12) NOT NULL
institution_city VARCHAR(120) NOT NULL
institution_state CHAR(2) NOT NULL
advisor_name VARCHAR(190) NOT NULL
semester VARCHAR(50) NOT NULL
study_shift VARCHAR(80) NULL
course_name VARCHAR(190) NOT NULL
registration_number VARCHAR(80) NOT NULL
created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP
updated_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP

Índices/constraints:

  • CONSTRAINT fk_academic_admission FOREIGN KEY (admission_id) REFERENCES admissions(id) ON DELETE CASCADE

attachments

Campo Definição
id INT UNSIGNED AUTO_INCREMENT PRIMARY KEY
admission_id INT UNSIGNED NOT NULL
label_key VARCHAR(50) NOT NULL
original_name VARCHAR(190) NOT NULL
stored_name VARCHAR(190) NOT NULL
relative_path VARCHAR(255) NOT NULL
mime_type VARCHAR(120) NOT NULL
size_bytes BIGINT UNSIGNED NOT NULL DEFAULT 0
created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP
updated_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP

Índices/constraints:

  • UNIQUE KEY uniq_admission_label (admission_id, label_key)
  • CONSTRAINT fk_attachments_admission FOREIGN KEY (admission_id) REFERENCES admissions(id) ON DELETE CASCADE