AI 체크리스트
테이블 (7)
ai_checklist_generation
- id — BIGSERIAL — 기본 키
- checklist_id — BIGINT
- generation_number — INTEGER
- ai_prompt — TEXT
- ai_response — TEXT
- generated_items — JSONB
- input_context — JSONB
- model_version — VARCHAR(50)
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
checklist
- id — BIGSERIAL — 기본 키
- member_id — BIGINT
- date — DATE
- generation_count — INTEGER — AI
- ai_prompt — TEXT
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
- UNIQUE(member_id, — date)
checklist_item
- id — BIGSERIAL — 기본 키
- checklist_id — BIGINT
- ai_generation_id — BIGINT — NULL이면
- content — TEXT
- is_completed — BOOLEAN
- completed_at — TIMESTAMP
- item_order — INTEGER
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
member
- id — BIGSERIAL — 기본 키
- email — VARCHAR(255)
- nickname — VARCHAR(100)
- onboarding_completed — BOOLEAN
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
notification
- id — BIGSERIAL — 기본 키
- member_id — BIGINT
- type — VARCHAR(30) — REMINDER:
- title — VARCHAR(200)
- message — TEXT
- is_read — BOOLEAN
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
qa
- id — BIGSERIAL — 기본 키
- qa_type — VARCHAR(20)
- question — TEXT
- answer — TEXT
- step_number — INTEGER
- metadata — JSONB
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
- member_id — BIGSERIAL
screen_time
- id — BIGSERIAL — 기본 키
- member_id — BIGINT
- date — DATE
- app_name — VARCHAR(100)
- usage_minutes — INTEGER
- session_count — INTEGER
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
- UNIQUE(member_id, — date,