Query

data — Order

Add Column

Cancel

Current Schema

CREATE TABLE "Order"  (
  "id" integer PRIMARY KEY,
  "user_id" integer NOT NULL REFERENCES "User" ("id"),
  "shipping_address_id" integer REFERENCES "ShippingAddress" ("id"),
  "project_id" integer NOT NULL,
  "status" text NOT NULL,
  "payment_method" text NOT NULL,
  "provider" text NOT NULL,
  "order_subtotal" integer NOT NULL,
  "order_shipping_total" integer NOT NULL,
  "order_total" integer NOT NULL,
  "order_total_with_fees" integer NOT NULL,
  "service_fee" integer NOT NULL,
  "shipping_type" text NOT NULL,
  "refunded" integer NOT NULL,
  "is_cancellable" integer NOT NULL,
  "created_at" text NOT NULL,
  "labeled" integer NOT NULL DEFAULT FALSE,
  "packed" integer NOT NULL DEFAULT FALSE,
  "sent" integer NOT NULL DEFAULT FALSE,
  "problem" integer NOT NULL DEFAULT FALSE,
  "notes" text NOT NULL DEFAULT '',
  "support" text NOT NULL DEFAULT '',
  "checked" integer NOT NULL DEFAULT FALSE
)