model Questionnaire_data {
  id                Int            @id
  question          String
  control           String[]
  sub_control       String[]
  created_at        DateTime       @default(now())
  updated_at        DateTime?      @updatedAt
  workspace_id      String
  policy_id         Int
  workspaces        Workspaces     @relation(fields: [workspace_id], references: [workspace_id])
  questions         Questionnaire  @relation(fields: [id], references: [question_id])
  policies          Policies       @relation(fields: [policy_id], references: [id])

  @@map("questionnaire_data")
}

model Policies {
  id               Int            @id @default(autoincrement())
  resource_uri     String?
  control          String[]
  sub_control      String[]
  created_by       Int
  created_at       DateTime       @default(now())
  status           policy_status?
  name             String?        @unique
  workspace_id     String
  company_id       String
  updated_at       DateTime?      @updatedAt
  workspaces       Workspaces     @relation(fields: [workspace_id], references: [workspace_id])
  users            Users          @relation(fields: [created_by], references: [user_id])
  companies        Companies      @relation(fields: [company_id], references: [company_id])

  Questionnaire_data Questionnaire_data[]
  @@map("policies")
}

const question_data = await prisma.questionnaire_data.create({
        data: {
          control: control,
          sub_control: sub_control,
          policies: {
            connectOrCreate: {
              create: {
                name: policy,
                control: control,
                sub_control: sub_control,
                status: 'Approval_Pending',
                workspace_id: String(workspace_id),
                company_id: String(company_id),
                created_by: user_id
              },
              where: { name: policy }
            }
          },
          question: question_string,
          status: status,
          workspace_id: String(workspace_id),


        }
      })