# Database Schema Reference

# Database Schema Reference

Persistent tables installed by the current SQL schema.

**Applies to:** `Nord Inventory v2.0.0`

Current schema tables:

- `nord_inventory_custom_categories`
- `nord_inventory_storage`
- `nord_inventory_custom_items`
- `nord_inventory_item_versions`
- `nord_inventory_disabled_reference_items`
- `nord_inventory_preferences`
- `nord_inventory_transactions`
- `nord_inventory_vehicle_categories`
- `nord_inventory_vehicle_models`
- `nord_inventory_audit_log`
- `nord_inventory_backups`
- `nord_inventory_admin_access`

Do not treat these tables as a replacement for the public SDK. External resources should use exports so Nord can preserve source precedence, audit/history and validation semantics.


## v2.0.0 Operations tables

### `nord_inventory_snapshots`
Stores inventory key/type/owner, slot and weight limits, reason/creator, full item payload and creation timestamp for recovery workflows.

### `nord_inventory_forensics_alerts`
Stores Anti-Dupe findings with severity, code, identity value, item, payload, open/resolved status and timestamps.

### `nord_inventory_placed_items`
Maps a persistent world placement ID to its inventory key, owner identifier, coordinates, model and timestamps. The inventory contents themselves continue to use normal Nord Inventory storage.

All three are created with `CREATE TABLE IF NOT EXISTS`; v2.0.0 does not drop or rewrite existing inventory tables during this migration.