Query

pilot.db — service_student_prices

SQL

CREATE TABLE service_student_prices  (
  id INTEGER PRIMARY KEY AUTOINCREMENT,
  service_id INTEGER NOT NULL REFERENCES services(id) ON DELETE CASCADE,
  student_id INTEGER NOT NULL REFERENCES students(id) ON DELETE CASCADE,
  price_cents INTEGER NOT NULL,
  created_at TEXT NOT NULL DEFAULT (datetime('now')),
  UNIQUE(service_id, student_id)
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id INTEGER ✓ ✓ Rename | Drop
service_id INTEGER Rename | Drop
student_id INTEGER Rename | Drop
price_cents INTEGER Rename | Drop
created_at TEXT Rename | Drop

Foreign Keys

Column Destination
student_id students.id
service_id services.id

+ Add index

Indexes

Name Columns Unique SQL Drop?
idx_ssp_service service_id SQL 
CREATE INDEX idx_ssp_service
ON service_student_prices(service_id)
Drop
idx_ssp_student student_id SQL 
CREATE INDEX idx_ssp_student
ON service_student_prices(student_id)
Drop
sqlite_autoindex_service_student_prices_1
  • service_id
  • student_id
 ✓ SQL
-- no sql found --
 Drop