disaster

Tables (5)

disaster_event_live

  • muni_code — CHAR(5) — Primary key — NOT NULL
  • disaster_type — ENUM('EARTHQUAKE','TYPHOON','FLOOD','FIRE','VOLCANO','TSUNAMI','LANDSLIDE','OTHER') — Primary key — NOT NULL
  • started_at — DATETIME — NOT NULL
  • expected_end — DATETIME
  • source — VARCHAR(200) — NOT NULL

member

  • Key — Primary key — NOT NULL
  • member_id — BIGINT
  • email — VARCHAR(190) — NOT NULL
  • password_hash — VARCHAR(255) — NOT NULL
  • name — VARCHAR(80) — NOT NULL
  • phone — VARCHAR(40)
  • line_user_id — VARCHAR(64)
  • role — ENUM('USER', 'ADMIN') — NOT NULL
  • is_active — BOOLEAN — NOT NULL
  • marketing_consent — BOOLEAN — 마케팅 수신 동의
  • terms_agreed_at — TIMESTAMP — 이용약관 동의 시간
  • privacy_agreed_at — TIMESTAMP — 개인정보처리방침 동의 시간
  • reset_token — VARCHAR(255)
  • reset_token_expires — TIMESTAMP
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL
  • Field

member_address

  • address_id — BIGINT
  • member_id — BIGINT — NOT NULL
  • postal_code — VARCHAR(10) — NOT NULL
  • pref_code — CHAR(2) — NOT NULL
  • muni_code — VARCHAR(10) — NOT NULL
  • addr_line1 — VARCHAR(200)
  • addr_line2 — VARCHAR(200)
  • lat — DECIMAL(10,7)
  • lon — DECIMAL(10,7)
  • is_primary — BOOLEAN — NOT NULL
  • disaster_status — TINYINT — NOT NULL
  • created_at — DATETIME — NOT NULL
  • INDEX — idx_addr_member
  • INDEX — idx_addr_muni
  • INDEX — idx_addr_pref
  • INDEX — idx_addr_status
  • INDEX — idx_location

post

  • post_id — BIGINT
  • member_id — BIGINT — NOT NULL
  • nickname — VARCHAR(50) — NOT NULL
  • address_id — BIGINT — NOT NULL
  • muni_code — VARCHAR(10) — NOT NULL
  • disaster_type — ENUM('EARTHQUAKE','TYPHOON','FLOOD','FIRE','VOLCANO','TSUNAMI','LANDSLIDE','OTHER') — NOT NULL
  • title — VARCHAR(120) — NOT NULL
  • sub_image — VARCHAR(1000)
  • body — MEDIUMTEXT — NOT NULL
  • lat — DECIMAL(10,7)
  • lon — DECIMAL(10,7)
  • status — ENUM('PUBLISHED','HIDDEN','DELETED','REPORTED') — NOT NULL
  • view_count — INT
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL
  • INDEX — idx_post_area
  • INDEX — idx_post_member
  • INDEX — idx_post_status

user_pref

  • member_id — BIGINT
  • notify_line — BOOLEAN — NOT NULL
  • notify_email — BOOLEAN — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL