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