I am trying to understand the Drupal database schema because I need to access the database via MySQL by another system and I do not have access to the original Drupal developer of the site nor do I know Drupal well at this point (I did work with it 8 years ago) and it will be much easier to access with MySQL than to set up a server to have to host a PHP-based API or similar.
file_managed table there is a field
uri where the data all appears to be in the same of two formats:
My two questions related to
- What is
public://mean here? Does it translate to some root URL like
- When there is a directory in the
uri, what do they represent?
UPDATE: I do not have access to the working Drupal system, I only have access to the database.