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