foolaunch

테이블 (15)

1순위 (Untitled)

    2순위 (Untitled2)

      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