[InterMine Dev] Questions on production database schema
julie at flymine.org
Fri Aug 2 15:34:11 BST 2013
Dataset as in the InterMine "dataset" object? Or are you trying to find
out which data parser loaded which object?
If it's the latter, you can do this:
select distinct objectid from tracker where source_name = 'uniprot';
The object id is the InterMine ID.
The `bag` tables are created when a user makes a list. When the user
logs in the list is transferred to the userprofile, I think.
On 02/08/13 15:13, JD Wong wrote:
> Hi Dev,
> I'm looking more closely at my mine's production database, and I was
> wondering a few things I hope someone here can shed some light on.
> How are dataset tables linked to data, can i write an SQL query along
> the lines of " which records are in this dataset"?
> There are also a bunch of bag tables like:
> public | integer_bag_1019 | table | intermine
> public | integer_bag_1020 | table | intermine
> public | integer_bag_1021 | table | intermine
> public | integer_bag_228 | table | intermine
> public | integer_bag_229 | table | intermine
> public | integer_bag_231 | table | intermine
> there many of these, and for string_bag too, does anyone know what they
> are for?
> Thank you!
> dev mailing list
> dev at intermine.org
More information about the dev