# scp

## Purpose

The **scp** table serves as the central registry for all SCP entities contained and managed within the facility; with a possible exceptions.

It stores static information about each SCP, including its classification, assigned containment location and minimum clearance level required for documentation access.

## Columns

| Field     | Type        | Description
|-----------|-------------|--------------------------------------------------------------------|
| id_scp    | MEDIUMINT   | Unique SCP identifier (PK, AUTO_INCREMENT)
| nickname  | VARCHAR(255)| Nickname for better and faster identification (NULLABLE, UNIQUE)
| class     | ENUM        | Classification level defining risk and containment difficulty
| id_loc    | SMALLINT    | Assigned containment location within the facility (NULLABLE)
| clearance | TINYINT     | Minimum clearance level required to access the SCP documentation
|----------------------------------------------------------------------------------------------|

### ENUM values
- class = ('safe','euclid','keter','thaumiel','apollyon','neutralized','pending')


## Relationships

- References **location.id_loc** through **id_loc** to assign SCP entities to a physical location within the facility.
- Referenced by **experiment.id_scp** to associate experiments with specific SCP entities.
- Referenced by **activity_log.id_scp** to log SCP-related activity and access attempts.
- Referenced by **incident_log.id_scp** to log SCP-related incidents.


## Rules

- `nickname` must be unique when present.


## Example output

+--------+-------------------+--------+--------+-----------+
| id_scp | nickname          | class  | id_loc | clearance |
+--------+-------------------+--------+--------+-----------+
|      2 | The "Living" Room | euclid |      9 |         2 |
+--------+-------------------+--------+--------+-----------+