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