Database Properties
Database Type: PostgreSQL - 17.4 (Debian 17.4-1.pgdg110+2)
Tables
| Table / View | Children | Parents | Columns | Rows | Type | Comments |
|---|---|---|---|---|---|---|
| accession_collectors | 0 | 1 | 3 | -1 | Table | Names of people who collected each accession. |
| geolocations | 0 | 1 | 6 | -1 | Table | Locations where seeds were collected. |
| viability_test_seed_types | 1 | 0 | 2 | -1 | Table | (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. |
| accession_state_history | 0 | 4 | 6 | -1 | Table | Historical record of when accessions moved to different states. A row is inserted here for every state transition. |
| collection_sources | 1 | 0 | 2 | -1 | Table | (Enum) Types of source plants that seeds can be collected from. |
| accessions | 9 | 15 | 45 | -1 | Table | 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. |
| viability_tests | 2 | 5 | 16 | -1 | Table | 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 |
| accession_states | 3 | 0 | 3 | -1 | Table | (Enum) Available states an accession can be in. Each state represents a step in the seed management workflow. |
| viability_test_results | 0 | 1 | 4 | -1 | 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. |
| data_sources | 1 | 0 | 2 | -1 | Table | (Enum) Original sources of data, e.g., manual entry via web app. |
| accession_quantity_history_types | 1 | 0 | 2 | -1 | Table | (Enum) Types of operations that can result in changes to remaining quantities of accessions. |
| viability_test_types | 1 | 0 | 2 | -1 | Table | (Enum) Types of tests that can be performed on seeds to check for viability. |
| bags | 0 | 1 | 3 | -1 | Table | Individual bags of seeds that are part of an accession. An accession can consist of multiple bags. |
| accession_photos | 0 | 2 | 2 | -1 | Table | Linking table between |
| withdrawal_purposes | 1 | 0 | 2 | -1 | Table | (Enum) Reasons that someone can withdraw seeds from a seed bank. |
| withdrawals | 0 | 8 | 19 | -1 | Table | Information about seeds that have been withdrawn from a seed bank. Each time someone withdraws seeds, a new row is inserted here. |
| accession_quantity_history | 0 | 4 | 8 | -1 | Table | Historical record of changes to remaining quantities of accessions. |
| seed_quantity_units | 8 | 0 | 2 | -1 | Table | (Enum) Available units in which seeds can be measured. For weight-based units, includes unit conversion information. |
| viability_test_substrates | 1 | 0 | 2 | -1 | Table | (Enum) Types of substrate that can be used to test seeds for viability. |