Query

billing.db — agent_balances

SQL

CREATE TABLE agent_balances  (
  id INTEGER PRIMARY KEY AUTOINCREMENT,
  agent_id INTEGER NOT NULL,
  balance DECIMAL(15,2) DEFAULT 0.00,
  last_updated DATETIME DEFAULT CURRENT_TIMESTAMP,
  FOREIGN KEY (agent_id) REFERENCES agents(id) ON DELETE CASCADE
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id INTEGER ✓ ✓ Rename | Drop
agent_id INTEGER Rename | Drop
balance DECIMAL(15,2) ✓ Rename | Drop
last_updated DATETIME ✓ Rename | Drop

Foreign Keys

Column Destination
agent_id agents.id

+ Add index

Indexes

Name Columns Unique SQL Drop?
idx_agent_balances_agent_id agent_id SQL 
CREATE INDEX idx_agent_balances_agent_id
ON agent_balances(agent_id)
Drop