QLdLVgVC

1CREATE TABLE IF NOT EXISTS "calendar_dates" (
2  "service_id" varchar(100),
3  "date" decimal(10,2),
4  "exception_type" decimal(10,2)
5);
6
7CREATE TABLE IF NOT EXISTS "routes" (
8  "route_id" int PRIMARY KEY,
9  "route_short_name" varchar(15),
10  "route_long_name" varchar(15),
11  "route_type" int,
12  "route_color" varchar(6),
13  "route_text_color" varchar(6)
14);
15
16CREATE TABLE IF NOT EXISTS "stop_times" (
17  "trip_id" varchar(11),
18  "arrival_time" varchar(8),
19  "departure_time" varchar(8),
20  "stop_id" int,
21  "stop_sequence" int,
22  FOREIGN KEY (trip_id) REFERENCES "trips" (trip_id)
23);
24
25CREATE TABLE IF NOT EXISTS "stops" (
26  "stop_id" int PRIMARY KEY,
27  "stop_name" varchar(100),
28  "stop_lat" double,
29  "stop_lon" double
30);
31
32CREATE TABLE IF NOT EXISTS "trips" (
33  "route_id" int,
34  "service_id" varchar(15),
35  "trip_id" varchar(12) PRIMARY KEY,
36  "trip_headsign" varchar(19),
37  "trip_short_name" int,
38  "direction_id" int,
39  "shape_id" int,
40  FOREIGN KEY (route_id) REFERENCES "routes" (route_id)
41);
42
43CREATE INDEX IF NOT EXISTS trips_route_id_index ON "trips" ("route_id");