plainApi

Tables (10)

api_keys

  • id (key_id) — SERIAL — Primary key
  • user_id — VARCHAR(255) — Foreign key → users.user_id
  • key_value — VARCHAR(255) — NOT NULL
  • is_active — BOOLEAN
  • created_at — TIMESTAMP

api_logs

  • id — INT — Primary key
  • id (id2) — SERIAL — Foreign key → api_keys.id
  • endpoint — VARCHAR(255)
  • response_code — INTEGER
  • response_time_ms — INTEGER
  • request_timestamp — TIMESTAMP

faqs

  • id — SERIAL
  • user_id — VARCHAR(255) — Foreign key → users.user_id
  • question — TEXT
  • answer — TEXT
  • category — VARCHAR(100)
  • created_at — TIMESTAMP

oauth_providers

  • id — SERIAL
  • user_id — INTEGER
  • provider_name — VARCHAR(50)
  • provider_user_id — VARCHAR(255)
  • created_at — TIMESTAMP

plans

  • id — SERIAL
  • name — VARCHAR(100) — NOT NULL
  • monthly_price — NUMERIC(10,2)
  • request_limit — INTEGER
  • description — TEXT

policy_consents

  • id — SERIAL
  • user_id — INTEGER
  • agreed_privacy — BOOLEAN
  • agreed_ai_ethics — BOOLEAN
  • consented_at — TIMESTAMP

subscriptions

  • id — SERIAL
  • user_id — INTEGER
  • plan_id — INTEGER
  • start_date — DATE
  • end_date — DATE
  • is_active — BOOLEAN

support_tickets

  • id — SERIAL
  • user_id — INTEGER
  • title — VARCHAR(255)
  • description — TEXT
  • status — VARCHAR(50)
  • created_at — TIMESTAMP

usage_stats

  • id (id2) — SERIAL — Foreign key → api_keys.id
  • id — SERIAL
  • date — DATE
  • total_requests — INTEGER
  • error_count — INTEGER

users

  • user_id — VARCHAR(255) — Primary key
  • email — VARCHAR(255) — NOT NULL
  • password_hash — TEXT — NOT NULL
  • user_role — VARCHAR(20)
  • created_at — TIMESTAMP