Database Schema Documentation

See also: Database change tracking and upgrades

The BMS database, also referred to as IBDBV2, is a hybrid schema composed of the ICIS - International Crop Information System (ICIS) database and also the CHADO natural diversity model. The following diagram lists out the tables in the current schema categorised for ICIS vs CHADO origin. The relative 'domains' of the database are also highlighted. There are collections of tables that store data relating to a single real world concept that the application manages.

See expanded image here

Both schemas are designed to store semi-structured data.

Schema Diagrams

NOTE Right click the image and choose "Open image in new tab" or similar browser option to see full resolution image with zooming etc.

Full schema diagram

As you can see there are many tables in the full schema so it is hard to visualise in a single diagram. Following sections show diagrams of the core sub-modules of the schema.

Ontology Management System (OMS)

Data dictionary for Ontology Management Schema

Study Data Management System (DMS)

Data dictionary for Study Management Schema

Genealogy Management System (GMS)

Data dictionary for Germplasm Management Schema

Germplasm List Management Module

Data dictionary for List Management Schema

Inventory Management System (IMS)

Data dictionary for Inventory Management Schema

Genotypic Data Management System (GDMS)

Workbench

Data dictionary for Workbench Schema