trip_crew
Data license: PDDL
1,635 rows
This data as json, CSV (advanced)
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`));