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