Query

data — OrderItem

+/- table definition

Query 

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
)
Use Shift + Up/Down to navigate recently-executed queries
delete expression index : create index : drop insert select : advanced select table : alter table : create table : drop trigger : create trigger : drop update upsert view : create view : drop