Homemade-snacks

테이블 (3)

상품 (products)

  • product_id — BIGINT — 기본 키
  • name — VARCHAR(255) — NOT NULL — 4
  • description — TEXT
  • total_quantity — INT — NOT NULL
  • remaining_quantity — INT — NOT NULL
  • created_at — TIMESTAMP

예약 (reservations)

  • reservation_id — BIGINT — 기본 키
  • user_id (user_id2) — BIGINT — 외래 키 → 회원.user_id
  • product_id (product_id2) — BIGINT — 외래 키 → 상품.product_id
  • status — VARCHAR(20)
  • reserved_at — TIMESTAMP

회원 (users)

  • user_id — BIGINT — 기본 키
  • email — VARCHAR(255) — NOT NULL
  • password — VARCHAR(255)
  • name — VARCHAR(100) — NOT NULL
  • provider — VARCHAR(50)
  • provider_id — VARCHAR(255)
  • role — VARCHAR(20)