seedlot_collection_method

0 rows


Description

The collection methods in which the cones of a Seedlot were collected.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
seedlot_number varchar 5 null
seedlot.seedlot_number seedlot_coll_met_seedlot_fk R

The unique number (key) assigned to a quantity of seed of a particular species and quality from a given location collected at a given time.
cone_collection_method_code int4 10 null
cone_collection_method_list.cone_collection_method_code seedlot_cone_col_met_code_fk R

A code representing the method in which the cones were collected.
cone_collection_method_other_desc varchar 50 √ null

A description of the method in which the cones were collected - used only when the user selects the option “Other”.
entry_userid varchar 30 null

The userid of the individual that entered the Seedlot collection method.
entry_timestamp timestamp 29,6 null

The time and date a Seedlot collection method was entered onto the system.
update_userid varchar 30 null

The userid of the individual that changed the Seedlot collection method.
update_timestamp timestamp 29,6 CURRENT_TIMESTAMP

The time and date a Seedlot collection method was last updated on the system.
revision_count int4 10 null

A counter used to ensure data integrity. This item should be incremented during each update.

Indexes

Constraint Name Type Sort Column(s)
seedlot_collection_method_pk Primary key Asc/Asc seedlot_number + cone_collection_method_code

Relationships

Close relationships within degrees of separation