fan-fare ERD
Tables (3)
CAKE_TB
- cake_id — BIGINT — Primary key — NOT NULL — Auto Increament
MEMBER_TB
- member_id — BIGINT — Primary key — NOT NULL — Auto Increament
- username — VARCHAR(20) — NOT NULL
- nickname — VARCHAR(20) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- birthday — TIMESTAMP — NOT NULL
MESSAGE_TB
- message_id — BIGINT — Primary key — NOT NULL — Auto Increament
- member_id — BIGINT — Foreign key → MEMBER_TB.member_id — NOT NULL
- cake_id — BIGINT — Foreign key → CAKE_TB.cake_id — NOT NULL
- content — VARCHAR(300) — NOT NULL
- nickname — VARCHAR(20) — NOT NULL
- candle_color — VARCHAR(20) — NOT NULL — 초 색깔 (enum)
- createdAt — TIMESTAMP — NOT NULL