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