phantomknight287/aero

public

Implement OpenAPI documentation and enhance authentication featurescc012f32 years ago182 lines · 4.2 KB

1	// This is your Prisma schema file,
2	// learn more about it in the docs: https://pris.ly/d/prisma-schema
3
4	// Looking for ways to speed up your queries, or scale easily with your serverless or edge functions?
5	// Try Prisma Accelerate: https://pris.ly/cli/accelerate-init
6
7	generator client {
8	provider = "prisma-client-js"
9	previewFeatures = ["omitApi"]
10	}
11
12	datasource db {
13	provider = "postgresql"
14	url = env(
15	}
16
17	model User {
18	id String @id
19	name String
20	email String @unique
21	password String
22
23	createdAt DateTime @default
24	updatedAt DateTime @updatedAt
25
26	@@map("users")
27	}
28
29	enum AirportType {
30	small_airport
31	seaplane_base
32	medium_airport
33	large_airport
34	heliport
35	closed
36	balloonport
37	}
38
39	model Airport {
40	id String @id
41	ident String
42	type AirportType
43	elevation Decimal?
44	continent String
45	isoCountry String @map
46	isoRegion String @map
47	municipality String?
48	gpsCode String? @map
49	iataCode String? @map
50	name String
51	lat Decimal
52	long Decimal
53
54	createdAt DateTime @default
55	updatedAt DateTime @updatedAt
56
57	@@map("airports")
58	}
59
60	model Airline {
61	id String @id
62	name String
63	icao String
64	iata String
65
66	image String?
67
68	createdAt DateTime @default
69	updatedAt DateTime @updatedAt
70
71	@@map("airlines")
72	}
73
74	model Aircraft {
75	id String @id
76	aircraft_id String
77	reg String
78	hexIcao String? @map
79	modelCode String? @map
80	age Decimal?
81	firstFlightDate DateTime? @map
82	deliveryDate DateTime? @map
83	typeName String? @map
84	isFreighter Boolean @map
85	image String?
86	attribution String?
87	registrations AircraftRegistration[]
88
89	createdAt DateTime @default
90	updatedAt DateTime @updatedAt
91
92	@@map("aircrafts")
93	}
94
95	enum FlightType {
96	arrival
97	departure
98	}
99
100	enum FlightStatus {
101	scheduled
102	active
103	landed
104	cancelled
105	incident
106	diverted
107	unknown
108	}
109
110	model Flights {
111	id String @id
112
113	date DateTime
114	airline Json
115	arrival Json
116	codeshared Json?
117	departure Json
118	flight Json
119	type FlightType
120	status FlightStatus?
121
122	createdAt DateTime @default
123	updatedAt DateTime @updatedAt
124
125	@@map("flights")
126	}
127
128	model GreatCircleDistance {
129	id String @id
130
131	meter Decimal
132	km Decimal
133	mile Decimal
134	nm Decimal
135	feet Decimal
136
137	flight Flight @relation
138	flightId String @unique
139
140	createdAt DateTime @default
141	updatedAt DateTime @updatedAt
142
143	@@map("great_circle_distance")
144	}
145
146	model Flight {
147	id String @id
148
149	greatCircleDistance GreatCircleDistance?
150
151	flightNo String @map
152	aircraft Json
153	airline Json
154	arrival Json
155	departure Json
156	cargo Boolean @default
157	date DateTime
158	callSign String @map
159
160	createdAt DateTime @default
161	updatedAt DateTime @updatedAt
162
163	@@map("flight")
164	}
165
166	model AircraftRegistration {
167	id String @id
168
169	reg String
170	active Boolean
171	hexIcao String? @map
172	airlineName String? @map
173	registrationDate DateTime? @map
174
175	createdAt DateTime @default
176	updatedAt DateTime @updatedAt
177
178	Aircraft Aircraft? @relation
179	aircraftId String? @map
180
181	@@map("aircraft_registrations")
182	}