foolaunch
테이블 (15)
Untitled3 (idea_feedback_response)
- Key (idea_feedback_response_id) — BIGSEREIAL — 기본 키 — NOT NULL
- Field (content) — TEXT — NOT NULL
- Field (is_public) — BOOLEAN — NOT NULL
- Key (user_id) — BIGINT — 외래 키 → 사용자.Key — NOT NULL
- Key (idea_post_id) — BIGINT — 외래 키 → idea_post.Key — NOT NULL
Untitled3 (idea_rating)
- Key (user_id) — BIGINT — 외래 키 → 사용자.Key — NOT NULL
- Key (idea_post_id) — BIGINT — 외래 키 → idea_post.Key — NOT NULL
- Field (rating) — SMALLINT(0~5) — NOT NULL
idea_attachment
- Key (idea_attachment_id) — BIGSERIAL — 기본 키 — NOT NULL
- type (file_type) — VARCHAR(10)
- url — VARCHAR(300)
- file_name — VARCHAR(200)
- created_at — TIMESTAMPTZ
- Key (idea_post_id) — BIGSERIAL — 외래 키 → idea_post.Key — NOT NULL
- Field (description) — VARCHAR(500)
idea_category
- Key (idea_category_id) — BIGSERIAL — 기본 키 — NOT NULL
- Field (name) — VARCHAR(50)
idea_comment
- Key (idea_comment_id) — BIGSERIAL — 기본 키 — NOT NULL
- content — VARCHAR(500) — NOT NULL
- is_deleted — BOOLEAN
- created_at — TIMESTAMPTZ
- updated_at — TIMESTAMPTZ
- Key (idea_post_id) — BIGSERIAL — 외래 키 → idea_post.Key — NOT NULL
- Key (user_id) — BIGSERIAL — 외래 키 → 사용자.Key — NOT NULL
- Key (parent_comment_id) — BIGSERIAL — 외래 키 → idea_comment.Key — NOT NULL
idea_comment_reaction
- Key (idea_comment_reaction_id) — BIGSERIAL — 기본 키 — NOT NULL
- reaction_type — VARCHAR(20)
- created_at — TIMESTAMPTZ
- Key (idea_comment_id) — BIGSERIAL — 외래 키 → idea_comment.Key — NOT NULL
- Key (user_id) — BIGSERIAL — 외래 키 → 사용자.Key — NOT NULL
idea_evaluation
- Key (idea_evaluation_id) — BIGSERIAL — 기본 키 — NOT NULL
- score — SMALLINT
- created_at — TIMESTAMPTZ
- Key (user_id) — BIGSERIAL — 외래 키 → 사용자.Key — NOT NULL
- Key (idea_post_id) — BIGSERIAL — 외래 키 → idea_post.Key — NOT NULL
- Key (idea_evaluation_metric_id) — BIGSERIAL — 외래 키 → idea_evaluation_metric.Key — NOT NULL
idea_evaluation_metric
- Key (idea_evaluation_metric_id) — BIGSERIAL — 기본 키 — NOT NULL
- name — VARCHAR(100) — NOT NULL
- description — VARCHAR(255)
idea_post
- Key (idea_post_id) — BIGSERIAL — 기본 키 — NOT NULL
- title — VARCHAR(200) — NOT NULL
- summary — VARCHAR(300) — NOT NULL
- problem — TEXT — NOT NULL
- solution — TEXT — NOT NULL
- Field (target_user) — TEXT — NOT NULL
- Field3 (stage) — VARCHAR(50) — NOT NULL
- Field (revenue_model) — TEXT
- Field (tech_stacks) — TEXT
- Field2 (alternatives) — TEXT
- thumbnail_url — VARCHAR(300)
- view_count — INT
- like_count — INT
- comment_count — INT
- created_at — TIMESTAMPTZ — NOT NULL
- updated_at — TIMESTAMPTZ
- Key (user_id) — BIGSERIAL — 외래 키 → 사용자.Key — NOT NULL
- Key (category_id) — BIGSERIAL — 외래 키 → idea_category.Key — NOT NULL
- Field (is_deleted) — BOOLEAN — NOT NULL
- Field (url_map) — JSONB
idea_post_tag
- Key (idea_post_id) — BIGSERIAL — 외래 키 → idea_post.Key — NOT NULL
- Key (idea_tag_id) — BIGSERIAL — 외래 키 → idea_tag.Key — NOT NULL
idea_tag
- Key (idea_tag_id) — BIGSERIAL — 기본 키 — NOT NULL
- tag_name — VARCHAR(50) — NOT NULL
likes
- Key (id) — BIGSERIAL — 기본 키 — NOT NULL
- Key (user_id) — BIGSERIAL — 외래 키 → 사용자.Key — NOT NULL
- Key (idea_post_id) — BIGSERIAL — 외래 키 → idea_post.Key — NOT NULL
사용자 (user)
- Key (user_id) — BIGSERIAL — 기본 키 — NOT NULL
- email — VARCHAR(255) — NOT NULL
- username — VARCHAR(100) — NOT NULL
- profile_image_url — VARCHAR(300)
- created_at — TIMESTAMPTZ