trip_crew
Data license: PDDL
2 rows where trip_id = 060231
This data as json, CSV (advanced)
Link | trip_id | person_name |
---|---|---|
060231,Jeffrey Paul Buffington | 060231 | Jeffrey Paul Buffington |
060231,Thomas Blaise Tallerico | 060231 | Thomas Blaise Tallerico |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE `trip_crew` (`trip_id` text,`person_name` text,PRIMARY KEY (`trip_id`,`person_name`),CONSTRAINT `fk_trip_crew_trip` FOREIGN KEY (`trip_id`) REFERENCES `trips`(`id`),CONSTRAINT `fk_trip_crew_person` FOREIGN KEY (`person_name`) REFERENCES `people`(`name`));