movement_metadata

Description

Key-value metadata for movement batches.

Table Definition

CREATE TABLE movement_metadata (
    id TEXT PRIMARY KEY,
    batch_id TEXT NOT NULL,
    key TEXT NOT NULL,
    value TEXT NOT NULL DEFAULT ''
)

Columns

Name	Type	Default	Nullable	Comment
batch_id	TEXT		false	Movement batch ID
id	TEXT		true	UUID primary key
key	TEXT		false	Metadata key
value	TEXT	''	false	Metadata value

Constraints

Name	Type	Definition
id	PRIMARY KEY	PRIMARY KEY (id)
sqlite_autoindex_movement_metadata_1	PRIMARY KEY	PRIMARY KEY (id)

Indexes

Name	Definition
idx_movement_metadata_unique	CREATE UNIQUE INDEX idx_movement_metadata_unique ON movement_metadata(batch_id, key)
sqlite_autoindex_movement_metadata_1	PRIMARY KEY (id)

Relations

erDiagram


"movement_metadata" {
  TEXT batch_id "Movement batch ID"
  TEXT id PK "UUID primary key"
  TEXT key "Metadata key"
  TEXT value "Metadata value"
}

Generated by tbls