genetic_class_list

0 rows


Description

A list of valid Genetic Class Codes that indicate if a lot is collected from Parent Trees in an Orchard or from a natural stand.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
genetic_class_code varchar 1 null
seedlot.genetic_class_code seedlot_genetic_class_code_fk R
seedlot_audit.genetic_class_code Implied Constraint R
seedlot_seed_plan_zone.genetic_class_code fk_genetic_class_code R

A code describing various Genetic Classes.
description varchar 120 null

A description for the affiliated code.
effective_date date 13 null

The effective date the code is in effect
expiry_date date 13 null

The date the code expires on.
update_timestamp timestamp 29,6 √ CURRENT_TIMESTAMP

The date and time of the last update.

Indexes

Constraint Name Type Sort Column(s)
genetic_class_list_pk Primary key Asc genetic_class_code

Relationships

Close relationships within degrees of separation