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