biologicalstatus


Description

Based on Multi Crop Passport Descriptors (MCPD V2 2012) - The coding scheme proposed can be used at 3 different levels of detail: either by using the
general codes (in boldface) such as 100, 200, 300, 400, or by using the more specific codes
such as 110, 120, etc.
100) Wild
110) Natural
120) Semi-natural/wild
130) Semi-natural/sown
200) Weedy
300) Traditional cultivar/landrace
400) Breeding/research material
410) Breeder’s line
411) Synthetic population
412) Hybrid
413) Founder stock/base population
414) Inbred line (parent of hybrid cultivar)
415) Segregating population
416) Clonal selection
420) Genetic stock
421) Mutant (e.g. induced/insertion mutants, tilling populations)
422) Cytogenetic stocks (e.g. chromosome addition/substitution, aneuploids,
amphiploids)
423) Other genetic stocks (e.g. mapping populations)
500) Advanced or improved cultivar (conventional breeding methods)
600) GMO (by genetic engineering)
999) Other

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT 10 √ null
germinatebase.biologicalstatus_id germinatebase_ibfk_biologicalstatusN

Primary id for this table. This uniquely identifies the row.
sampstat VARCHAR 255 null

Previoulsy known as sampstat.
created_on DATETIME 26 √ CURRENT_TIMESTAMP

When the record was created.
updated_on TIMESTAMP 26 √ CURRENT_TIMESTAMP

When the record was updated. This may be different from the created on date if subsequent changes have been made to the underlying record.

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id

Relationships

Close relationships within degrees of separation