boimaru

Tables (7)

Cart

  • cartId (cart_id) — NOT NULL — Primary key — NOT NULL
  • memberId (member_id) — NOT NULL — Foreign key → Member.memberId — NOT NULL

CartItem

  • cartItemId (cart_item_id) — NOT NULL — Primary key — NOT NULL
  • cartId (cart_id) — NOT NULL — Foreign key → Cart.cartId — NOT NULL
  • itemId (item_id) — NOT NULL — Foreign key → Item.itemId — NOT NULL
  • memberId (member_id2) — NOT NULL — Foreign key → Cart.memberId — NOT NULL
  • count

Item

  • itemId (item_id) — NOT NULL — Primary key — NOT NULL
  • itemName (item_name) — NOT NULL
  • price — NOT NULL
  • stockNumber (number) — NOT NULL
  • itemDetail (item_detail) — NOT NULL
  • ItemSellStatus (item_sell_status) — enum

ItemImg

  • itemImgId (item_img_id) — NOT NULL — Primary key — NOT NULL
  • itemId (item_id) — NOT NULL — Foreign key → Item.itemId — NOT NULL
  • imgName (img_name) — NOT NULL
  • oriImgName (ori_img_name) — NOT NULL
  • imgUrl (img_url) — NOT NULL
  • repImgYn (rep_img_yn)

Member

  • memberId (member_id) — NOT NULL — Primary key — NOT NULL
  • name — NOT NULL
  • email — UNIQUE
  • password — NOT NULL
  • address — NOT NULL
  • role — enum

Order

  • orderId (order_Id) — NOT NULL — Primary key — NOT NULL
  • memberId (member_id) — NOT NULL — Foreign key → Member.memberId — NOT NULL
  • orderItems (order_items)
  • orderDate (order_date) — date
  • orderStatus (order_status) — enum

OrderItem

  • orderItemId (order_item_id) — NOT NULL — Primary key — NOT NULL
  • orderId (order_Id) — NOT NULL — Foreign key → Order.orderId — NOT NULL
  • itemId (item_id) — NOT NULL — Foreign key → Item.itemId — NOT NULL
  • orderPrice (order_price) — NOT NULL
  • count