PDM 2018 - NOT Workgroup or EPDM.

I want to do some querying of file names directly in the PDM tables. No modifications, just selects. I see the tables Paths and Documents but how are the two linked together? How does PDM keep track of what files are in what paths?