wemake

Tables (18)

categories

  • category_id — bigint — Primary key — NOT NULL
  • name — text — NOT NULL
  • description — text — NOT NULL
  • created_at — timestamp — NOT NULL
  • updated_at — timestamp — NOT NULL

follows

  • profile_id (follower_id) — uuid — Foreign key → profiles.profile_id — NOT NULL
  • profile_id (following_id) — uuid — Foreign key → profiles.profile_id — NOT NULL
  • created_at — timestamp — NOT NULL

gpt_ideas

  • gpt_idea_id — bigint — Primary key — NOT NULL
  • idea — text — NOT NULL
  • views — integer — NOT NULL
  • claimed_at — timestamp
  • created_at — timestamp — NOT NULL
  • profile_id (claimed_by) — uuid — Foreign key → profiles.profile_id — NOT NULL

gpt_ideas_likes

  • gpt_idea_id — bigint — Foreign key → gpt_ideas.gpt_idea_id — NOT NULL
  • profile_id — uuid — Foreign key → profiles.profile_id — NOT NULL

jobs

  • job_id — bigint — Primary key — NOT NULL
  • position — text — NOT NULL
  • overview — text — NOT NULL
  • responsibilities — text — NOT NULL
  • qualifications — text — NOT NULL
  • benefits — text — NOT NULL
  • skills — text — NOT NULL
  • company_name — text — NOT NULL
  • company_logo_url — text — NOT NULL
  • company_location — text — NOT NULL
  • apply_url — text — NOT NULL
  • job_types — USER-DEFINED — NOT NULL
  • job_location — USER-DEFINED — NOT NULL
  • salary_range — USER-DEFINED — NOT NULL
  • create_at — timestamp — NOT NULL
  • update_at — timestamp — NOT NULL

message_room_members

  • profile_id — uuid — Foreign key → profiles.profile_id — NOT NULL
  • message_room_id — bigint — Foreign key → message_rooms.message_room_id — NOT NULL
  • created_at — timestamp — NOT NULL

message_rooms

  • message_room_id — bigint — Primary key — NOT NULL
  • created_at — timestamp — NOT NULL

messages

  • message_id — bigint — Primary key — NOT NULL
  • content — text — NOT NULL
  • created_at — timestamp — NOT NULL
  • sender_id — uuid — Foreign key → profiles.profile_id — NOT NULL
  • message_room_id — bigint — Foreign key → message_rooms.message_room_id — NOT NULL

notifications

  • notification_id — bigint — Primary key — NOT NULL
  • type — USER-DEFINED — NOT NULL
  • created_at — timestamp — NOT NULL
  • profile_id (source_id) — uuid — Foreign key → profiles.profile_id — NOT NULL
  • profile_id (target_id) — uuid — Foreign key → profiles.profile_id — NOT NULL
  • product_id — bigint — Foreign key → products.product_id — NOT NULL
  • post_id — bigint — Foreign key → posts.post_id — NOT NULL
  • Field (seen) — boolean

post_replies

  • post_reply_id — bigint — Primary key — NOT NULL
  • reply — text — NOT NULL
  • created_at — timestamp — NOT NULL
  • updated_at — timestamp — NOT NULL
  • post_reply_id (parent_id) — bigint — Foreign key → post_replies.post_reply_id — NOT NULL
  • post_id — bigint — Foreign key → posts.post_id — NOT NULL
  • profile_id — uuid — Foreign key → profiles.profile_id — NOT NULL

post_upvotes

  • post_id — bigint — Foreign key → posts.post_id — NOT NULL
  • profile_id — uuid — Foreign key → profiles.profile_id — NOT NULL

posts

  • post_id — bigint — Primary key — NOT NULL
  • title — text — NOT NULL
  • content — text — NOT NULL
  • created_at — timestamp — NOT NULL
  • updated_at — timestamp — NOT NULL
  • profile_id — uuid — Foreign key → profiles.profile_id — NOT NULL
  • topic_id — bigint — Foreign key → topics.topic_id — NOT NULL

product_upvotes

  • profile_id — uuid — Foreign key → profiles.profile_id — NOT NULL
  • product_id — bigint — Foreign key → products.product_id — NOT NULL

products

  • product_id — bigint — Primary key — NOT NULL
  • name — text — NOT NULL
  • tagline — text — NOT NULL
  • description — text — NOT NULL
  • how_it_works — text — NOT NULL
  • icon — text — NOT NULL
  • url — text — NOT NULL
  • stats — jsonb — NOT NULL
  • created_at — timestamp — NOT NULL
  • updated_at — timestamp — NOT NULL
  • profile_id — uuid — Foreign key → profiles.profile_id — NOT NULL
  • category_id — bigint — Foreign key → categories.category_id — NOT NULL

profiles

  • profile_id — uuid — Primary key — NOT NULL
  • avatar — text
  • name — text — NOT NULL
  • username — text — NOT NULL
  • headline — text
  • bio — text
  • role — USER-DEFINED — NOT NULL
  • stats — jsonb
  • views — jsonb
  • created_at — timestamp — NOT NULL
  • updated_at — timestamp — NOT NULL

reviews

  • review_id — bigint — Primary key — NOT NULL
  • rating — integer — NOT NULL
  • review — text — NOT NULL
  • created_at — timestamp — NOT NULL
  • updated_at — timestamp — NOT NULL
  • profile_id — uuid — Foreign key → profiles.profile_id — NOT NULL
  • product_id — bigint — Foreign key → products.product_id — NOT NULL

team

  • team_id — bigint — Primary key — NOT NULL
  • product_name — text — NOT NULL
  • team_size — integer — NOT NULL
  • equity_split — integer — NOT NULL
  • product_stage — USER-DEFINED — NOT NULL
  • roles — text — NOT NULL
  • product_description — text — NOT NULL
  • created_at — timestamp — NOT NULL
  • updated_at — timestamp — NOT NULL

topics

  • topic_id — bigint — Primary key — NOT NULL
  • name — text — NOT NULL
  • slug — text — NOT NULL
  • created_at — timestamp — NOT NULL