해커톤
테이블 (5)
bookmarks
- id — INT — 기본 키 — NOT NULL
- user_id — INT — NOT NULL
- volunteer_id — INT — NOT NULL
- created_at — DATETIME — NOT NULL
popular_searches
- id — INT — 기본 키 — NOT NULL
- keyword — VARCHAR(100) — NOT NULL
- category_code — CHAR(3)
- search_count — INT — NOT NULL
- search_rank — INT — NOT NULL
- rank_change — INT — NOT NULL
- is_new — BOOLEAN — NOT NULL
- base_date — DATE — NOT NULL
recent_views
- id — INT — 기본 키 — NOT NULL
- user_id — INT
- volunteer_id — INT — NOT NULL
- session_id — VARCHAR(100)
- viewed_at — DATETIME — NOT NULL
search_histories
- id — INT — 기본 키 — NOT NULL
- user_id — INT — NOT NULL
- keyword — VARCHAR(100) — NOT NULL
- searched_at — DATETIME — NOT NULL
user_activities
- id — INT — 기본 키 — NOT NULL
- user_id — INT — NOT NULL
- volunteer_id — INT
- category_code — CHAR(3)
- source — ENUM('manual', '1365') — NOT NULL
- status — ENUM('pending', 'approved', 'scheduled', 'completed') — NOT NULL
- applied_at — DATETIME
- scheduled_date — DATE
- completed_at — DATETIME
- vltr_sn — VARCHAR(30)
- rcptn_no — VARCHAR(30)
- vltr_ymd — DATE
- bgng_tm — TIME
- end_tm — TIME
- vltr_hr — DECIMAL(5,2)
- prfmnc_rcg_hr — DECIMAL(5,2)
- prfmnc_aprv_dt — DATETIME
- job_stts_nm — VARCHAR(40)
- dmd_inst_nm — VARCHAR(80)
- vltr_actv_nm — VARCHAR(100)