삐뽀삐4
테이블 (13)
alert_report
- id — BIGINT — 기본 키 — NOT NULL
- region — VARCHAR(255) — NOT NULL
- disaster_type — ENUM — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
alert_report_user
- Key — BIGINT — 기본 키 — NOT NULL
- alert_id — BIGINT — 외래 키 → alert_report.id — NOT NULL
- user_id — BIGINT — 외래 키 → user.id — NOT NULL
- is_read — boolean — NOT NULL
alert_volunteer
- id — BIGINT — 기본 키 — NOT NULL
- title — VARCHAR(255) — NOT NULL
- content — LONGTEXT — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
alert_volunteer_user
- Key — BIGINT — 기본 키 — NOT NULL
- user_id — BIGINT — 외래 키 → user.id — NOT NULL
- alert_id — BIGINT — 외래 키 → alert_volunteer.id — NOT NULL
- is_read — boolean — NOT NULL
attendace_policy
- id — BIGINT — 기본 키 — NOT NULL
- post_id — BIGINT — 외래 키 → post.id — NOT NULL
- checkin_start — DATETIME — NOT NULL
- checkin_end — DATETIME — NOT NULL
- allowed_radius_m — INT — NOT NULL
- min_stay_minutes — INT — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
post
- id — BIGINT — 기본 키 — NOT NULL
- user_id — BIGINT — 외래 키 → user.id — NOT NULL
- category — ENUM — NOT NULL
- title — VARCHAR(200) — NOT NULL
- content — TEXT — NOT NULL
- total_capacity — INT
- team_size — INT
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
report
- id — BIGINT — 기본 키 — NOT NULL
- reporter_id — BIGINT — 외래 키 → user.id — NOT NULL — 신고하는 자
- disaster_type — ENUM — NOT NULL
- description — LONGTEXT — NOT NULL
- image_url — VARCHAR(2048)
- video_url — VARCHAR(2048)
- status — ENUM — NOT NULL — 대기 / 접수완료 / 상황종료
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
- si — VARCHAR(255) — NOT NULL
- gu — VARCHAR(255) — NOT NULL
- location_lat — DECIMAL(10, 7) — NOT NULL
- location_lng — DECIMAL(10, 7) — NOT NULL
- responder_id — BIGINT — NOT NULL — 신고를 받는 자
user
- id — BIGINT — 기본 키 — NOT NULL
- email — VARCHAR(100) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- login_type — ENUM — NOT NULL
- provider — VARCHAR(255)
- role — ENUM — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
- last_login_at — DATETIME — NOT NULL
user_location
- Redis) — ( `` VARCHAR(255) — Key: location:user:{userId} Value: { "lat": 37.123456, "lng": 127.654321, "timestamp": 1717083900 } TTL: 5분 (300초)
- Field — VARCHAR(255) — key: gu : { 시:구} Value:{userId}
volunteer_location
- id — BIGINT — 기본 키 — NOT NULL
- post_id — BIGINT — 외래 키 → post.id — NOT NULL
- place_name — VARCHAR(200) — NOT NULL
- location_lat — DECIMAL(10,7) — NOT NULL
- location_lng — DECIMAL(10,7) — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
volunteer_participant
- id — BIGINT — 기본 키 — NOT NULL
- team_id — BIGINT — 외래 키 → volunteer_team.id — NOT NULL
- user_id — BIGINT — 외래 키 → user.id — NOT NULL
- joined_at — DATETIME
- checkin_status — ENUM — NOT NULL
volunteer_team
- id — BIGINT — 기본 키 — NOT NULL
- post_id — BIGINT — 외래 키 → post.id — NOT NULL
- team_number — INT — NOT NULL
- max_capacity — INT — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL