table column Container

LabKey Support Forum (Inactive)
table column Container wnels2  2009-04-15 06:26
Status: Closed
 
In the demo module there is a "Container ENTITYID NOT NULL" column in the example table. It is included in the query filter when ever this table is queried. This does not seem to be universal across all of the modules. What are the best practices and why?

Thanks,
Bill
 
 
jeckels responded:  2009-04-15 10:26
Hi Bill,

Almost every module should have tables with a container column. There are a few cases where there is data that is shared across all the folders on a server, like the proteins loaded from FASTA files, but the vast majority is segmented into folders to make it easier to organize.

If a table contains data that is tied to data in another table, we'll usually just store the container on the parent table. For example, MS2 peptide identifications are always loaded in the context of an MS2 run, so we store the container on the run table, not the peptides table.

Thanks,
Josh