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