PromptHub
Tables (11)
ai_models
- id — bigint — Primary key — NOT NULL
- name — character — NOT NULL
- platform_id — bigint — Foreign key → platforms.id — NOT NULL
- released_at — date
- slug — character — NOT NULL
- is_active — boolean — NOT NULL
- is_deprecated — boolean — NOT NULL
- sort_order — integer — NOT NULL
auth_tokens
- id — bigint — Primary key — NOT NULL
- created_at — timestamp — NOT NULL
- expires_at — timestamp
- revoked_at — timestamp
- token — character — NOT NULL
- token_type — character — NOT NULL
- user_id — bigint — Foreign key → users.id — NOT NULL
categories
- id — bigint — Primary key — NOT NULL
- name — character — NOT NULL
platforms
- id — bigint — Primary key — NOT NULL
- name — character — NOT NULL
- slug — character — NOT NULL
- is_active — boolean — NOT NULL
- created_at — timestamp — NOT NULL
- updated_at — timestamp — NOT NULL
post_interactions
- id — bigint — Primary key — NOT NULL
- is_liked — boolean — NOT NULL
- is_bookmarked — boolean — NOT NULL
- created_at — timestamp — NOT NULL
- updated_at — timestamp — NOT NULL
- post_id — bigint — Foreign key → posts.id — NOT NULL
- user_id — bigint — Foreign key → users.id — NOT NULL
posts
- id — bigint — Primary key — NOT NULL
- title — character — NOT NULL
- model_etc — character
- category_etc — character
- tags — character
- prompt — text — NOT NULL
- ai_response — text — NOT NULL
- additional_opinion — text
- satisfaction — numeric — NOT NULL
- view_count — bigint — NOT NULL
- like_count — bigint — NOT NULL
- bookmark_count — bigint — NOT NULL
- created_at — timestamp — NOT NULL
- updated_at — timestamp — NOT NULL
- author_id — bigint — Foreign key → users.id — NOT NULL
- category_id — bigint — Foreign key → categories.id — NOT NULL
- model_id — bigint — Foreign key → ai_models.id
- platform_id — bigint — Foreign key → platforms.id — NOT NULL
- model_detail — character
trending_categories
- id — bigint — Primary key — NOT NULL
- name — character — NOT NULL
- title — character — NOT NULL
- subtitle — character — NOT NULL
- icon_name — character — NOT NULL
- order — integer — NOT NULL
- is_active — boolean — NOT NULL
- created_at — timestamp — NOT NULL
- updated_at — timestamp — NOT NULL
trending_rankings
- id — bigint — Primary key — NOT NULL
- rank — integer — NOT NULL
- name — character — NOT NULL
- score — character — NOT NULL
- provider — character — NOT NULL
- is_active — boolean — NOT NULL
- created_at — timestamp — NOT NULL
- updated_at — timestamp — NOT NULL
- category_id — bigint — Foreign key → trending_categories.id — NOT NULL
- related_model_id — bigint — Foreign key → ai_models.id
- model_detail_contains — character — NOT NULL
- model_etc_contains — character — NOT NULL
- use_exact_matching — boolean — NOT NULL
user_sessions
- id — bigint — Primary key — NOT NULL
- browser — character
- created_at — timestamp — NOT NULL
- device — character
- ip_address — character
- last_active — timestamp — NOT NULL
- location — character
- os — character
- revoked_at — timestamp
- session_key — character — NOT NULL
- user_agent — character
- user_id — bigint — Foreign key → users.id — NOT NULL
user_settings
- id — bigint — Primary key — NOT NULL
- email_notifications_enabled — boolean — NOT NULL
- in_app_notifications_enabled — boolean — NOT NULL
- public_profile — boolean — NOT NULL
- data_sharing — boolean — NOT NULL
- two_factor_auth_enabled — boolean — NOT NULL
- updated_at — timestamp — NOT NULL
- user_id — bigint — Foreign key → users.id — NOT NULL
users
- id — bigint — Primary key — NOT NULL
- password — character — NOT NULL
- last_login — timestamp
- is_superuser — boolean — NOT NULL
- username — character — NOT NULL
- first_name — character
- last_name — character
- is_staff — boolean — NOT NULL
- is_active — boolean — NOT NULL
- date_joined — timestamp — NOT NULL
- email — character — NOT NULL
- avatar — character
- avatar_color1 — character
- avatar_color2 — character
- created_at — timestamp — NOT NULL
- bio — character
- github_handle — character
- location — character
- profile_image — character
- google_sub — character