Hi,
I'm not really sure what is the best place to post this question.
Is there a table in the database that links user id to the item id? Or, is there a query I can run to get that information? I quickly looked at the tables I thought would contain this information, but didn't see.
Thanks!
Omeka Item objects have a method that will return the User object for the user who created the item.
$user = $item->getUserWhoCreated();
If you're looking for a more technical description, these kinds of mappings between users and other Omeka objects are handled by the entities_relations
and entity_relationships
tables.
We're in the process of moving to a simpler structure for storing these relationships, but this is how it stands now.