# dclass

## Purpose

The **dclass** table stores records for D-Class personnel assigned to facility operations.

It stores static D-Class record that includes identity, assigned cell, operational status, and a fixed expiration date.

D-Class personnel are temporary individuals used for experimentation, testing and controlled exposure to SCP entities.


## Columns

| Field      | Type        | Description
|------------|-------------|---------------------------------------------------------------------------------------|
| id_d       | MEDIUMINT   | Unique D-Class identifier (PK, AUTO_INCREMENT)
| first_name | VARCHAR(50) | First name of D-Class personnel
| last_name  | VARCHAR(50) | Last name of D-Class personnel
| id_cel     | SMALLINT    | Assigned cell (NULLABLE, UNIQUE)
| status     | ENUM        | Current operational status of the D-Class personnel
| expires_at | DATE        | Automatic expiration date after which the D-Class is no longer member of the facility
|------------------------------------------------------------------------------------------------------------------|

### ENUM values
- status = ('active','expired','terminated','unknown')


## Relationships

- References **cell.id_cel** through **dclass.id_cel** to assign D-Class personnel to containment cells.
- Referenced by **experiment_dclass.id_d** to record participation of D-Class personnel in experiments.


## Rules

- Each `id_cel` can be assigned to only one personnel member.
- D-Class with `status` value 'expired' must be terminated the on the same day.


## Example output

+------+------------+-----------+--------+--------+------------+
| id_d | first_name | last_name | id_cel | status | expires_at |
+------+------------+-----------+--------+--------+------------+
|    1 | John       | Miller    |      1 | active | 2026-07-05 |
+------+------------+-----------+--------+--------+------------+