trip_passengers
Data license: PDDL
2,673 rows sorted by pax_no
This data as json, CSV (advanced)
Suggested facets: justification, code, pax_no
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trip_passengers" ( "trip_id" text, "person_name" text, "department" text, "vp_div" text, "justification" text, "code" text, "pax_no" integer, PRIMARY KEY("trip_id","person_name"), CONSTRAINT "fk_trip_passengers_person" FOREIGN KEY("person_name") REFERENCES "people"("name"), CONSTRAINT "fk_trips_passengers" FOREIGN KEY("trip_id") REFERENCES "trips"("id") );