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