Query

data — ShippingAddress

SQL

CREATE TABLE "ShippingAddress"  (
  "id" integer PRIMARY KEY,
  "user_id" integer NOT NULL REFERENCES "User" ("id"),
  "first_name" text NOT NULL,
  "last_name" text NOT NULL,
  "address1" text NOT NULL,
  "address2" text,
  "city" text NOT NULL,
  "postal_code" text NOT NULL,
  "state" text,
  "country" text NOT NULL,
  "phone_number" text,
  "delivery_type" text NOT NULL,
  "dropoff_id" text,
  "dropoff_name" text,
  "latitude" integer,
  "longitude" integer
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id INTEGER ✓ ✓ Rename | Drop
user_id INTEGER Rename | Drop
first_name TEXT Rename | Drop
last_name TEXT Rename | Drop
address1 TEXT Rename | Drop
address2 TEXT ✓ Rename | Drop
city TEXT Rename | Drop
postal_code TEXT Rename | Drop
state TEXT ✓ Rename | Drop
country TEXT Rename | Drop
phone_number TEXT ✓ Rename | Drop
delivery_type TEXT Rename | Drop
dropoff_id TEXT ✓ Rename | Drop
dropoff_name TEXT ✓ Rename | Drop
latitude INTEGER ✓ Rename | Drop
longitude INTEGER ✓ Rename | Drop

Foreign Keys

Column Destination
user_id User.id

+ Add index

Indexes

Name Columns Unique SQL Drop?