3차

테이블 (4)

ai_conversation

  • id — BIGINT
  • user_id — BIGINT — NOT NULL
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

ai_message

  • id — BIGINT
  • conversation_id — BIGINT — NOT NULL
  • sender — ENUM('USER', 'AI') — NOT NULL
  • message — TEXT — NOT NULL
  • created_at — TIMESTAMP

member

  • id — BIGINT
  • provider — VARCHAR(20) — NOT NULL
  • provider_id — VARCHAR(255) — NOT NULL
  • name — VARCHAR(100)
  • email — VARCHAR(255)
  • profile_image — VARCHAR(500)

schedule

  • schedule_id — BIGINT
  • title — VARCHAR(50) — NOT NULL
  • content — TEXT
  • start — DATETIME — NOT NULL
  • end — DATETIME
  • location — VARCHAR(255)