sikdan

테이블 (8)

admin_copy_blocks

  • id — VARCHAR(36)
  • slug — VARCHAR(100) — NOT NULL
  • locale — VARCHAR(10)
  • content — TEXT — NOT NULL
  • version — INT
  • updated_by — VARCHAR(36)
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

admin_security_audit

  • id — VARCHAR(36)
  • admin_id — VARCHAR(36) — NOT NULL
  • action_type — VARCHAR(50) — NOT NULL
  • target_table — VARCHAR(100)
  • target_id — VARCHAR(36)
  • old_value — TEXT
  • new_value — TEXT
  • ip_address — VARCHAR(45)
  • created_at — TIMESTAMP

copy_block_history

  • id — VARCHAR(36)
  • copy_block_id — VARCHAR(36) — NOT NULL
  • version — INT — NOT NULL
  • content — TEXT — NOT NULL
  • changed_by — VARCHAR(36)
  • change_reason — TEXT
  • created_at — TIMESTAMP

family_members

  • ID (id2) — UUID — 외래 키 → 사용자.ID — NOT NULL
  • id — VARCHAR(36)
  • user_id — VARCHAR(36) — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • relationship — VARCHAR(50)
  • gender — VARCHAR(10)
  • birth_date — DATE
  • height_cm — DECIMAL(5,2)
  • weight_kg — DECIMAL(5,2)
  • is_child — BOOLEAN
  • diseases — TEXT
  • allergies — TEXT
  • include_in_unified_diet — BOOLEAN
  • 가족구성원등록날짜 (created_at) — timestamptz — NOT NULL

kcdc_alerts

  • id — INT
  • alert_type — VARCHAR(50) — NOT NULL
  • title — VARCHAR(200) — NOT NULL
  • content — TEXT
  • severity_level — INT
  • source_url — VARCHAR(500)
  • is_active — BOOLEAN
  • fetched_at — TIMESTAMP

notification_logs

  • ID (id) — UUID — 기본 키 — NOT NULL
  • 사용자ID (user_id) — UUID — 외래 키 → 사용자.ID — NOT NULL
  • 알림종류 (notification_type) — VARCHAR(50) — NOT NULL
  • payload — TEXT
  • 상태 (status) — VARCHAR(20)
  • 알림시간 (created_at) — timestamptz — NOT NULL

popup_announcements

  • id — VARCHAR(36)
  • title — VARCHAR(200) — NOT NULL
  • content — TEXT — NOT NULL
  • popup_type — VARCHAR(30)
  • priority — INT
  • target_segment — VARCHAR(50)
  • is_published — BOOLEAN
  • start_date — TIMESTAMP
  • end_date — TIMESTAMP
  • created_by — VARCHAR(36)
  • created_at — TIMESTAMP

사용자 (Users)

  • ID (id) — UUID — 기본 키 — NOT NULL
  • 이메일 (email) — text — NOT NULL
  • 이름 (name) — text — NOT NULL
  • 역할 (role) — enum — NOT NULL — "사용자", "관리자"
  • Field