삐뽀삐4

테이블 (13)

Untitled2

  • Field — VARCHAR(255)

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