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