Osan
Tables (7)
volume_settings (volume_setting)
- volume_setting_id — LONG — Primary key — NOT NULL
- bird_volume — LONG
- cricket_volume — LONG
- dingdong_volume — LONG
- female_volume — LONG
- male_volume — LONG
- minuet_volume — LONG
- system_volume — LONG
app_user
- user_id — LONG — Primary key — NOT NULL
- username — VARCHAR(50) — NOT NULL
- password_hash — VARCHAR(255) — NOT NULL
- salt — VARCHAR(50) — NOT NULL
- role — VARCHAR(20)
- is_active — BOOLEAN
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
sensor
- sensor_id — LONG — Primary key
- group_id — VARCHAR(50) — Foreign key → sensor_group.group_id — NOT NULL
- device_number — VARCHAR(50) — NOT NULL
- deviceId — DOUBLE
- longitude — DOUBLE
- position_signal_strength — LONG
- position_signal_threshold — LONG
- communication_signal_strength — LONG
- communication_signal_threshold — LONG
- wireless_235_strength — LONG
- device_settings — _TEXT
- volume_setting_id — LONG — Foreign key → volume_settings.volume_setting_id — NOT NULL
- silent_setting_id — LONG — Foreign key → silent_settings.silent_setting_id — NOT NULL
- communication_interval — LONG
- fault_information — VARCHAR
- sw_version — LONG
- hw_version — LONG
- button_count — LONG
- position_guide_count — LONG
- signal_guide_count — LONG
- group_position_number — LONG
sensor_group (group)
- group_id — VARCHAR(50) — Primary key — NOT NULL — remoteCSE ID
- group_key — VARCHAR(50) — NOT NULL — 묶음 관리 번호
- sensor_count — LONG
- fault_count — LONG
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
sensor_log
- log_id — SERIAL — Primary key
- sensor_id — LONG — Foreign key → sensor.sensor_id
- event_code — VARCHAR(50)
- event_details — JSONB
- created_at — TIMESTAMP
silent_settings
- silent_setting_id — LONG — Primary key — NOT NULL
- female_mute1 — LONG
- female_mute2 — LONG
- male_mute1 — LONG
- male_mute2 — LONG
user_group
- user_id — LONG — Foreign key → app_user.user_id — NOT NULL
- group_id — LONG — Foreign key → sensor_group.group_id — NOT NULL