ERD

Tables (7)

Untitled (ORDERS)

  • Key (ORDER_ID) — varchar — Primary key — NOT NULL
  • Field (orderdate) — date
  • Field (status) — varchar
  • Key (memver_id) — varchar — Foreign key → Untitled.Key — NOT NULL
  • Key (delivery_id) — varchar — Foreign key → Untitled.Key — NOT NULL

Untitled (member)

  • Key (memver_id) — varchar — Primary key — NOT NULL
  • Field (name) — varchar
  • Field (city) — varchar
  • Field (street) — varchar
  • Field (ziocode) — varchar

Untitled (delivery)

  • Key (delivery_id) — varchar — Primary key — NOT NULL
  • Field (street) — varchar
  • Field (zipcode) — varchar
  • Field (status) — varchar
  • Key (ORDER ID) — varchar — NOT NULL

Untitled (order_item)

  • Key (order_item_id) — varchar — Primary key — NOT NULL
  • Field (orderprice) — number
  • Field (count) — number
  • Key (ORDER_ID) — varchar — Foreign key → Untitled.Key — NOT NULL
  • Key (item_id2) — varchar — Foreign key → Untitled.Key — NOT NULL

Untitled (category)

  • Key (gategory_id) — varchar — Primary key — NOT NULL
  • Field (name) — varchar

Untitled (item)

  • Key (item_id) — varchar — Primary key — NOT NULL
  • Field (name) — varchar
  • Field (price) — number
  • Field (stockquantity) — number

Untitled (category_item)

  • Key (item_id) — varchar — Foreign key → Untitled.Key — NOT NULL
  • Key (gategory_id) — varchar — Foreign key → Untitled.Key — NOT NULL