prisma/schema.prisma


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61

// This is your Prisma schema file,
// learn more about it in the docs: https://pris.ly/d/prisma-schema

generator client {
  provider = "prisma-client-py"
  recursive_type_depth = 5
}

datasource db {
  provider = "sqlite"
  url      = "file:../data/database.db" 
}

model User {
  id BigInt @id
  questions_correct Int @default(0)
  questions_incorrect Int @default(0)
  category_breakdown CategoryBreakdown?
}

model CategoryBreakdown {
  userId BigInt @unique
  user User @relation(fields: [userId], references: [id])
  id Int @id @default(autoincrement())

  literature_correct Int @default(0)
  literature_incorrect Int @default(0)
  
  history_correct Int @default(0)
  history_incorrect Int @default(0)
  
  science_correct Int @default(0)
  science_incorrect Int @default(0)
  
  fine_arts_correct Int @default(0)
  fine_arts_incorrect Int @default(0)

  religion_correct Int @default(0)
  religion_incorrect Int @default(0)
  
  mythology_correct Int @default(0)
  mythology_incorrect Int @default(0)

  philosophy_correct Int @default(0)
  philosophy_incorrect Int @default(0)
  
  social_science_correct Int @default(0)
  social_science_incorrect Int @default(0)

  current_events_correct Int @default(0)
  current_events_incorrect Int @default(0)

  geography_correct Int @default(0)
  geography_incorrect Int @default(0)

  other_academic_correct Int @default(0)
  other_academic_incorrect Int @default(0)

  trash_correct Int @default(0)
  trash_incorrect Int @default(0)
}