thkimshop

Tables (10)

Untitled (item)

  • Key (item_id) — int — Primary key — NOT NULL
  • Field (name)
  • Field2 (price)
  • Field (stock_quantity)
  • Field (dtype)

Untitled (album)

  • Key (album_id) — Primary key — NOT NULL
  • Key (item_id) — int — Foreign key → Untitled.Key — NOT NULL
  • Field (artist)
  • Field (etc)

Untitled (movie)

  • Key2 (movie_id) — Primary key — NOT NULL
  • Key (item_id) — int — Foreign key → Untitled.Key — NOT NULL
  • Field (director)
  • Field (actor)

Untitled (book)

  • Key (book_id) — Primary key — NOT NULL
  • Key (item_id) — int — Foreign key → Untitled.Key — NOT NULL
  • Field (author)
  • Field (isbn)

Untitled (order)

  • Key (oder_id) — int — Primary key — NOT NULL
  • Key (delivery_id) — Foreign key → Untitled.Key — NOT NULL
  • Field (status)
  • Field2 (order_date)
  • user_id — int — Foreign key → user.user_id — NOT NULL

Untitled (order_item)

  • Key (order_item_id) — Primary key — NOT NULL
  • Key (oder_id) — int — Foreign key → Untitled.Key — NOT NULL
  • Key (item_id) — int — Foreign key → Untitled.Key — NOT NULL
  • Field (price)
  • Field2 (count)

Untitled (category)

  • Key (category_id) — Primary key — NOT NULL
  • Field (parent_id)
  • Field (name)

Untitled (category_item)

  • Key (category_id) — Foreign key → Untitled.Key — NOT NULL
  • Key (item_id) — int — Foreign key → Untitled.Key — NOT NULL

Untitled (delivery)

  • Key (delivery_id) — Primary key — NOT NULL
  • Field (status)
  • Field2 (city)
  • Field (street)
  • Field (zipcode)

user (member)

  • user_id (member_id) — int — Primary key — NOT NULL
  • Field (name)
  • Field2 (phone)
  • Field3 (email)
  • Field (city)
  • Field2 (street)
  • Field3 (zipcode)