# Database: employees

Generated by MySQLTuner on Sun Jul  5 17:44:36 2026

### Tables

### Table: departments
- **Engine**: InnoDB

#### Indexes
- **dept_name**: dept_name (BTREE)
- **PRIMARY**: dept_no (BTREE)

#### Columns
- **dept_no**: CHAR(4) NOT NULL
- **dept_name**: VARCHAR(40) NOT NULL

---

### Table: dept_emp
- **Engine**: InnoDB

#### Indexes
- **dept_no**: dept_no (BTREE)
- **PRIMARY**: emp_no,dept_no (BTREE)

#### Columns
- **emp_no**: INT NOT NULL
- **dept_no**: CHAR(4) NOT NULL
- **from_date**: DATE NOT NULL
- **to_date**: DATE NOT NULL

---

### Table: dept_manager
- **Engine**: InnoDB

#### Indexes
- **dept_no**: dept_no (BTREE)
- **PRIMARY**: emp_no,dept_no (BTREE)

#### Columns
- **emp_no**: INT NOT NULL
- **dept_no**: CHAR(4) NOT NULL
- **from_date**: DATE NOT NULL
- **to_date**: DATE NOT NULL

---

### Table: employees
- **Engine**: InnoDB

#### Indexes
- **PRIMARY**: emp_no (BTREE)

#### Columns
- **emp_no**: INT NOT NULL
- **birth_date**: DATE NOT NULL
- **first_name**: VARCHAR(14) NOT NULL
- **last_name**: VARCHAR(16) NOT NULL
- **gender**: ENUM('M','F') NOT NULL
- **hire_date**: DATE NOT NULL

---

### Table: salaries
- **Engine**: InnoDB

#### Indexes
- **PRIMARY**: emp_no,from_date (BTREE)

#### Columns
- **emp_no**: INT NOT NULL
- **salary**: INT NOT NULL
- **from_date**: DATE NOT NULL
- **to_date**: DATE NOT NULL

---

### Table: titles
- **Engine**: InnoDB

#### Indexes
- **PRIMARY**: emp_no,title,from_date (BTREE)

#### Columns
- **emp_no**: INT NOT NULL
- **title**: VARCHAR(50) NOT NULL
- **from_date**: DATE NOT NULL
- **to_date**: DATE NULL

---

## Visual Database Schema (Mermaid)

```mermaid
erDiagram
    departments {
        char dept_no
        varchar dept_name
    }
    dept_emp {
        int emp_no
        char dept_no
        date from_date
        date to_date
    }
    dept_manager {
        int emp_no
        char dept_no
        date from_date
        date to_date
    }
    employees {
        int emp_no
        date birth_date
        varchar first_name
        varchar last_name
        enum gender
        date hire_date
    }
    salaries {
        int emp_no
        int salary
        date from_date
        date to_date
    }
    titles {
        int emp_no
        varchar title
        date from_date
        date to_date
    }
```