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)