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,