ex
Tables (18)
auth_identity
- id — CHAR(36) — Primary key — NOT NULL — UUID; default=uuidv7()
- parent_id — CHAR(36) — Foreign key → parent.id — NOT NULL — UUID
- provider — VARCHAR(6) — NOT NULL — VARCHAR(6); values=kakao, apple, google, naver
- provider_user_id — TEXT — NOT NULL — TEXT
- linked_at — DATETIME — NOT NULL — TIMESTAMP WITH TIME ZONE; default=now()
calendar
- id — CHAR(36) — Primary key — NOT NULL — UUID; default=uuidv7()
- child_id — CHAR(36) — NOT NULL — UUID
- date — DATE — NOT NULL — DATE
- diary_text — TEXT — TEXT
- image_urls — TEXT — NOT NULL — TEXT; default={}
- created_at — DATETIME — NOT NULL — TIMESTAMP WITH TIME ZONE; default=now()
- updated_at — DATETIME — NOT NULL — TIMESTAMP WITH TIME ZONE; default=now()
child
- id — CHAR(36) — Primary key — NOT NULL — UUID; default=uuidv7()
- nickname — TEXT — NOT NULL — TEXT
- owner_parent_id — CHAR(36) — Foreign key → parent.id — NOT NULL — UUID
- birth_date — DATE — NOT NULL — DATE
- deleted_at — DATETIME — TIMESTAMP WITH TIME ZONE
- deleted_by — CHAR(36) — Foreign key → parent.id — UUID
- created_at — DATETIME — NOT NULL — TIMESTAMP WITH TIME ZONE; default=now()
- updated_at — DATETIME — NOT NULL — TIMESTAMP WITH TIME ZONE; default=now()
consent
- id — CHAR(36) — Primary key — NOT NULL — UUID; default=uuidv7()
- parent_id — CHAR(36) — Foreign key → parent.id — NOT NULL — UUID
- child_id — CHAR(36) — Foreign key → child.id — UUID
- scope — VARCHAR(15) — NOT NULL — VARCHAR(15); values=service_terms, privacy_account, child_basic, child_health, quality_improve
- action — VARCHAR(9) — NOT NULL — VARCHAR(9); values=granted, withdrawn
- policy_version — TEXT — NOT NULL — TEXT
- guardian_attested — BOOLEAN — BOOLEAN
- acted_at — DATETIME — NOT NULL — TIMESTAMP WITH TIME ZONE; default=now()
correction
- id — CHAR(36) — Primary key — NOT NULL — UUID; default=uuidv7()
- affinity_id — CHAR(36) — NOT NULL — UUID
- verdict — VARCHAR(32) — NOT NULL — VARCHAR(32); values=confirm, once_only, outdated, wrong
- created_at — DATETIME — NOT NULL — TIMESTAMP WITH TIME ZONE; default=now()
event
- id — CHAR(36) — Primary key — NOT NULL — UUID; default=uuidv7()
- child_id — CHAR(36) — Foreign key → child.id — NOT NULL — UUID
- title — TEXT — NOT NULL — TEXT
- event_type — VARCHAR(8) — NOT NULL — VARCHAR(8); values=core, episodic
- starts_at — DATETIME — NOT NULL — TIMESTAMP WITH TIME ZONE
- ends_at — DATETIME — TIMESTAMP WITH TIME ZONE
- all_day — BOOLEAN — NOT NULL — BOOLEAN; default=false
- category — VARCHAR(11) — NOT NULL — VARCHAR(11); values=institution, health, activity, etc
- status — VARCHAR(9) — NOT NULL — VARCHAR(9); default=draft; values=draft, confirmed, cancelled
- created_by — VARCHAR(9) — NOT NULL — VARCHAR(9); values=agent, caregiver
- expires_at — DATETIME — NOT NULL — TIMESTAMP WITH TIME ZONE
- source_notice_id — CHAR(36) — UUID
- source_refs — TEXT — JSONB
event_item
- item_id — CHAR(36) — Primary key — NOT NULL — UUID; default=uuidv7()
- event_id — CHAR(36) — Foreign key → event.id — NOT NULL — UUID
- item_name — TEXT — NOT NULL — TEXT
- is_prepared — BOOLEAN — NOT NULL — BOOLEAN; default=false
- prepared_at — DATETIME — TIMESTAMP WITH TIME ZONE
health_safety
- id — CHAR(36) — Primary key — NOT NULL — UUID; default=uuidv7()
- child_id — CHAR(36) — NOT NULL — UUID
- kind — VARCHAR(32) — NOT NULL — VARCHAR(32); values=allergy, chronic_disease, dietary_restriction, behavioral, environmental, other_medical
- label — TEXT — NOT NULL — TEXT
- aliases — TEXT — NOT NULL — TEXT; default={}
- category — TEXT — TEXT
- severity — VARCHAR(32) — VARCHAR(32); values=mild, moderate, severe, anaphylaxis
- reactions — TEXT — NOT NULL — TEXT; default={}
- management — TEXT — NOT NULL — JSONB; default={}
- notes — TEXT — TEXT
- state — VARCHAR(32) — NOT NULL — VARCHAR(32); default=active; values=active, retracted
- created_by — CHAR(36) — NOT NULL — UUID
- updated_by — CHAR(36) — UUID
- created_at — DATETIME — NOT NULL — TIMESTAMP WITH TIME ZONE; default=now()
- updated_at — DATETIME — NOT NULL — TIMESTAMP WITH TIME ZONE; default=now()
invite
- id — CHAR(36) — Primary key — NOT NULL — UUID; default=uuidv7()
- child_id — CHAR(36) — Foreign key → child.id — NOT NULL — UUID
- created_by — CHAR(36) — Foreign key → parent.id — UUID
- token — TEXT — NOT NULL — TEXT
- expires_at — DATETIME — NOT NULL — TIMESTAMP WITH TIME ZONE
- used_at — DATETIME — TIMESTAMP WITH TIME ZONE
- used_by — CHAR(36) — Foreign key → parent.id — UUID
observation_activity
- id — CHAR(36) — Primary key — NOT NULL — UUID; default=uuidv7()
- activity — TEXT — NOT NULL — TEXT
- location — TEXT — TEXT
- companions — TEXT — TEXT
- duration_min — INTEGER — INTEGER
- engagement_level — VARCHAR(32) — VARCHAR(32); values=low, mid, high
- child_id — CHAR(36) — NOT NULL — UUID
- raw_text — TEXT — NOT NULL — TEXT
- subject — TEXT — NOT NULL — TEXT
- embedding — TEXT — VECTOR(1536)
- affinity_id — CHAR(36) — UUID
- polarity — SMALLINT — NOT NULL — SMALLINT; default=0
- strong_signals — TEXT — NOT NULL — TEXT; default={}
- confidence_source — VARCHAR(32) — NOT NULL — VARCHAR(32); values=institution_notice, parent_direct, parent_hedged, parent_hearsay
- status — VARCHAR(32) — NOT NULL — VARCHAR(32); default=active; values=active, inactive
- observed_range — TEXT — NOT NULL — DATERANGE
- source_writer — CHAR(36) — NOT NULL — UUID
- source_notice_id — CHAR(36) — UUID
- created_at — DATETIME — NOT NULL — TIMESTAMP WITH TIME ZONE; default=now()
- updated_at — DATETIME — NOT NULL — TIMESTAMP WITH TIME ZONE; default=now()
observation_education
- id — CHAR(36) — Primary key — NOT NULL — UUID; default=uuidv7()
- topic — TEXT — NOT NULL — TEXT
- session_type — TEXT — TEXT
- duration_min — INTEGER — INTEGER
- engagement_level — VARCHAR(32) — VARCHAR(32); values=low, mid, high
- child_id — CHAR(36) — NOT NULL — UUID
- raw_text — TEXT — NOT NULL — TEXT
- subject — TEXT — NOT NULL — TEXT
- embedding — TEXT — VECTOR(1536)
- affinity_id — CHAR(36) — UUID
- polarity — SMALLINT — NOT NULL — SMALLINT; default=0
- strong_signals — TEXT — NOT NULL — TEXT; default={}
- confidence_source — VARCHAR(32) — NOT NULL — VARCHAR(32); values=institution_notice, parent_direct, parent_hedged, parent_hearsay
- status — VARCHAR(32) — NOT NULL — VARCHAR(32); default=active; values=active, inactive
- observed_range — TEXT — NOT NULL — DATERANGE
- source_writer — CHAR(36) — NOT NULL — UUID
- source_notice_id — CHAR(36) — UUID
- created_at — DATETIME — NOT NULL — TIMESTAMP WITH TIME ZONE; default=now()
- updated_at — DATETIME — NOT NULL — TIMESTAMP WITH TIME ZONE; default=now()
observation_food
- id — CHAR(36) — Primary key — NOT NULL — UUID; default=uuidv7()
- action — TEXT — TEXT
- amount — TEXT — TEXT
- reaction — TEXT — TEXT
- child_id — CHAR(36) — NOT NULL — UUID
- raw_text — TEXT — NOT NULL — TEXT
- subject — TEXT — NOT NULL — TEXT
- embedding — TEXT — VECTOR(1536)
- affinity_id — CHAR(36) — UUID
- polarity — SMALLINT — NOT NULL — SMALLINT; default=0
- strong_signals — TEXT — NOT NULL — TEXT; default={}
- confidence_source — VARCHAR(32) — NOT NULL — VARCHAR(32); values=institution_notice, parent_direct, parent_hedged, parent_hearsay
- status — VARCHAR(32) — NOT NULL — VARCHAR(32); default=active; values=active, inactive
- observed_range — TEXT — NOT NULL — DATERANGE
- source_writer — CHAR(36) — NOT NULL — UUID
- source_notice_id — CHAR(36) — UUID
- created_at — DATETIME — NOT NULL — TIMESTAMP WITH TIME ZONE; default=now()
- updated_at — DATETIME — NOT NULL — TIMESTAMP WITH TIME ZONE; default=now()
observation_health
- id — CHAR(36) — Primary key — NOT NULL — UUID; default=uuidv7()
- child_id — CHAR(36) — NOT NULL — UUID
- raw_text — TEXT — NOT NULL — TEXT
- confidence_source — VARCHAR(32) — NOT NULL — VARCHAR(32); values=institution_notice, parent_direct, parent_hedged, parent_hearsay
- status — VARCHAR(32) — NOT NULL — VARCHAR(32); default=active; values=active, inactive
- observed_range — TEXT — NOT NULL — DATERANGE
- source_writer — CHAR(36) — NOT NULL — UUID
- source_notice_id — CHAR(36) — UUID
- symptom — TEXT — NOT NULL — TEXT
- severity — VARCHAR(32) — VARCHAR(32); values=mild, moderate, severe, emergency
- body_part — TEXT — TEXT
- suspected_trigger — TEXT — TEXT
- action_taken — TEXT — TEXT
- observed_time — DATETIME — TIMESTAMP WITH TIME ZONE
- created_at — DATETIME — NOT NULL — TIMESTAMP WITH TIME ZONE; default=now()
- updated_at — DATETIME — NOT NULL — TIMESTAMP WITH TIME ZONE; default=now()
parent
- id — CHAR(36) — Primary key — NOT NULL — UUID; default=uuidv7()
- nickname — TEXT — NOT NULL — TEXT
- deleted_at — DATETIME — TIMESTAMP WITH TIME ZONE
- created_at — DATETIME — NOT NULL — TIMESTAMP WITH TIME ZONE; default=now()
- updated_at — DATETIME — NOT NULL — TIMESTAMP WITH TIME ZONE; default=now()
parent_child
- id — CHAR(36) — Primary key — NOT NULL — UUID; default=uuidv7()
- parent_id — CHAR(36) — Foreign key → parent.id — NOT NULL — UUID
- child_id — CHAR(36) — Foreign key → child.id — NOT NULL — UUID
- relation — VARCHAR(11) — NOT NULL — VARCHAR(11); values=mother, father, grandparent, sitter, other
- connected_at — DATETIME — NOT NULL — TIMESTAMP WITH TIME ZONE; default=now()
profile_affinity
- id — CHAR(36) — Primary key — NOT NULL — UUID; default=uuidv7()
- child_id — CHAR(36) — NOT NULL — UUID
- merge_key — TEXT — NOT NULL — TEXT
- embedding — TEXT — VECTOR(1536)
- domain — VARCHAR(32) — NOT NULL — VARCHAR(32); values=food, activity, education
- state — VARCHAR(32) — NOT NULL — VARCHAR(32); default=candidate; values=candidate, confirmed, archived
- polarity — SMALLINT — SMALLINT
- strength — DOUBLE — NOT NULL — FLOAT; default=0.3
- last_observed_on — DATE — NOT NULL — DATE
- created_at — DATETIME — NOT NULL — TIMESTAMP WITH TIME ZONE; default=now()
- updated_at — DATETIME — NOT NULL — TIMESTAMP WITH TIME ZONE; default=now()
reminder
- id — CHAR(36) — Primary key — NOT NULL — UUID; default=uuidv7()
- event_id — CHAR(36) — Foreign key → event.id — NOT NULL — UUID
- remind_at — DATETIME — NOT NULL — TIMESTAMP WITH TIME ZONE
- sent_at — DATETIME — TIMESTAMP WITH TIME ZONE
suggestion
- id — CHAR(36) — Primary key — NOT NULL — UUID; default=uuidv7()
- child_id — CHAR(36) — NOT NULL — UUID
- agent — VARCHAR(32) — NOT NULL — VARCHAR(32); values=food, activity, education, health
- content — TEXT — NOT NULL — TEXT
- reason — TEXT — TEXT
- status — VARCHAR(32) — NOT NULL — VARCHAR(32); default=draft; values=draft, approved, rejected, expired
- feedback — VARCHAR(32) — VARCHAR(32); values=liked, disliked, not_acted
- source_refs — TEXT — NOT NULL — JSONB; default=
- expires_at — DATETIME — NOT NULL — TIMESTAMP WITH TIME ZONE
- created_at — DATETIME — NOT NULL — TIMESTAMP WITH TIME ZONE; default=now()
- updated_at — DATETIME — NOT NULL — TIMESTAMP WITH TIME ZONE; default=now()