project

Tables (4)

cart (Untitled4)

  • cart_id (card id) — BIGINT — Primary key — NOT NULL
  • user_id (user id) — BIGINT — Foreign key → user.user_id — NOT NULL
  • product_id (product id) — BIGINT — Foreign key → product.product_id — NOT NULL

cart_item (Untitled3)

  • cart_item_id (cart item id) — BIGINT — Primary key — NOT NULL
  • cart_id (card id) — BIGINT — Foreign key → cart.cart_id — NOT NULL
  • user_id (user id) — BIGINT — Foreign key → cart.user_id — NOT NULL
  • product_id (product id) — BIGINT — Foreign key → cart.product_id — NOT NULL
  • cart_date (카트 담은 최종날짜) — DATETIME
  • cart_stock (카트 담은 수량) — BIGINT

product (Untitled2)

  • product_id (product id) — BIGINT — Primary key — NOT NULL
  • product_name (제품 이름) — varchar
  • product_price (제품 가격) — BIGINT
  • product_info (제품 정보) — varchar
  • product_stock (제품 남은 수량) — BIGINT

user (Untitled)

  • user_id (user id) — BIGINT — Primary key — NOT NULL
  • ID (사용자 ID) — varchar
  • password (사용자 비밀번호) — varchar
  • email (사용자 이메일) — carchar
  • enrolled_date (가입 날짜) — DATETIME