phantomknight287/aero

public

Rename project from 'aero' to 'PlanePal' and implement initial API structure40acf1a2 years ago108 lines · 2.1 KB

1	generator client {
2	provider = "prisma-client-js"
3	}
4
5	datasource db {
6	provider = "sqlite"
7	url = "file:./db/db.sqlite3"
8	}
9
10	model User {
11	id String @id
12	name String
13	email String
14	emailVerified Boolean
15	image String?
16	createdAt DateTime
17	updatedAt DateTime
18	sessions Session[]
19	accounts Account[]
20
21	@@unique([email])
22	@@map("user")
23	}
24
25	model Session {
26	id String @id
27	expiresAt DateTime
28	token String
29	createdAt DateTime
30	updatedAt DateTime
31	ipAddress String?
32	userAgent String?
33	userId String
34	user User @relation
35
36	@@unique([token])
37	@@map("session")
38	}
39
40	model Account {
41	id String @id
42	accountId String
43	providerId String
44	userId String
45	user User @relation
46	accessToken String?
47	refreshToken String?
48	idToken String?
49	accessTokenExpiresAt DateTime?
50	refreshTokenExpiresAt DateTime?
51	scope String?
52	password String?
53	createdAt DateTime
54	updatedAt DateTime
55
56	@@map("account")
57	}
58
59	model Verification {
60	id String @id
61	identifier String
62	value String
63	expiresAt DateTime
64	createdAt DateTime?
65	updatedAt DateTime?
66
67	@@map("verification")
68	}
69
70	model Jwks {
71	id String @id
72	publicKey String
73	privateKey String
74	createdAt DateTime
75
76	@@map("jwks")
77	}
78
79	model Airline {
80	id String @id
81
82	name String
83	iata String
84	icao String
85
86	createdAt DateTime?
87	updatedAt DateTime?
88	}
89
90	model Airport {
91	id String @id
92	ident String
93	type String
94	elevation Int?
95	continent String?
96	iso_country String?
97	iso_region String?
98	municipality String?
99	gps_code String?
100	iata_code String?
101	local_code String?
102	name String
103	lat Decimal?
104	long Decimal?
105
106	createdAt DateTime @default
107	updatedAt DateTime @updatedAt
108	}