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