# Database Schema

Auto SQL creates the resource schema automatically when persistence is enabled.

Core tables:

### `nord_vehiclekeys_keys`

Stores persisted key grants:

- plate
- holder identifier
- key type
- expiry timestamp
- created/updated timestamps

### `nord_vehiclekeys_recovery_npcs`

Stores persistent recovery NPC placement and appearance:

- label
- ped model
- scenario
- X/Y/Z
- heading
- creator identifier

### `nord_vehiclekeys_schema`

Tracks internal database schema revisions. This is a database schema number, not the resource release number.

Manual SQL is included at:

```text
sql/install.sql
```