SQL
CREATE TABLE commission_rates (
category TEXT PRIMARY KEY,
rate_bps INTEGER NOT NULL DEFAULT 500,
updated_at TEXT NOT NULL DEFAULT (datetime('now'))
)
Columns
| Column | Data type | Allow null | Primary key | Actions |
|---|---|---|---|---|
category |
TEXT |
✓ | ✓ | Rename | Drop |
rate_bps |
INTEGER |
Rename | Drop | ||
updated_at |
TEXT |
Rename | Drop |
Indexes
| Name | Columns | Unique | SQL | Drop? |
|---|---|---|---|---|
| sqlite_autoindex_commission_rates_1 |
category
|
✓ | SQL | Drop |