shop

Tables (7)

Cart (cart)

  • Key (id) — bigint(20) — Primary key — NOT NULL
  • Key (id2) — bigint — Foreign key → Untitled2.Key — NOT NULL

CartItem (cart_item)

  • Key (id) — bigint — Primary key — NOT NULL
  • Key (id2) — bigint(20) — Foreign key → Cart.Key — NOT NULL
  • Key (id3) — bigint — Foreign key → Copy Of Untitled26.Key — NOT NULL

Copy Of Untitled2 (order)

  • Key (id) — bigint — Primary key — NOT NULL
  • Field (order_date) — datetime
  • Field (order_status) — enum

Copy Of Untitled24 (item_img)

  • Key (id) — bigint — Primary key — NOT NULL
  • Field (original_img_name) — varchar(255)
  • Field (imgName) — varchar(255)
  • Field (img_url) — varchar(255)
  • Field (rep_img_yn) — varchar(5)
  • Key (item_id) — bigint — Foreign key → Copy Of Untitled26.Key — NOT NULL

Copy Of Untitled25 (order_item)

  • Key (item_id) — bigint — Foreign key → Copy Of Untitled26.Key — NOT NULL
  • Key (order_id) — bigint — Foreign key → Copy Of Untitled2.Key — NOT NULL
  • Field (order_price) — int
  • Field (count) — int

Copy Of Untitled26 (item)

  • Key (id) — bigint — Primary key — NOT NULL
  • Field (item_named) — varchar
  • Field (price) — int
  • Field (stock_number) — int
  • Field (item_detail) — blob

Untitled2 (member)

  • Key (id) — bigint — Primary key — NOT NULL
  • Field (name) — varchar(50)
  • Field (email) — vahchar(255)
  • Field (password) — varchar(255)
  • Field (role) — enum