# incident_log

## Purpose

The **incident_log** table stores records of abnormal events, physical security violations, containment failures, safety hazards and other incidents occurring within the facility.

It is used to document, investigate and evaluate events that may impact facility operations, personnel safety or SCP containment integrity.

## Columns

| Field       | Type        | Description
|-------------|-------------|------------------------------------------------------------------------------------|
| id_inc_log  | BIGINT      | Unique incident log identifier (PK, AUTO_INCREMENT)
| id_per      | MEDIUMINT   | Personnel identifier associated with the incident (FK, NULLABLE)
| id_scp      | MEDIUMINT   | SCP identifier associated with the incident (FK, NULLABLE)
| id_loc      | SMALLINT    | Location identifier associated with the incident (FK, NULLABLE)
| type        | VARCHAR(100)| Category or type of incident
| severity    | ENUM        | Severity level assigned to the incident
| description | TEXT        | Detailed description of the incident
| timestamp   | DATETIME    | Timestamp when the incident occurred
|----------------------------------------------------------------------------------------------------------------|

### ENUM values
- severity = ('low','medium','high','critical')


## Relationships

- References **personnel.id_per** through **id_per** to optionally associate an incident with a staff member.
- References **scp.id_scp** through **id_scp** to optionally associate an incident with a specific SCP entity.
- References **location.id_loc** through **id_loc** to optionally associate an incident with a physical facility location.


## Rules

- At least one contextual reference (`id_per`, `id_scp`, or `id_loc`) should be provided whenever applicable.
- Log entries are unalterable and should not be modified after creation.


## Example output (with \G operator)

*************************** 1. row ***************************
 id_inc_log: 1
     id_per: NULL
     id_scp: 106
     id_loc: 11
       type: containment_breach
   severity: critical
description: SCP breached its containment chamber
  timestamp: 2026-06-27 14:56:24