medi
Tables (8)
Events
- event_id — BIGINT
- user_id — BIGINT — NOT NULL
- event_name — VARCHAR(100) — NOT NULL
- props — JSON
- created_at — DATETIME
IntakeLogs
- intake_id — BIGINT
- user_supplement_id — BIGINT — NOT NULL
- logged_at — DATETIME
- status — ENUM('taken', 'missed', 'skipped') — NOT NULL
- notes — TEXT
Refills
- refill_id — BIGINT
- user_supplement_id — BIGINT — NOT NULL
- alert_threshold — INT
- last_refill_date — DATETIME
Reminders
- reminder_id — BIGINT
- user_supplement_id — BIGINT — NOT NULL
- reminder_time — TIME — NOT NULL
- repeat_pattern — VARCHAR(50)
- snooze_options — JSON
Subscriptions
- subscription_id — BIGINT
- user_id — BIGINT — NOT NULL
- tier — VARCHAR(20) — NOT NULL
- start_at — DATETIME
- expire_at — DATETIME
- status — ENUM('active', 'canceled', 'expired') — NOT NULL
Supplements
- supplement_id — BIGINT
- name — VARCHAR(255) — NOT NULL
- brand — VARCHAR(100)
- barcode — VARCHAR(100)
- dosage_info — VARCHAR(255)
- frequency_hint — VARCHAR(50)
- notes — TEXT
- image_url — VARCHAR(255)
UserSupplements
- user_supplement_id — BIGINT
- user_id — BIGINT — NOT NULL
- supplement_id — BIGINT — NOT NULL
- dosage — VARCHAR(100)
- schedule — JSON
- remaining_count — INT
- started_at — DATETIME
Users
- user_id — BIGINT
- email — VARCHAR(255) — NOT NULL
- password_hash — VARCHAR(255) — NOT NULL
- name — VARCHAR(100) — NOT NULL
- age_range — VARCHAR(20)
- gender — CHAR(1)
- timezone — VARCHAR(50)
- joined_at — DATETIME
- consent_flags — JSON