project1

Tables (6)

address (Untitled4)

  • city (Field) — varchar
  • zipcode (Field2) — varchar
  • street (Field3)

delivery (Untitled6)

  • Key — Primary key — NOT NULL
  • Field

item (Untitled2)

  • item_id (Key) — Long — Primary key — NOT NULL
  • name (Field) — varchar
  • price (Field2) — integer
  • created_at (Field3) — timestamp
  • updated_at (Field4) — timestamp
  • quantity (Field5) — integer
  • contents (Field6) — varchar

order (Untitled3)

  • order_id (Key) — Long — Primary key — NOT NULL
  • status (Field) — varchar
  • created_at (Field2) — timestamp
  • updated_at (Field3) — timestamp

order_item (Untitled5)

  • orderItem_id (Key) — Primary key — NOT NULL
  • Field

user (Untitled)

  • user_id (Key) — Long — Primary key — NOT NULL
  • name (Field) — varchar
  • password (Field2) — varchar
  • created_at (Field3) — timestamp
  • updated_at (Field4) — timestamp
  • email (Field5) — varchar
  • is_deleted (Field6) — boolean
  • address (Field7) — address