Query

data — OrderItem

SQL

CREATE TABLE "OrderItem"  (
  "id" integer PRIMARY KEY,
  "order_id" integer NOT NULL REFERENCES "Order" ("id"),
  "reward_id" integer NOT NULL REFERENCES "Reward" ("id"),
  "quantity" integer NOT NULL,
  "unit_price" integer NOT NULL,
  "line_subtotal" integer NOT NULL,
  "line_shipping_total" integer NOT NULL,
  "line_total" integer NOT NULL
)

+ 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
quantity INTEGER Rename | Drop
unit_price INTEGER Rename | Drop
line_subtotal INTEGER Rename | Drop
line_shipping_total INTEGER Rename | Drop
line_total INTEGER Rename | Drop

Foreign Keys

Column Destination
reward_id Reward.id
order_id Order.id

+ Add index

Indexes

Name Columns Unique SQL Drop?
order_reward_unique
  • order_id
  • reward_id
 ✓ SQL 
CREATE UNIQUE INDEX "order_reward_unique"
ON "OrderItem" ("order_id", "reward_id")
Drop