# mtf

## Purpose

The **mtf** table stores Mobile Task Force units; specialized security and response teams responsible for handling containment breaches and high-risk facility incidents.

It stores static information including operational squads, unit designations and optional (but highly recommended) identification nicknames.


## Columns

| Field    | Type         | Description
|----------|--------------|-------------------------------------------------------------------|
| id_mtf   | SMALLINT     | Unique Mobile Task Force identifier (PK, AUTO_INCREMENT)
| unit     | VARCHAR(30)  | Designation of the MTF unit (e.g. alpha, epsilon, omega)
| squad    | SMALLINT     | Squad number within the unit
| nickname | VARCHAR(255) | Optional unit nickname used for identification (NULLABLE, UNIQUE)
|---------------------------------------------------------------------------------------------|


## Relationships

- Referenced by **personnel_mtf.id_mtf** to assign personnel members to Mobile Task Force units.


## Rules

- `nickname` must be unique when present.


## Example output

+--------+-------+-------+----------------+
| id_mtf | unit  | squad | nickname       |
+--------+-------+-------+----------------+
|      1 | alpha |     1 | Red Right Hand |
+--------+-------+-------+----------------+