shoping_erd

Tables (6)

cart

  • 장바구니ID (carrier_id) — BIGINT — Primary key — NOT NULL
  • 회원ID (user_id) — BIGINT — Primary key — NOT NULL
  • 상품옵션ID (item_opt) — BIGINT — Primary key — NOT NULL
  • 장바구니 수량 (item_id) — BIGINT — NOT NULL

order_items

  • 주문내역ID (order_etc) — BIGINT — Primary key — NOT NULL
  • 상품옵션ID (item_opt) — BIGINT — Primary key — NOT NULL
  • 주문ID (order_id) — BIGINT — Primary key — NOT NULL
  • 주문수량 (order_num) — BIGINT — NOT NULL

orders

  • 주문ID (order_id) — BIGINT — Primary key — NOT NULL
  • 회원ID (user_id) — BIGINT — Primary key — NOT NULL
  • 주문시간 (order_time) — DATETIME — NOT NULL

product_options

  • 상품옵션ID (item_opt) — BIGINT — Primary key — NOT NULL
  • 상품ID (item_id) — BIGINT — Primary key — NOT NULL
  • 옵션 재고 (item_num) — BIGINT
  • 가격 (item_price) — BIGINT — NOT NULL

products

  • 상품ID (item_id) — BIGINT — Primary key — NOT NULL
  • 상품명 (item_name) — VARCHAR(255) — NOT NULL

users

  • 회원ID (user_id) — BIGINT — Primary key — NOT NULL
  • 이름 (name) — VARCHAR(150) — NOT NULL
  • 이메일 (email) — TEXT — NOT NULL
  • 패스워드 (passwd) — VARCHAR(255) — NOT NULL
  • 주소 (address) — VARCHAR(255)
  • 회원유형 (usertype) — ENUM('member','superuser') — NOT NULL