Pivot table / has_many relationship

Hey all. I have a table that is structured as:

create table Question {
  id uuid,
  question string,
}

create table Answer {
  id uuid,
  question_id uuid,
  answer string
}

create table Question {
  id uuid,
  question string,
}

create table Answer {
  id uuid,
  question_id uuid,
  answer string
}

one question HAS MANY answers. We're getting the data as:

{
  questions: [{ 
    id: 123, 
    question: "...", 
    answers: [{...}]
  }, { 
    id: 123,
    question: "...", 
    answers: [{...}]
  }]
}

{
  questions: [{ 
    id: 123, 
    question: "...", 
    answers: [{...}]
  }, { 
    id: 123,
    question: "...", 
    answers: [{...}]
  }]
}

I'd like the headers to be the "question" fields, and need to pivot answers to be row based. Is there an easy way to do this? Or any advice on how to solve it?

TanStack•4y ago•

2 replies

spotty-amber

Pivot table / has_many relationship

Hey all. I have a table that is structured as:

create table Question {
  id uuid,
  question string,
}

create table Answer {
  id uuid,
  question_id uuid,
  answer string
}

create table Question {
  id uuid,
  question string,
}

create table Answer {
  id uuid,
  question_id uuid,
  answer string
}

one question HAS MANY answers. We're getting the data as:

{
  questions: [{ 
    id: 123, 
    question: "...", 
    answers: [{...}]
  }, { 
    id: 123,
    question: "...", 
    answers: [{...}]
  }]
}

{
  questions: [{ 
    id: 123, 
    question: "...", 
    answers: [{...}]
  }, { 
    id: 123,
    question: "...", 
    answers: [{...}]
  }]
}

I'd like the headers to be the "question" fields, and need to pivot answers to be row based. Is there an easy way to do this? Or any advice on how to solve it?

Pivot table / has_many relationship

Similar Threads

Pivot table / has_many relationship

Similar Threads

Similar Threads

Similar Threads