12
Tables (7)
departments
- id — INT
- name — VARCHAR(100) — NOT NULL
- created_at — TIMESTAMP
employee_logs
- id — INT
- employee_id — INT
- action — VARCHAR(20)
- created_at — TIMESTAMP
employees
- id — INT
- name — VARCHAR(100) — NOT NULL
- department_id — INT — NOT NULL
- team_id — INT
- position_id — INT — NOT NULL
- role_id — INT
- created_at — TIMESTAMP
positions
- id — INT
- name — VARCHAR(50) — NOT NULL
- category — VARCHAR(50)
- level — INT
- created_at — TIMESTAMP
roles
- id — INT
- name — VARCHAR(50) — NOT NULL
- created_at — TIMESTAMP
teams
- id — INT
- department_id — INT — NOT NULL
- name — VARCHAR(100) — NOT NULL
- created_at — TIMESTAMP
users
- id — INT
- username — VARCHAR(50) — NOT NULL
- password_hash — VARCHAR(255) — NOT NULL
- created_at — TIMESTAMP