AGNET

Tables (18)

auth_identity

  • id — UUID — Primary key — NOT NULL
  • parent_id — UUID — Foreign key → parent.id — NOT NULL
  • provider — VARCHAR(6) — NOT NULL
  • provider_user_id — TEXT — NOT NULL
  • linked_at — TIMESTAMPTZ — NOT NULL

calendar

  • id — UUID — Primary key — NOT NULL
  • child_id — UUID — Foreign key → child.id — NOT NULL
  • date — DATE — NOT NULL
  • diary_text — TEXT
  • image_urls — TEXT — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

child

  • id — UUID — Primary key — NOT NULL
  • nickname — TEXT — NOT NULL
  • owner_parent_id — UUID — Foreign key → parent.id — NOT NULL
  • birth_date — DATE — NOT NULL
  • deleted_at — TIMESTAMPTZ
  • deleted_by — UUID — Foreign key → parent.id
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

consent

  • id — UUID — Primary key — NOT NULL
  • parent_id — UUID — Foreign key → parent.id — NOT NULL
  • child_id — UUID — Foreign key → child.id
  • scope — VARCHAR(15) — NOT NULL
  • action — VARCHAR(9) — NOT NULL
  • policy_version — TEXT — NOT NULL
  • guardian_attested — BOOLEAN
  • acted_at — TIMESTAMPTZ — NOT NULL

correction

  • id — UUID — Primary key — NOT NULL
  • affinity_id — UUID — Foreign key → profile_affinity.id — NOT NULL
  • verdict — VARCHAR(32) — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL

event

  • id — UUID — Primary key — NOT NULL
  • child_id — UUID — Foreign key → child.id — NOT NULL
  • title — TEXT — NOT NULL
  • event_type — VARCHAR(8) — NOT NULL
  • starts_at — TIMESTAMPTZ — NOT NULL
  • ends_at — TIMESTAMPTZ
  • all_day — BOOLEAN — NOT NULL
  • category — VARCHAR(11) — NOT NULL
  • status — VARCHAR(9) — NOT NULL
  • created_by — VARCHAR(9) — NOT NULL
  • expires_at — TIMESTAMPTZ — NOT NULL
  • source_notice_id — UUID
  • source_refs — JSONB

event_item

  • item_id — UUID — Primary key — NOT NULL
  • event_id — UUID — Foreign key → event.id — NOT NULL
  • item_name — TEXT — NOT NULL
  • is_prepared — BOOLEAN — NOT NULL
  • prepared_at — TIMESTAMPTZ

health_safety

  • id — UUID — Primary key — NOT NULL
  • child_id — UUID — Foreign key → child.id — NOT NULL
  • kind — VARCHAR(32) — NOT NULL
  • label — TEXT — NOT NULL
  • aliases — TEXT — NOT NULL
  • category — TEXT
  • severity — VARCHAR(32)
  • reactions — TEXT — NOT NULL
  • management — JSONB — NOT NULL
  • notes — TEXT
  • state — VARCHAR(32) — NOT NULL
  • created_by — UUID — Foreign key → parent.id — NOT NULL
  • updated_by — UUID — Foreign key → parent.id
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

invite

  • id — UUID — Primary key — NOT NULL
  • child_id — UUID — Foreign key → child.id — NOT NULL
  • created_by — UUID — Foreign key → parent.id
  • token — TEXT — NOT NULL
  • expires_at — TIMESTAMPTZ — NOT NULL
  • used_at — TIMESTAMPTZ
  • used_by — UUID — Foreign key → parent.id

observation_activity

  • id — UUID — Primary key — NOT NULL
  • activity — TEXT — NOT NULL
  • location — TEXT
  • companions — TEXT
  • duration_min — INTEGER
  • engagement_level — VARCHAR(32)
  • child_id — UUID — Foreign key → child.id — NOT NULL
  • raw_text — TEXT — NOT NULL
  • subject — TEXT — NOT NULL
  • embedding — VECTOR(1536)
  • affinity_id — UUID — Foreign key → profile_affinity.id
  • polarity — SMALLINT — NOT NULL
  • strong_signals — TEXT — NOT NULL
  • confidence_source — VARCHAR(32) — NOT NULL
  • status — VARCHAR(32) — NOT NULL
  • observed_range — DATERANGE — NOT NULL
  • source_writer — UUID — Foreign key → parent.id — NOT NULL
  • source_notice_id — UUID
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

observation_education

  • id — UUID — Primary key — NOT NULL
  • topic — TEXT — NOT NULL
  • session_type — TEXT
  • duration_min — INTEGER
  • engagement_level — VARCHAR(32)
  • child_id — UUID — Foreign key → child.id — NOT NULL
  • raw_text — TEXT — NOT NULL
  • subject — TEXT — NOT NULL
  • embedding — VECTOR(1536)
  • affinity_id — UUID — Foreign key → profile_affinity.id
  • polarity — SMALLINT — NOT NULL
  • strong_signals — TEXT — NOT NULL
  • confidence_source — VARCHAR(32) — NOT NULL
  • status — VARCHAR(32) — NOT NULL
  • observed_range — DATERANGE — NOT NULL
  • source_writer — UUID — Foreign key → parent.id — NOT NULL
  • source_notice_id — UUID
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

observation_food

  • id — UUID — Primary key — NOT NULL
  • action — TEXT
  • amount — TEXT
  • reaction — TEXT
  • child_id — UUID — Foreign key → child.id — NOT NULL
  • raw_text — TEXT — NOT NULL
  • subject — TEXT — NOT NULL
  • embedding — VECTOR(1536)
  • affinity_id — UUID — Foreign key → profile_affinity.id
  • polarity — SMALLINT — NOT NULL
  • strong_signals — TEXT — NOT NULL
  • confidence_source — VARCHAR(32) — NOT NULL
  • status — VARCHAR(32) — NOT NULL
  • observed_range — DATERANGE — NOT NULL
  • source_writer — UUID — Foreign key → parent.id — NOT NULL
  • source_notice_id — UUID
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

observation_health

  • id — UUID — Primary key — NOT NULL
  • child_id — UUID — Foreign key → child.id — NOT NULL
  • raw_text — TEXT — NOT NULL
  • confidence_source — VARCHAR(32) — NOT NULL
  • status — VARCHAR(32) — NOT NULL
  • observed_range — DATERANGE — NOT NULL
  • source_writer — UUID — Foreign key → parent.id — NOT NULL
  • source_notice_id — UUID
  • symptom — TEXT — NOT NULL
  • severity — VARCHAR(32)
  • body_part — TEXT
  • suspected_trigger — TEXT
  • action_taken — TEXT
  • observed_time — TIMESTAMPTZ
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

parent

  • id — UUID — Primary key — NOT NULL
  • nickname — TEXT
  • deleted_at — TIMESTAMPTZ
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

parent_child

  • id — UUID — Primary key — NOT NULL
  • parent_id — UUID — Foreign key → parent.id — NOT NULL
  • child_id — UUID — Foreign key → child.id — NOT NULL
  • relation — VARCHAR(11) — NOT NULL
  • connected_at — TIMESTAMPTZ — NOT NULL

profile_affinity

  • id — UUID — Primary key — NOT NULL
  • child_id — UUID — Foreign key → child.id — NOT NULL
  • merge_key — TEXT — NOT NULL
  • embedding — VECTOR(1536)
  • domain — VARCHAR(32) — NOT NULL
  • state — VARCHAR(32) — NOT NULL
  • polarity — SMALLINT
  • strength — FLOAT — NOT NULL
  • last_observed_on — DATE — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

reminder

  • id — UUID — Primary key — NOT NULL
  • event_id — UUID — Foreign key → event.id — NOT NULL
  • remind_at — TIMESTAMPTZ — NOT NULL
  • sent_at — TIMESTAMPTZ

suggestion

  • id — UUID — Primary key — NOT NULL
  • child_id — UUID — Foreign key → child.id — NOT NULL
  • agent — VARCHAR(32) — NOT NULL
  • content — TEXT — NOT NULL
  • reason — TEXT
  • status — VARCHAR(32) — NOT NULL
  • feedback — VARCHAR(32)
  • source_refs — JSONB — NOT NULL
  • expires_at — TIMESTAMPTZ — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL