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