user

Tables (9)

family_groups

  • id — BIGSERIAL
  • name — TEXT — NOT NULL
  • owner_user_id — BIGINT — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

family_invitations

  • id — BIGSERIAL
  • family_group_id — BIGINT — NOT NULL
  • inviter_user_id — BIGINT — NOT NULL
  • invitee_email — TEXT — NOT NULL
  • status — TEXT — NOT NULL
  • expires_at — TIMESTAMPTZ — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

family_memberships

  • id — BIGSERIAL
  • user_id — BIGINT — NOT NULL
  • family_group_id — BIGINT — NOT NULL
  • role — TEXT — NOT NULL
  • status — TEXT — NOT NULL
  • joined_at — TIMESTAMPTZ — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

histories

  • id — BIGSERIAL
  • user_id — BIGINT — NOT NULL
  • schedule_id — BIGINT
  • taken_at — TIMESTAMPTZ — NOT NULL
  • method — TEXT — NOT NULL
  • is_synced — BOOLEAN — NOT NULL
  • prev_state_snapshot — JSONB
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

nfc_tags

  • id — BIGSERIAL
  • schedule_id — BIGINT — NOT NULL
  • nfc_uid — TEXT — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL

notifications

  • id — BIGSERIAL
  • user_id — BIGINT — NOT NULL
  • family_group_id — BIGINT
  • type — TEXT — NOT NULL
  • payload — JSONB — NOT NULL
  • scheduled_at — TIMESTAMPTZ — NOT NULL
  • sent_at — TIMESTAMPTZ
  • status — TEXT — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

schedules

  • id — BIGSERIAL
  • user_id — BIGINT — NOT NULL
  • medication_name — TEXT — NOT NULL
  • dosage_value — NUMERIC — NOT NULL
  • dosage_unit — TEXT — NOT NULL
  • recurrence_rule — JSONB — NOT NULL
  • start_date — DATE — NOT NULL
  • end_date — DATE
  • is_active — BOOLEAN — NOT NULL
  • allow_skip — BOOLEAN — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

user_settings

  • id — BIGSERIAL
  • user_id — BIGINT — NOT NULL
  • settings — JSONB — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

users

  • Key — SERIAL — Primary key — NOT NULL
  • name — TEXT — NOT NULL
  • email — TEXT — NOT NULL
  • phone_number — TEXT
  • birth_date — DATE
  • gender — ENUM — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL