Generalized, abbreviated schematic of the PBDB database schema. Boxes labeled “Refs”
refer to a single table of references, to which individual data records are linked
(records are also linked to contributors). Field names ending in “_no” indicate unique
identifiers, stored internally as integers, but should be treated as strings
externally. The API can accept for these identifiers integers or a string form that
includes support for the Life Science Identifier specification (e.g., Dinosauria can
be referred to as either 52775, txn:52775, or urn:lsid:paleobiodb.org:txn:52775).
Lookup tables are computed nightly from primary data tables to improve performance of
API calls. Many relational tables are omitted for clarity.
Summary of operation types provided by PBDB API version 1.2. The URL prefix for
each operation is https://paleobiodb.org/data1.2/. Example operations
are given for each data type, including a suffix that specifies the format of the
returned data (i.e., “txt”, “json”, “ris”), and a question mark followed by
parameters that identify specific data of interest. See online documentation for
additional examples and documentation of all parameters and responses.