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