# experiment_personnel

## Purpose

The **experiment_personnel** table defines the relationship between personnel and experiments.

It is used to track which personnel participated in a given experiment and what operational role they performed during the procedure.

This table represents the human execution layer of experimental operations.

## Columns

| Field  | Type      | Description
|--------|-----------|-------------------------------------------------------------|
| id_exp | BIGINT    | Experiment identifier (PK, FK)
| id_per | MEDIUMINT | Personnel identifier (PK, FK)
| role   | ENUM      | Functional role assigned to personnel within the experiment
|----------------------------------------------------------------------------------|

### ENUM values
- role = ('lead_researcher','researcher','assistant_researcher','observer','security','medical','logistics','technician','supervisor')


## Relationships

- References **experiment.id_exp** through **id_exp** to assign personnel to a specific experiment.
- References **personnel.id_per** through **id_per** to link staff members participating in experiments.


## Rules

- The combination of **id_exp + id_per** uniquely identifies participation.
- Personnel may participate in multiple experiments.
- Experiment may have multiple personnel.


## Example output

+--------+--------+-----------------+
| id_exp | id_per | role            |
+--------+--------+-----------------+
|      5 |     10 | lead_researcher |
|      5 |     23 | researcher      |
|      5 |     26 | researcher      |
+--------+--------+-----------------+