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)