# task_people

## Purpose

The **task_people** table defines the assignment relationship between tasks and personnel.

It is used to track which personnel are responsible for specific task within the facility.


## Columns

| Field  | Type        | Description
|--------|-------------|-------------------------------|
| id_tas | MEDIUMINT   | Task identifier (PK, FK)
| id_per | MEDIUMINT   | Personnel identifier (PK, FK)
|------------------------------------------------------|


## Relationships

- References **task.id_tas** through **id_tas** to show what personnel is assigned to which task.
- References **personnel.id_per** through **id_per** to associate a personnel to task.


## Rules

- A task may have multiple assigned personnel.
- A personnel member may be assigned to multiple tasks.
- Each combination of `id_tas` and `id_per` must be unique.


## Example output

+--------+--------+
| id_tas | id_per |
+--------+--------+
|      1 |     55 |
|      1 |     56 |
+--------+--------+