# personnel_mtf

## Purpose

The **personnel_mtf** table defines to what Mobile Task Force unit does personnel belong to.

It stores static data to track which personnel are assigned to which MTF unit, including their operational rank within that unit.

This table represents a many-to-many relationship between personnel and MTF structures, with additional metadata for rank hierarchy.

## Columns

| Field    | Type        | Description
|----------|-------------|------------------------------------------------------------------------------------|
| id_per   | MEDIUMINT   | Personnel identifier (PK, FK)
| id_mtf   | SMALLINT    | Mobile Task Force unit identifier (FK)
| rank     | ENUM        | Operational rank of the personnel within the assigned MTF unit
|----------------------------------------------------------------------------------------------------------------|

### ENUM values
- rank = ('private','corporal','specialist','sergeant','lieutenant','captain')


## Relationships

- References **personnel.id_per** through **id_per** to assign a personnel member to an MTF unit.
- References **mtf.id_mtf** through **id_mtf** to associate personnel with a specific Mobile Task Force unit.


## Rules

- Each record links one personnel member to one MTF unit.
- `rank` defines the command structure within the assigned unit.


## Example output

+--------+--------+---------+
| id_per | id_mtf | rank    |
+--------+--------+---------+
|     94 |      1 | captain |
+--------+--------+---------+