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