AI-Crowd_ERD

Tables (10)

ADM_Admin_Info

  • admin_id — BIGINT
  • type — VARCHAR(20) — NOT NULL
  • status — VARCHAR(20)
  • jwt_token — TEXT
  • token_issued_at — TIMESTAMPTZ
  • organization — VARCHAR(50)
  • name — VARCHAR(50) — NOT NULL
  • position — VARCHAR(50)
  • number — VARCHAR(30)
  • email — VARCHAR(50)
  • approver_id — BIGINT
  • created_at — TIMESTAMPTZ
  • approved_at — TIMESTAMPTZ

ADM_SOS_Action

  • admin_id — BIGINT — Primary key — NOT NULL
  • sos_log_id — UUID — Primary key — NOT NULL
  • action — VARCHAR(20) — NOT NULL
  • received_at — TIMESTAMPTZ
  • done_at — TIMESTAMPTZ

ADM_System_Log

  • user_log_id — BIGINT
  • admin_id — BIGINT
  • action_type — VARCHAR(50) — NOT NULL
  • details — TEXT
  • created_at — TIMESTAMPTZ
  • login_time — TIMESTAMP

APP_SOS_Log

  • sos_log_id — UUID
  • user_uuid — UUID — NOT NULL
  • latitude — DOUBLE — NOT NULL
  • longitude — DOUBLE — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • received_at — TIMESTAMPTZ
  • accepted_at — TIMESTAMPTZ
  • done_at — TIMESTAMPTZ

APP_User_Info

  • user_uuid — UUID
  • fcm_token — TEXT
  • app_version — VARCHAR(10)
  • last_active_at — TIMESTAMPTZ
  • created_at — TIMESTAMPTZ

COM_CCTV

  • cctv_no — UUID
  • cctv_addr — VARCHAR(100)
  • latitude — DOUBLE
  • longitude — DOUBLE
  • stream_url — TEXT
  • status — VARCHAR(50)
  • is_active — BOOLEAN
  • updated_at — TIMESTAMPTZ

COM_Location

  • unique_road_id — BIGINT — Primary key — NOT NULL
  • osmid — JSONB
  • name — VARCHAR(255)
  • dong — VARCHAR(100)
  • hour — INT
  • risk_score — DOUBLE

DAT_Crowd_Detection

  • detection_id — BIGINT
  • cctv_no — UUID
  • detected_at — TIMESTAMPTZ
  • person_count — INT
  • congestion_level — INT
  • risk_level — INT
  • status — VARCHAR(50)
  • cleared_by — BIGINT

DAT_Fall_Event

  • event_id — UUID
  • cctv_no — UUID
  • timestamp — TIMESTAMPTZ — NOT NULL
  • status — VARCHAR(50)
  • cleared_by — BIGINT

DAT_Population_Prediction

  • id — BIGSERIAL
  • datetime_id — VARCHAR(15) — NOT NULL
  • region_id — VARCHAR(50) — NOT NULL
  • target_time — TIMESTAMPTZ — NOT NULL
  • created_at — TIMESTAMPTZ
  • base_date — DATE
  • hour_slot — INT
  • temperature — DOUBLE
  • precipitation — DOUBLE
  • weather_cat — VARCHAR(50)
  • precipitation_type — VARCHAR(50)
  • predicted_population — INT
  • scenario_type — TEXT