nulbom
Tables (5)
auth.users (Untitled)
- Key1 — Primary key — NOT NULL
comments
- id (Key) — UUID — Primary key — NOT NULL
- note_id (Key2) — UUID — Foreign key → notes.id — NOT NULL
- user_id (Key3) — UUID — Foreign key → users.id — NOT NULL
- text — TEXT — NOT NULL
- created_at — TIMESTAMPTZ
notes
- id (Key) — UUID — Primary key — NOT NULL
- ward_id (Key2) — UUID — Foreign key → wards.id — NOT NULL
- caregiver_id (Key3) — UUID — Foreign key → users.id — NOT NULL
- id (Key32) — UUID — Foreign key → wards.guardian_id — NOT NULL
- photos — JSONB
- meal — TEXT
- ai_note — TEXT
- tags — _TEXT
- created_at — TIMESTAMPTZ
users
- id (Key) — UUID — Primary key — NOT NULL
- role — USER_ROLE — NOT NULL
- name — TEXT — NOT NULL
- affiliation — TEXT
- created_at — TIMESTAMPTZ
- email — TEXT
- id — UUID — Foreign key → auth.users.Key1 — NOT NULL
wards
- id (Key) — UUID — Primary key — NOT NULL
- guardian_id — UUID — Foreign key → users.id — NOT NULL
- name — TEXT — NOT NULL
- birth_date — DATE
- gender — GENDER
- affiliation — TEXT
- caregiver_id — UUID — NOT NULL
- created_at — TIMESTAMPTZ