Query

data — Billet

SQL

CREATE TABLE "Billet"  (
  "id" integer PRIMARY KEY,
  "order_id" integer NOT NULL REFERENCES "Order" ("id"),
  "reward_id" integer NOT NULL REFERENCES "Reward" ("id"),
  "billet_sent_at" text
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id INTEGER ✓ ✓ Rename | Drop
order_id INTEGER Rename | Drop
reward_id INTEGER Rename | Drop
billet_sent_at TEXT ✓ Rename | Drop

Foreign Keys

Column Destination
reward_id Reward.id
order_id Order.id

+ Add index

Indexes

Name Columns Unique SQL Drop?