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