Project
Tables (7)
audio_data
- audio_id — BIGINT — Primary key — NOT NULL
- audio_path — VARCHAR(255) — NOT NULL
family_voice_data
- family_voice_id — BIGINT — Primary key — NOT NULL
- family_member_name — VARCHAR(100) — NOT NULL
- voice_data_path — VARCHAR(255) — NOT NULL
gas_sensor_data
- gas_sensor_id — BIGINT — Primary key — NOT NULL
- gas_value — FLOAT — NOT NULL
mel_spectrogram_image
- mel_image_id — BIGINT — Primary key — NOT NULL
- audio_id — BIGINT — Foreign key → audio_data.audio_id — NOT NULL
- mel_image_path — VARCHAR(255) — NOT NULL
speech_text_data
- speech_text_id — BIGINT — Primary key — NOT NULL
- audio_id — BIGINT — Foreign key → audio_data.audio_id — NOT NULL
- speech_text — TEXT — NOT NULL
video_data
- video_id — BIGINT — Primary key — NOT NULL
- video_path — VARCHAR(255) — NOT NULL
video_text_data
- video_text_id — BIGINT — Primary key — NOT NULL
- video_id — BIGINT — Foreign key → video_data.video_id — NOT NULL
- video_text — TEXT — NOT NULL