customer_metadata

Description

Key-value metadata for customers.

Table Definition

CREATE TABLE customer_metadata (
    id TEXT PRIMARY KEY,
    customer_id TEXT NOT NULL REFERENCES customers(id),
    key TEXT NOT NULL,
    value TEXT NOT NULL DEFAULT ''
)

Columns

Name	Type	Default	Nullable	Parents	Comment
customer_id	TEXT		false	customers	FK to customers.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 (customer_id) REFERENCES customers (id) ON UPDATE NO ACTION ON DELETE NO ACTION MATCH NONE
id	PRIMARY KEY	PRIMARY KEY (id)
sqlite_autoindex_customer_metadata_1	PRIMARY KEY	PRIMARY KEY (id)

Indexes

Name	Definition
idx_customer_metadata_unique	CREATE UNIQUE INDEX idx_customer_metadata_unique ON customer_metadata(customer_id, key)
sqlite_autoindex_customer_metadata_1	PRIMARY KEY (id)

Relations

erDiagram

"customer_metadata" }o--|| "customers" : "FOREIGN KEY (customer_id) REFERENCES customers (id) ON UPDATE NO ACTION ON DELETE NO ACTION MATCH NONE"
"customer_metadata" }o--|| "customers" : "customer_metadata.customer_id -> customers.id"

"customer_metadata" {
  TEXT customer_id FK "FK to customers.id"
  TEXT id PK "UUID primary key"
  TEXT key "Metadata key"
  TEXT value "Metadata value"
}
"customers" {
  TEXT created_at "Timestamp when the customer was created"
  TEXT id PK "UUID primary key"
  TEXT max_balance_amount "Maximum allowed balance amount (empty = no limit)"
  TEXT max_balance_commodity "Commodity for the max balance constraint"
  TEXT name "Customer name (unique)"
}

Generated by tbls