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