viability_tests

-1 rows


Description

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.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id int8 19 √ null
viability_test_results.test_id viability_test_results_test_id_fkey C
withdrawals.viability_test_id withdrawals_viability_test_id_fkey C
accession_id int8 19 null
accessions.id viability_tests_accession_id_fkey C
test_type int4 10 null
viability_test_types.id germination_test_test_type_fkey R
start_date date 13 √ null
seed_type_id int4 10 √ null
viability_test_seed_types.id germination_test_seed_type_id_fkey R
substrate_id int4 10 √ null
viability_test_substrates.id germination_test_substrate_id_fkey R
treatment_id int4 10 √ null
seed_treatments.id germination_test_treatment_id_fkey R
seeds_sown int4 10 √ null
notes text 2147483647 √ null
staff_responsible text 2147483647 √ null
total_seeds_germinated int4 10 √ null
total_percent_germinated int4 10 √ null
end_date date 13 √ null
seeds_compromised int4 10 √ null
seeds_empty int4 10 √ null
seeds_filled int4 10 √ null

Indexes

Constraint Name Type Sort Column(s)
viability_tests_pkey Primary key Asc id
viability_test__accession_id_ix Performance Asc accession_id

Check Constraints

Constraint Name Constraint
viability_tests_notes_check (notes !~ similar_to_escape(' *'::text))
viability_tests_staff_responsible_check (staff_responsible !~ similar_to_escape(' *'::text))

Relationships

Close relationships within degrees of separation