capstone_data - 2025-11-02 10:19:12

Tables (11)

Data_merged (고유 번호 중심)

  • ID (id) — serial — Primary key — NOT NULL
  • ID (id2) — serial — Foreign key — NOT NULL
  • ID (id3) — serial — Foreign key — NOT NULL
  • ID (id4) — serial — Foreign key — NOT NULL
  • 고유 번호 (mb_sn) — text
  • 설문응답 (answer) — jsonb
  • 성별 (gender) — text
  • 나이 (age) — integer
  • 지역 (location) — text
  • 지역구 (detail_location) — text
  • 상세응답 (data) — jsonb
  • Field

embeddings (벡터DB)

  • ID (id) — serial — Primary key — NOT NULL
  • ID (id2) — serial — Foreign key — NOT NULL
  • ID (id22) — serial — Foreign key — NOT NULL
  • ID (id3) — serial — Foreign key — NOT NULL
  • ID (id4) — serial — Foreign key — NOT NULL
  • mb_sn (고유번호) — text
  • 임베딩값 (embedding) — vector

quick_answer (설문응답기록)

  • ID (id) — serial — Primary key — NOT NULL
  • 고유 번호 (mb_sn) — text
  • 설문응답 (answer) — jsonb
  • 성별 (gender) — text
  • 나이 (age) — integer
  • 지역 (location) — text

quick_question (질문목록)

  • ID (id) — serial — Primary key — NOT NULL
  • ID (id2) — serial — Foreign key — NOT NULL
  • qp설문날짜 (origin_qid) — text
  • 설문번호 (qid) — text
  • 질문 (question) — text

welcome_1st (기본정보)

  • ID (id) — serial — Primary key — NOT NULL
  • 고유 번호 (mb_sn) — text
  • 성별 (gender) — text
  • 출생년도 (birth_year) — text
  • 지역 (location) — text
  • 지역구 (detail_location) — text

welcome_2nd (상세정보)

  • ID (id) — serial — Primary key — NOT NULL
  • 고유 번호 (mb_sn) — text
  • 상세응답 (data) — jsonb

and 5 more tables