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.