SQL

CREATE TABLE payment_status_changes  (
  id INTEGER PRIMARY KEY AUTOINCREMENT,
  patrocinio_id INTEGER NOT NULL REFERENCES patrocinios(id) ON DELETE CASCADE,
  old_status TEXT,
  new_status TEXT NOT NULL,
  changed_by INTEGER REFERENCES users(id) ON DELETE SET NULL,
  created_at TEXT NOT NULL DEFAULT (datetime('now','localtime'))
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id INTEGER ✓ ✓ Rename | Drop
patrocinio_id INTEGER Rename | Drop
old_status TEXT ✓ Rename | Drop
new_status TEXT Rename | Drop
changed_by INTEGER ✓ Rename | Drop
created_at TEXT Rename | Drop

Foreign Keys

Column Destination
changed_by users.id
patrocinio_id patrocinios.id

+ Add index

Indexes

Name Columns Unique SQL Drop?
idx_psc_patrocinio patrocinio_id SQL 
CREATE INDEX idx_psc_patrocinio
ON payment_status_changes(patrocinio_id)
Drop