1331

Tables (9)

call_invites

  • id — INT — Primary key — NOT NULL
  • call_room_id — INT — Foreign key → call_rooms.id — NOT NULL
  • token_hash — VARCHAR(255) — NOT NULL
  • expires_at — DATETIME — NOT NULL
  • used_at — DATETIME

call_rooms

  • id — INT — Primary key — NOT NULL
  • child_id — INT — Foreign key → children.id — NOT NULL
  • livekit_room_name — VARCHAR(255) — NOT NULL
  • room_status — VARCHAR(30) — NOT NULL — WAITING, ACTIVE, ENDED, CANCELLED, FAILED
  • drawing_topic — VARCHAR(255)
  • started_at — DATETIME
  • ended_at — DATETIME

child_interests

  • child_id — INT — Foreign key → children.id — NOT NULL
  • interest_id — INT — Foreign key → interests.id — NOT NULL
  • source — VARCHAR(30) — NOT NULL — DEFAULT, USER, AI
  • status — VARCHAR(30) — NOT NULL — PENDING, ACTIVE, REJECTED

children

  • id — INT — Primary key — NOT NULL
  • parent_id — INT — Foreign key → parents.id — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • birth_date — DATE — NOT NULL
  • gender — VARCHAR(20)
  • profile_image_key — VARCHAR(500)
  • status — VARCHAR(30) — NOT NULL

diary_entries

  • id — INT — Primary key — NOT NULL
  • call_room_id — INT — Foreign key → call_rooms.id — NOT NULL
  • body — TEXT
  • diary_date — DATE — NOT NULL
  • diary_status — VARCHAR(30) — NOT NULL — PENDING, PROCESSING, COMPLETED, FAILED, CONFIRMED
  • drawing_object_key — VARCHAR(500)

interests

  • id — INT — Primary key — NOT NULL
  • interest_name — VARCHAR(100) — NOT NULL
  • category — VARCHAR(100)
  • is_default — BOOLEAN — NOT NULL
  • is_active — BOOLEAN — NOT NULL

parent_memos

  • diary_id — INT — Foreign key → diary_entries.id — NOT NULL
  • parent_id — INT — Foreign key → parents.id — NOT NULL
  • memo_content — TEXT — NOT NULL

parents

  • id — INT — Primary key — NOT NULL
  • email — VARCHAR(255) — NOT NULL
  • password_hash — VARCHAR(255) — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • account_status — BOOLEAN — NOT NULL

refresh_tokens

  • id — INT — Primary key — NOT NULL
  • parent_id — INT — Foreign key → parents.id — NOT NULL
  • token_hash — VARCHAR(255) — NOT NULL
  • expires_at — DATETIME — NOT NULL