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