Ringle

Tables (4)

membership_configs

  • id — INTEGER — Primary key — NOT NULL
  • membership_type — VARCHAR(255) — NOT NULL
  • name — VARCHAR(255) — NOT NULL
  • duration_days — INTEGER — NOT NULL
  • price — DECIMAL(10,2) — NOT NULL
  • daily_ai_requests — INTEGER — NOT NULL
  • features — TEXT
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

memberships

  • id — INTEGER — Primary key — NOT NULL
  • name — VARCHAR(255) — NOT NULL
  • duration_days — INTEGER — NOT NULL
  • features — TEXT
  • price — DECIMAL(10,2) — NOT NULL
  • daily_ai_requests — INTEGER — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

user_memberships

  • id — INTEGER — Primary key — NOT NULL
  • memberships_id — INTEGER — Foreign key → memberships.id — NOT NULL
  • users_id — INTEGER — Foreign key → users.id — NOT NULL
  • user_id — INTEGER — NOT NULL
  • membership_id — INTEGER — NOT NULL
  • start_date — DATETIME
  • end_date — DATETIME
  • status — INTEGER — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

users

  • id — INTEGER — Primary key — NOT NULL
  • email — VARCHAR(255) — NOT NULL
  • name — VARCHAR(255) — NOT NULL
  • password_digest — VARCHAR(255) — NOT NULL
  • role — INTEGER — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL