test

Tables (3)

USER (유저 테이블)

  • user_id (유저 아이디) — BIGINT — Primary key — NOT NULL

cart (Untitled)

  • cart_id (Key) — BIGINT — Primary key — NOT NULL
  • user_id (유저 아이디) — BIGINT — Foreign key → USER.user_id — NOT NULL
  • product_id (상품 아이디) — BIGINT — Foreign key → product.product_id — NOT NULL
  • quantity (수량) — INT
  • checked (Field3) — BINARY

product (상품 테이블)

  • product_id (상품 아이디) — BIGINT — Primary key — NOT NULL