Tables


SchemaSpy Analysis of terraware.seedbank

Generated on Thu Apr 03 22:26 GMT 2025

XML Representation
Insertion Order Deletion Order
TABLES 19
VIEWS 0
COLUMNS 131
Constraints 42
Anomalies 0
Routines 0

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.

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.

collection_sources 1 0 2 -1 Table

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

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 viability_test_results table.

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 accessions and files.

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.