Entity relationship diagram for GlycomeDB. This diagram represents some of the schemata, tables and connectivities incorporated in GlycomeDB (see text for details). The name at the top of each table has the format schema_name.table_name. All m-to-n tables are simply represented by this name within a yellow box; other tables are shown with a list of the important attributes. Primary keys of the tables are indicated with green markers while foreign keys have red markers. Labels describing the cardinalities of the relationships between tables are given in the modified Chen notation ("1" = one, "mc" = zero, one or many). The top section of the diagram illustrates the relationships between taxonomic annotations (blue background) and structures (red background). The original structures and the GlycoCT translation are linked to each other via the remote.remote_structure_has_structure table. The tables in the orange section represent the dictionaries for the residues used and their associations with the original structures. The green section includes the GlycoCT basetypes and substituents which have relationships with the GlycoCT-encoded structures.
Ranzinger et al. BMC Bioinformatics 2008 9:384 doi:10.1186/1471-2105-9-384