# dclass_state

## Purpose

The **dclass_state** table stores dynamic operational status information for D-Class personnel.

It is used to track real-time conditions such as assigned tasks, health status and last system update time. This table is separated from the main D-Class registry to ensure a clear distinction between static identity data and runtime state.


## Columns

| Field        | Type      | Description 
|--------------|-----------|--------------------------------------------------------|
| id_d         | MEDIUMINT | Unique D-class identifier (PK, FK)
| task_state   | ENUM      | Current operational task state of the D-Class
| last_update  | DATETIME  | Timestamp of the last state update
------------------------------------------------------------------------------------|

### ENUM values
- task_state = ('idle','on_task','assigned','unknown')

## Relationships

- References **dclass.id_d** through **id_d** to maintain a runtime state record for each D-Class.


## Rules

- Each D-Class has maximum one corresponding state entry.
- Unavailable D-Class must have `task_state` value 'unknown'
- Retired and deceased D-Class must not have a row in **dclass_state**.

## Example output

+------+------------+---------------------+
| id_d | task_state | last_update         |
+------+------------+---------------------+
|    1 | idle       | 2026-06-05 17:42:01 |
+------+------------+---------------------+