foraa

Tables (5)

User (유저)

  • userId (Key) — Long — Primary key — NOT NULL
  • chatRoomId (Field) — UUID
  • Field2

chat_messgae (채팅 메시지)

  • chat_messageId (Key) — Lon g — Primary key — NOT NULL
  • sender_type (발신자) — ENum
  • content (내용) — TEXT
  • createdAt (Field2) — LocalDateTime
  • Field3
  • chunk_id (id) — String — Foreign key → strategy.chunk_id — NOT NULL
  • emotion (감정)
  • userId (Key2) — Long — Foreign key → User.userId — NOT NULL

emotion (감정)

    strategy (전략)

    • chunk_id (id) — String — Primary key — NOT NULL
    • skill_type (Field) — String
    • skill_name (Field2) — String
    • description (설명) — TEXT

    strategy_record (전략 기록)

    • id (Key) — Primary key — NOT NULL
    • chunk_id (id) — String — Foreign key → strategy.chunk_id — NOT NULL
    • effect (효과) — enum
    • createdAt (Field2) — LocalDateTime
    • userId (Key2) — Long — Foreign key → User.userId — NOT NULL