Silverbridge2

Tables (10)

ChatMessage

  • message_id — BIGINT — Primary key — NOT NULL
  • session_id — BIGINT — Foreign key → ChatSession.session_id — NOT NULL
  • role — VARCHAR(20) — NOT NULL
  • content — TEXT
  • emotion_type — VARCHAR(30)
  • confidence — FLOAT
  • created_at — DATETIME

ChatSession

  • session_id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → User.user_id
  • region_code — VARCHAR(10) — NOT NULL
  • created_at — DATETIME
  • updated_at — DATETIME

ResponseSetting

  • setting_id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → User.user_id — NOT NULL
  • response_tone — VARCHAR(50)
  • region_code — VARCHAR(10)
  • speech_speed — FLOAT
  • volume_level — INT
  • updated_at — DATETIME

Role

  • role_id — INT — Primary key — NOT NULL
  • role_name — VARCHAR(50)

Schedule

  • schedule_id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → User.user_id — NOT NULL
  • calendar_id — INT — Foreign key → calendar.calendar_id — NOT NULL
  • title — VARCHAR(100) — NOT NULL
  • description — TEXT
  • alarm_time — DATETIME
  • created_at — DATETIME
  • updated_at — DATETIME

TextVoiceConversionLog

  • log_id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → User.user_id
  • input_type — VARCHAR(20)
  • input_content — TEXT
  • output_type — VARCHAR(20)
  • output_content — TEXT
  • converted_at — DATETIME

User

  • user_id — BIGINT — Primary key — NOT NULL
  • nickname — VARCHAR(50)
  • role_id — INT — Foreign key → Role.role_id — NOT NULL
  • name — VARCHAR(50)
  • email — VARCHAR(100)
  • password — VARCHAR(100)
  • birth — INT
  • registered_at — DATETIME
  • social — BOOLEAN
  • gender — BOOLEAN
  • phone_number — VARCHAR(20)
  • region — VARCHAR(50)

UserSetting

  • setting_id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → User.user_id — NOT NULL
  • text_size — FLOAT
  • updated_at — DATETIME

VoiceCommand

  • command_id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → User.user_id — NOT NULL
  • command_text — TEXT — NOT NULL
  • created_at — DATETIME
  • command_tone — VARCHAR(50)

calendar

  • calendar_id — INT — Primary key — NOT NULL
  • date — DATE