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