Itmomdan_담았소

테이블 (3)

alarm_settings (소음 알람)

  • setting_id (PK) — INT — 기본 키 — NOT NULL
  • user_id (PK2) — INT — 외래 키 → users.user_id — NOT NULL
  • noise_type (Field2) — TIMESTMAP
  • alarm_distance (Field3) — VARCHAR
  • alarm_db (Field4) — VARCHAR
  • sensitivity_level (Field) — TEXT

classification_results (데시벨)

  • result_id (Key) — 기본 키 — NOT NULL
  • user_id (PK2) — INT — 외래 키 → users.user_id — NOT NULL
  • noise_type (Field) — VARCHAR
  • spl_peak (Field2)
  • spl_rms (Field3)
  • estimated_distance (Field4)
  • direction (Field6)
  • timestamp (Field7) — DATETIME
  • alarm_triggered (Field8) — BOOLEAN

users (회원)

  • user_id (PK) — INT — 기본 키 — NOT NULL
  • username (Field7)
  • password (Field8)
  • name (Field) — Varchar
  • phone_num (Field3) — INT
  • email (Field2) — Varchar
  • guardian_email (Field4) — Varchar
  • age (Field5)
  • usage_purpose (Field6)