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