Page MenuHomeGitPull.it
Differential D83 Diff 287 assets/schemas/it.reyboz.bustorino.data.gtfs.GtfsDatabase/2.json

Changeset View

Standalone View

View Options

assets/schemas/it.reyboz.bustorino.data.gtfs.GtfsDatabase/2.json

  • This file was added.
{
"formatVersion": 1,
"database": {
"version": 2,
"identityHash": "6d2aa826894d1e6b1429678e13b65433",
"entities": [
{
"tableName": "gtfs_feeds",
"createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`feed_id` TEXT NOT NULL, PRIMARY KEY(`feed_id`))",
"fields": [
{
"fieldPath": "gtfsId",
"columnName": "feed_id",
"affinity": "TEXT",
"notNull": true
}
],
"primaryKey": {
"columnNames": [
"feed_id"
],
"autoGenerate": false
},
"indices": [],
"foreignKeys": []
},
{
"tableName": "gtfs_agencies",
"createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`gtfs_id` TEXT NOT NULL, `ag_name` TEXT NOT NULL, `ag_url` TEXT NOT NULL, `fare_url` TEXT, `phone` TEXT, `feed_id` TEXT, PRIMARY KEY(`gtfs_id`))",
"fields": [
{
"fieldPath": "gtfsId",
"columnName": "gtfs_id",
"affinity": "TEXT",
"notNull": true
},
{
"fieldPath": "name",
"columnName": "ag_name",
"affinity": "TEXT",
"notNull": true
},
{
"fieldPath": "url",
"columnName": "ag_url",
"affinity": "TEXT",
"notNull": true
},
{
"fieldPath": "fareUrl",
"columnName": "fare_url",
"affinity": "TEXT",
"notNull": false
},
{
"fieldPath": "phone",
"columnName": "phone",
"affinity": "TEXT",
"notNull": false
},
{
"fieldPath": "feed.gtfsId",
"columnName": "feed_id",
"affinity": "TEXT",
"notNull": false
}
],
"primaryKey": {
"columnNames": [
"gtfs_id"
],
"autoGenerate": false
},
"indices": [],
"foreignKeys": []
},
{
"tableName": "gtfs_calendar_dates",
"createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`service_id` TEXT NOT NULL, `date` TEXT NOT NULL, `exception_type` INTEGER NOT NULL, PRIMARY KEY(`service_id`, `date`), FOREIGN KEY(`service_id`) REFERENCES `gtfs_calendar`(`service_id`) ON UPDATE NO ACTION ON DELETE CASCADE )",
"fields": [
{
"fieldPath": "serviceID",
"columnName": "service_id",
"affinity": "TEXT",
"notNull": true
},
{
"fieldPath": "date",
"columnName": "date",
"affinity": "TEXT",
"notNull": true
},
{
"fieldPath": "exceptionType",
"columnName": "exception_type",
"affinity": "INTEGER",
"notNull": true
}
],
"primaryKey": {
"columnNames": [
"service_id",
"date"
],
"autoGenerate": false
},
"indices": [],
"foreignKeys": [
{
"table": "gtfs_calendar",
"onDelete": "CASCADE",
"onUpdate": "NO ACTION",
"columns": [
"service_id"
],
"referencedColumns": [
"service_id"
]
}
]
},
{
"tableName": "stops_gtfs",
"createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`stop_id` INTEGER NOT NULL, `stop_code` TEXT NOT NULL, `stop_name` TEXT NOT NULL, `stop_desc` TEXT NOT NULL, `stop_lat` REAL NOT NULL, `stop_lon` REAL NOT NULL, `wheelchair_boarding` TEXT NOT NULL, PRIMARY KEY(`stop_id`))",
"fields": [
{
"fieldPath": "internalID",
"columnName": "stop_id",
"affinity": "INTEGER",
"notNull": true
},
{
"fieldPath": "gttStopID",
"columnName": "stop_code",
"affinity": "TEXT",
"notNull": true
},
{
"fieldPath": "stopName",
"columnName": "stop_name",
"affinity": "TEXT",
"notNull": true
},
{
"fieldPath": "gttPlaceName",
"columnName": "stop_desc",
"affinity": "TEXT",
"notNull": true
},
{
"fieldPath": "latitude",
"columnName": "stop_lat",
"affinity": "REAL",
"notNull": true
},
{
"fieldPath": "longitude",
"columnName": "stop_lon",
"affinity": "REAL",
"notNull": true
},
{
"fieldPath": "wheelchair",
"columnName": "wheelchair_boarding",
"affinity": "TEXT",
"notNull": true
}
],
"primaryKey": {
"columnNames": [
"stop_id"
],
"autoGenerate": false
},
"indices": [],
"foreignKeys": []
},
{
"tableName": "gtfs_calendar",
"createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`service_id` TEXT NOT NULL, `monday` INTEGER NOT NULL, `tuesday` INTEGER NOT NULL, `wednesday` INTEGER NOT NULL, `thursday` INTEGER NOT NULL, `friday` INTEGER NOT NULL, `saturday` INTEGER NOT NULL, `sunday` INTEGER NOT NULL, `start_date` TEXT NOT NULL, `end_date` TEXT NOT NULL, PRIMARY KEY(`service_id`))",
"fields": [
{
"fieldPath": "serviceID",
"columnName": "service_id",
"affinity": "TEXT",
"notNull": true
},
{
"fieldPath": "onMonday",
"columnName": "monday",
"affinity": "INTEGER",
"notNull": true
},
{
"fieldPath": "onTuesday",
"columnName": "tuesday",
"affinity": "INTEGER",
"notNull": true
},
{
"fieldPath": "onWednesday",
"columnName": "wednesday",
"affinity": "INTEGER",
"notNull": true
},
{
"fieldPath": "onThursday",
"columnName": "thursday",
"affinity": "INTEGER",
"notNull": true
},
{
"fieldPath": "onFriday",
"columnName": "friday",
"affinity": "INTEGER",
"notNull": true
},
{
"fieldPath": "onSaturday",
"columnName": "saturday",
"affinity": "INTEGER",
"notNull": true
},
{
"fieldPath": "onSunday",
"columnName": "sunday",
"affinity": "INTEGER",
"notNull": true
},
{
"fieldPath": "startDate",
"columnName": "start_date",
"affinity": "TEXT",
"notNull": true
},
{
"fieldPath": "endDate",
"columnName": "end_date",
"affinity": "TEXT",
"notNull": true
}
],
"primaryKey": {
"columnNames": [
"service_id"
],
"autoGenerate": false
},
"indices": [],
"foreignKeys": []
},
{
"tableName": "routes_table",
"createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`route_id` TEXT NOT NULL, `agency_id` TEXT NOT NULL, `route_short_name` TEXT NOT NULL, `route_long_name` TEXT NOT NULL, `route_desc` TEXT NOT NULL, `route_mode` TEXT NOT NULL, `route_color` TEXT NOT NULL, `route_text_color` TEXT NOT NULL, PRIMARY KEY(`route_id`))",
"fields": [
{
"fieldPath": "gtfsId",
"columnName": "route_id",
"affinity": "TEXT",
"notNull": true
},
{
"fieldPath": "agencyID",
"columnName": "agency_id",
"affinity": "TEXT",
"notNull": true
},
{
"fieldPath": "shortName",
"columnName": "route_short_name",
"affinity": "TEXT",
"notNull": true
},
{
"fieldPath": "longName",
"columnName": "route_long_name",
"affinity": "TEXT",
"notNull": true
},
{
"fieldPath": "description",
"columnName": "route_desc",
"affinity": "TEXT",
"notNull": true
},
{
"fieldPath": "mode",
"columnName": "route_mode",
"affinity": "TEXT",
"notNull": true
},
{
"fieldPath": "color",
"columnName": "route_color",
"affinity": "TEXT",
"notNull": true
},
{
"fieldPath": "textColor",
"columnName": "route_text_color",
"affinity": "TEXT",
"notNull": true
}
],
"primaryKey": {
"columnNames": [
"route_id"
],
"autoGenerate": false
},
"indices": [],
"foreignKeys": []
},
{
"tableName": "gtfs_stop_times",
"createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`trip_id` TEXT NOT NULL, `arrival_time` TEXT NOT NULL, `departure_time` TEXT NOT NULL, `stop_id` INTEGER NOT NULL, `stop_sequence` INTEGER NOT NULL, PRIMARY KEY(`trip_id`, `stop_id`), FOREIGN KEY(`stop_id`) REFERENCES `stops_gtfs`(`stop_id`) ON UPDATE NO ACTION ON DELETE CASCADE , FOREIGN KEY(`trip_id`) REFERENCES `gtfs_trips`(`trip_id`) ON UPDATE NO ACTION ON DELETE CASCADE )",
"fields": [
{
"fieldPath": "tripID",
"columnName": "trip_id",
"affinity": "TEXT",
"notNull": true
},
{
"fieldPath": "arrivalTime",
"columnName": "arrival_time",
"affinity": "TEXT",
"notNull": true
},
{
"fieldPath": "departureTime",
"columnName": "departure_time",
"affinity": "TEXT",
"notNull": true
},
{
"fieldPath": "stopID",
"columnName": "stop_id",
"affinity": "INTEGER",
"notNull": true
},
{
"fieldPath": "stopSequence",
"columnName": "stop_sequence",
"affinity": "INTEGER",
"notNull": true
}
],
"primaryKey": {
"columnNames": [
"trip_id",
"stop_id"
],
"autoGenerate": false
},
"indices": [
{
"name": "index_gtfs_stop_times_stop_id",
"unique": false,
"columnNames": [
"stop_id"
],
"orders": [],
"createSql": "CREATE INDEX IF NOT EXISTS `index_gtfs_stop_times_stop_id` ON `${TABLE_NAME}` (`stop_id`)"
}
],
"foreignKeys": [
{
"table": "stops_gtfs",
"onDelete": "CASCADE",
"onUpdate": "NO ACTION",
"columns": [
"stop_id"
],
"referencedColumns": [
"stop_id"
]
},
{
"table": "gtfs_trips",
"onDelete": "CASCADE",
"onUpdate": "NO ACTION",
"columns": [
"trip_id"
],
"referencedColumns": [
"trip_id"
]
}
]
},
{
"tableName": "gtfs_trips",
"createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`route_id` TEXT NOT NULL, `service_id` TEXT NOT NULL, `trip_id` TEXT NOT NULL, `trip_headsign` TEXT NOT NULL, `direction_id` INTEGER NOT NULL, `block_id` TEXT NOT NULL, `shape_id` TEXT NOT NULL, `wheelchair_accessible` INTEGER NOT NULL, `limited_route` INTEGER NOT NULL, PRIMARY KEY(`trip_id`), FOREIGN KEY(`route_id`) REFERENCES `routes_table`(`route_id`) ON UPDATE NO ACTION ON DELETE CASCADE )",
"fields": [
{
"fieldPath": "routeID",
"columnName": "route_id",
"affinity": "TEXT",
"notNull": true
},
{
"fieldPath": "serviceID",
"columnName": "service_id",
"affinity": "TEXT",
"notNull": true
},
{
"fieldPath": "tripID",
"columnName": "trip_id",
"affinity": "TEXT",
"notNull": true
},
{
"fieldPath": "tripHeadsign",
"columnName": "trip_headsign",
"affinity": "TEXT",
"notNull": true
},
{
"fieldPath": "directionID",
"columnName": "direction_id",
"affinity": "INTEGER",
"notNull": true
},
{
"fieldPath": "blockID",
"columnName": "block_id",
"affinity": "TEXT",
"notNull": true
},
{
"fieldPath": "shapeID",
"columnName": "shape_id",
"affinity": "TEXT",
"notNull": true
},
{
"fieldPath": "isWheelchairAccess",
"columnName": "wheelchair_accessible",
"affinity": "INTEGER",
"notNull": true
},
{
"fieldPath": "isLimitedRoute",
"columnName": "limited_route",
"affinity": "INTEGER",
"notNull": true
}
],
"primaryKey": {
"columnNames": [
"trip_id"
],
"autoGenerate": false
},
"indices": [
{
"name": "index_gtfs_trips_route_id",
"unique": false,
"columnNames": [
"route_id"
],
"orders": [],
"createSql": "CREATE INDEX IF NOT EXISTS `index_gtfs_trips_route_id` ON `${TABLE_NAME}` (`route_id`)"
}
],
"foreignKeys": [
{
"table": "routes_table",
"onDelete": "CASCADE",
"onUpdate": "NO ACTION",
"columns": [
"route_id"
],
"referencedColumns": [
"route_id"
]
}
]
},
{
"tableName": "gtfs_shapes",
"createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`shape_id` TEXT NOT NULL, `shape_pt_lat` REAL NOT NULL, `shape_pt_lon` REAL NOT NULL, `shape_pt_sequence` INTEGER NOT NULL, PRIMARY KEY(`shape_id`, `shape_pt_sequence`))",
"fields": [
{
"fieldPath": "shapeID",
"columnName": "shape_id",
"affinity": "TEXT",
"notNull": true
},
{
"fieldPath": "pointLat",
"columnName": "shape_pt_lat",
"affinity": "REAL",
"notNull": true
},
{
"fieldPath": "pointLon",
"columnName": "shape_pt_lon",
"affinity": "REAL",
"notNull": true
},
{
"fieldPath": "pointSequence",
"columnName": "shape_pt_sequence",
"affinity": "INTEGER",
"notNull": true
}
],
"primaryKey": {
"columnNames": [
"shape_id",
"shape_pt_sequence"
],
"autoGenerate": false
},
"indices": [],
"foreignKeys": []
},
{
"tableName": "mato_patterns",
"createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`pattern_name` TEXT NOT NULL, `pattern_code` TEXT NOT NULL, `pattern_hash` TEXT NOT NULL, `pattern_direction_id` INTEGER NOT NULL, `pattern_route_id` TEXT NOT NULL, `pattern_headsign` TEXT, `pattern_polyline` TEXT NOT NULL, `pattern_polylength` INTEGER NOT NULL, PRIMARY KEY(`pattern_code`), FOREIGN KEY(`pattern_route_id`) REFERENCES `routes_table`(`route_id`) ON UPDATE NO ACTION ON DELETE CASCADE )",
"fields": [
{
"fieldPath": "name",
"columnName": "pattern_name",
"affinity": "TEXT",
"notNull": true
},
{
"fieldPath": "code",
"columnName": "pattern_code",
"affinity": "TEXT",
"notNull": true
},
{
"fieldPath": "semanticHash",
"columnName": "pattern_hash",
"affinity": "TEXT",
"notNull": true
},
{
"fieldPath": "directionId",
"columnName": "pattern_direction_id",
"affinity": "INTEGER",
"notNull": true
},
{
"fieldPath": "routeGtfsId",
"columnName": "pattern_route_id",
"affinity": "TEXT",
"notNull": true
},
{
"fieldPath": "headsign",
"columnName": "pattern_headsign",
"affinity": "TEXT",
"notNull": false
},
{
"fieldPath": "patternGeometryPoly",
"columnName": "pattern_polyline",
"affinity": "TEXT",
"notNull": true
},
{
"fieldPath": "patternGeometryLength",
"columnName": "pattern_polylength",
"affinity": "INTEGER",
"notNull": true
}
],
"primaryKey": {
"columnNames": [
"pattern_code"
],
"autoGenerate": false
},
"indices": [],
"foreignKeys": [
{
"table": "routes_table",
"onDelete": "CASCADE",
"onUpdate": "NO ACTION",
"columns": [
"pattern_route_id"
],
"referencedColumns": [
"route_id"
]
}
]
},
{
"tableName": "patterns_stops",
"createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`pattern_gtfs_id` TEXT NOT NULL, `stop_gtfs_id` TEXT NOT NULL, `stop_order` INTEGER NOT NULL, PRIMARY KEY(`pattern_gtfs_id`, `stop_gtfs_id`, `stop_order`), FOREIGN KEY(`pattern_gtfs_id`) REFERENCES `mato_patterns`(`pattern_code`) ON UPDATE NO ACTION ON DELETE CASCADE )",
"fields": [
{
"fieldPath": "patternId",
"columnName": "pattern_gtfs_id",
"affinity": "TEXT",
"notNull": true
},
{
"fieldPath": "stopGtfsId",
"columnName": "stop_gtfs_id",
"affinity": "TEXT",
"notNull": true
},
{
"fieldPath": "order",
"columnName": "stop_order",
"affinity": "INTEGER",
"notNull": true
}
],
"primaryKey": {
"columnNames": [
"pattern_gtfs_id",
"stop_gtfs_id",
"stop_order"
],
"autoGenerate": false
},
"indices": [],
"foreignKeys": [
{
"table": "mato_patterns",
"onDelete": "CASCADE",
"onUpdate": "NO ACTION",
"columns": [
"pattern_gtfs_id"
],
"referencedColumns": [
"pattern_code"
]
}
]
}
],
"views": [],
"setupQueries": [
"CREATE TABLE IF NOT EXISTS room_master_table (id INTEGER PRIMARY KEY,identity_hash TEXT)",
"INSERT OR REPLACE INTO room_master_table (id,identity_hash) VALUES(42, '6d2aa826894d1e6b1429678e13b65433')"
]
}
}
No newline at end of file
Public contents are in Creative Commons Attribution-ShareAlike 4.0 (CC-BY-SA) or GNU Free Documentation License (at your option) unless otherwise noted. · Contact / Register