commodity_metadata

Description

Key-value metadata for commodities.

Table Definition

CREATE TABLE commodity_metadata (
    id TEXT PRIMARY KEY,
    commodity_id TEXT NOT NULL REFERENCES commodities(id),
    key TEXT NOT NULL,
    value TEXT NOT NULL DEFAULT ''
)

Columns

Name	Type	Default	Nullable	Parents	Comment
commodity_id	TEXT		false	commodities	FK to commodities.id
id	TEXT		true		UUID primary key
key	TEXT		false		Metadata key
value	TEXT	''	false		Metadata value

Constraints

Name	Type	Definition
- (Foreign key ID: 0)	FOREIGN KEY	FOREIGN KEY (commodity_id) REFERENCES commodities (id) ON UPDATE NO ACTION ON DELETE NO ACTION MATCH NONE
id	PRIMARY KEY	PRIMARY KEY (id)
sqlite_autoindex_commodity_metadata_1	PRIMARY KEY	PRIMARY KEY (id)

Indexes

Name	Definition
idx_commodity_metadata_unique	CREATE UNIQUE INDEX idx_commodity_metadata_unique ON commodity_metadata(commodity_id, key)
sqlite_autoindex_commodity_metadata_1	PRIMARY KEY (id)

Relations

erDiagram

"commodity_metadata" }o--|| "commodities" : "FOREIGN KEY (commodity_id) REFERENCES commodities (id) ON UPDATE NO ACTION ON DELETE NO ACTION MATCH NONE"
"commodity_metadata" }o--|| "commodities" : "commodity_metadata.commodity_id -> commodities.id"

"commodity_metadata" {
  TEXT commodity_id FK "FK to commodities.id"
  TEXT id PK "UUID primary key"
  TEXT key "Metadata key"
  TEXT value "Metadata value"
}
"commodities" {
  TEXT code "Unique commodity code (e.g. GBP, USD, BTC)"
  TEXT created_at "Timestamp when the commodity was created"
  TEXT datetime "Optional date associated with the commodity definition"
  INTEGER exponent "Decimal exponent for amount precision (-2 = pence, -8 = satoshi)"
  TEXT id PK "UUID primary key"
}

Generated by tbls