# scp_status

## Purpose

The **scp_status** table stores dynamic operational state information for SCP entities.

It tracks the current containment status, active operational activity and the timestamp of the last state.

This table is separated from the static SCP registry to ensure clear distinction between entity definition and its runtime behavior.

## Columns

| Field        | Type        | Description
|--------------|-------------|---------------------------------------------------|
| id_scp       | MEDIUMINT   | SCP identifier (PK)
| status       | ENUM        | Current containment status of the SCP
| current_act  | ENUM        | Current operational activity involving the SCP
| started_at   | DATETIME    | Timestamp of when the current state was initiated
|--------------------------------------------------------------------------------|

### ENUM values
- status = ('contained','breached','unknown')
- current_act = ('idle','experiment','transport','maintenance','emergency')

## Relationships

- References **scp.id_scp** through **id_scp** to maintain a runtime state record for each SCP.


## Rules

- Each SCP has maximum one active status record.
- When `status` value is 'unknown', `current_act` must be NULL.


## Example output

+--------+-----------+-------------+---------------------+
| id_scp | status    | current_act | started_at          |
+--------+-----------+-------------+---------------------+
|      2 | contained | idle        | 2026-06-24 10:59:44 |
+--------+-----------+-------------+---------------------+