Tables

Names of people who collected each accession.

Locations where seeds were collected.

(Enum) Types of seeds that can be tested for viability. This refers to how the seeds were stored, not the physical characteristics of the seeds themselves.

Historical record of when accessions moved to different states. A row is inserted here for every state transition.

(Enum) Types of source plants that seeds can be collected from.

Information about batches of seeds. An accession is a batch of seeds of the same species collected in the same time and place by the same people.

Information about a single batch of seeds being tested for viability. This is the information about the test itself; the results are represented in the viability_test_results table.

Result from a viability test of a batch of seeds. Viability tests can have multiple germinations, e.g., if different seeds germinate on different days.

(Enum) Available states an accession can be in. Each state represents a step in the seed management workflow.

(Enum) Original sources of data, e.g., manual entry via web app.

(Enum) Types of tests that can be performed on seeds to check for viability.

(Enum) Types of operations that can result in changes to remaining quantities of accessions.

Individual bags of seeds that are part of an accession. An accession can consist of multiple bags.

Linking table between accessions and files.

(Enum) Reasons that someone can withdraw seeds from a seed bank.

Information about seeds that have been withdrawn from a seed bank. Each time someone withdraws seeds, a new row is inserted here.

Historical record of changes to remaining quantities of accessions.

(Enum) Available units in which seeds can be measured. For weight-based units, includes unit conversion information.

(Enum) Types of substrate that can be used to test seeds for viability.