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()