Database questions re: Users

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.

Thanks!