Likelion-Central-Hackathon
테이블 (8)
access_audit_log
- id — bigint — 기본 키 — NOT NULL
- accessed_at — datetime(6) — NOT NULL
- action — varchar(60) — NOT NULL
- actor_id — bigint — NOT NULL
- subject_id — bigint — NOT NULL
environment_observation
- id — bigint — 기본 키 — NOT NULL
- district_label — varchar(80) — NOT NULL
- fetched_at — datetime(6) — NOT NULL
- grid_x — int — NOT NULL
- grid_y — int — NOT NULL
- humidity — decimal(5,2) — NOT NULL
- observed_at — datetime(6) — NOT NULL
- pm25 — decimal(7,2)
- temperature — decimal(5,2) — NOT NULL
event_feedback
- id — bigint — 기본 키 — NOT NULL
- client_event_id — varchar(64) — NOT NULL
- context — varchar(200)
- created_at — datetime(6) — NOT NULL
- label — varchar(30) — NOT NULL
- raw_window_included — bit(1) — NOT NULL
- user_id — bigint — NOT NULL
guardian_link
- id — bigint — 기본 키 — NOT NULL
- active — bit(1) — NOT NULL
- child_id — bigint — NOT NULL
- created_at — datetime(6) — NOT NULL
- guardian_id — bigint — NOT NULL
- legal_consent_id — bigint
- timeline_read — bit(1) — NOT NULL
ingest_batch
- id — bigint — 기본 키 — NOT NULL
- accepted — int — NOT NULL
- device_id — bigint — NOT NULL
- duplicated — int — NOT NULL
- idempotency_key — varchar(100) — NOT NULL
- newest_event_ts — datetime(6) — NOT NULL
- oldest_event_ts — datetime(6) — NOT NULL
- user_id — bigint — NOT NULL
- watermark_ts — datetime(6) — NOT NULL
- wear_seconds — bigint — NOT NULL
scratch_event
- id — bigint — 기본 키 — NOT NULL
- calibration_version — int — NOT NULL
- client_event_id — varchar(64) — NOT NULL
- confidence — decimal(5,4) — NOT NULL
- created_at — datetime(6) — NOT NULL
- device_id — bigint — NOT NULL
- duration_sec — decimal(10,3) — NOT NULL
- end_ts — datetime(6) — NOT NULL
- intensity — int — NOT NULL
- model_version — varchar(32) — NOT NULL
- start_ts — datetime(6) — NOT NULL
- user_id — bigint — NOT NULL
- wear_position — enum('LEFT','RIGHT') — NOT NULL
- window_count — int — NOT NULL
watch_devices
- id — bigint — 기본 키 — NOT NULL
- active — bit(1) — NOT NULL
- device_identifier — varchar(255) — NOT NULL
- device_name — varchar(255) — NOT NULL
- paired_at — datetime(6) — NOT NULL
- parent_user_id — bigint — NOT NULL
기기 등록 (device_pairing_codes)
- id — bigint — 기본 키 — NOT NULL
- code — varchar(6) — NOT NULL
- expires_at — datetime(6) — NOT NULL
- parent_user_id — bigint — NOT NULL
- status — enum('EXPIRED','USED','WAITING') — NOT NULL