-
-
Notifications
You must be signed in to change notification settings - Fork 38
/
Copy pathschema.prisma
86 lines (72 loc) · 1.57 KB
/
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
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
// This is your Prisma schema file,
// learn more about it in the docs: https://pris.ly/d/prisma-schema
generator client {
provider = "prisma-client-js"
}
datasource db {
provider = "mysql"
url = env("DATABASE_URL")
relationMode = "prisma"
}
model Cache {
key String @id
value Json
updatedAt DateTime @updatedAt
}
model Scraped {
key String @id
value Json
updatedAt DateTime @updatedAt
}
model ScrapedTrue {
key String @id
value Json
updatedAt DateTime @updatedAt
}
model Search {
key String @id
value Json
updatedAt DateTime @updatedAt
}
model Cast {
id String @id @default(uuid())
imdbId String
userId String
hash String
url String
updatedAt DateTime @updatedAt
duration Int @default(0)
bitrate Int @default(0)
size Int @default(0)
mediaInfo Json?
@@index([imdbId, userId, updatedAt])
@@unique([imdbId, userId, hash])
}
model Titles {
imdbid String @id
title String
is_original_title Boolean
year Int
@@unique([imdbid, is_original_title])
@@unique([imdbid, title])
}
model Anime {
id Int @id @default(autoincrement())
anidb_id Int? @unique
anime_planet_id String? @unique
kitsu_id Int? @unique
mal_id Int? @unique
imdb_id String? @unique
title String
type String
aliases Json
description String @db.Text
poster_url String
background_url String
rating Float
@@index([anidb_id])
@@index([anime_planet_id])
@@index([kitsu_id])
@@index([mal_id])
@@index([imdb_id])
}