Field Constraints
NN
NOT NULL - Field cannot be empty
Example: id, wallet, amount
Example: id, wallet, amount
UQ
UNIQUE - Field value must be unique
Example: username, email, payment_hash
Example: username, email, payment_hash
FK
FOREIGN KEY - Links to another table
Example: wallet → Wallet.id
Example: wallet → Wallet.id
PK
PRIMARY KEY - Unique identifier
Example: id (UUID4)
Example: id (UUID4)
JSON
JSON data structure
Hover for details
Hover for details