pjt2

Tables (5)

Allergy (allergy)

  • 아이디 (id) — NOT NULL — Primary key — NOT NULL
  • 유저아이디 (user_id) — NOT NULL — Foreign key → User.유저아이디 — NOT NULL
  • 알레르기 이름 (name) — NOT NULL

Cart (cart)

  • 아이디 (id) — NOT NULL — Primary key — NOT NULL
  • 유저아이디 (user_id) — NOT NULL — Foreign key → User.유저아이디 — NOT NULL
  • 물건아이디 (product_id) — NOT NULL — Foreign key → Product.아이디 — NOT NULL

Product (product)

  • 아이디 (id) — NOT NULL — Primary key — NOT NULL
  • 물건이름 (name) — NOT NULL
  • 가격 (price) — NOT NULL
  • 행사정보 (event) — NOT NULL
  • 칼로리 (cal) — NOT NULL
  • 용량 (size) — NOT NULL

User (user)

  • 유저아이디 (id) — NOT NULL — Primary key — NOT NULL
  • 유저이메일 (email) — NOT NULL
  • 유저이름 (name) — NOT NULL
  • 생성일자 (created_at) — NOT NULL

cart_item

  • id — BIGINT — Primary key — NOT NULL
  • cart_id — BIGINT — NOT NULL
  • product_id — BIGINT — NOT NULL
  • quantity — INT — NOT NULL
  • name_snapshot — VARCHAR(255) — NOT NULL
  • price_at_add — DECIMAL(12,2) — NOT NULL
  • added_at — TIMESTAMP — NOT NULL