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