Shop
Tables (8)
cart (Untitled)
- cart_id (Key) — Primary key — NOT NULL
- member_id (Key2) — Foreign key → member.member_id — NOT NULL
cart_item (Untitled3)
- cart_item_id (Key) — Primary key — NOT NULL
- cart_id (Key2) — Foreign key → cart.cart_id — NOT NULL
- count (Field)
- item_id (Key3) — Foreign key → item.item_id — NOT NULL
item (Untitled4)
- item_id (Key) — Primary key — NOT NULL
- itemNm (Field)
- price (Field2)
- stockNumber (Field3)
- itemDetail (Field4)
- itemSellStatus (Field5)
item_img (Untitled8)
- item_img_id (Key) — Primary key — NOT NULL
- imgName (Field)
- oriImgName (Field2)
- imgUrl (Field3)
- repimgYn (Field4)
- item_id (Key2) — Foreign key → item.item_id — NOT NULL
member (Untitled2)
- member_id (Key) — Primary key — NOT NULL
- name (Field)
- email (Field2)
- password (Field3)
- address (Field4)
- role (Field5)
member_item (Untitled7)
- member_item_id (Key) — Primary key — NOT NULL
- Field
- member_id (Key2) — Foreign key → member.member_id — NOT NULL
- item_id (Key3) — Foreign key → item.item_id — NOT NULL
order_item (Untitled6)
- order_item_id (Key) — Primary key — NOT NULL
- orderPrice (Field)
- count (Field2)
- order_id (Key2) — Foreign key → orders.order_id — NOT NULL
- item_id (Key3) — Foreign key → item.item_id — NOT NULL
orders (Untitled5)
- order_id (Key) — Primary key — NOT NULL
- member_id (Key2) — Foreign key → member.member_id — NOT NULL
- order_date (Field)
- order_status (Field2)