BMS system-specific cvterms
List of cvterms used intrinsically within the BMS.
References:
https://leafnode.atlassian.net/wiki/display/CD/BMS-16+List+of+CVterms+used+for+Column+Headers+in+BMS
A. Cvterms used to facilitate the retrieval of column headers from ontology:
| cvterm_id | cv_id | name | definition | new column |
|---|---|---|---|---|
| 1700 | 1000 | AVAIL INV | Available inventory | Yes |
| 1701 | 1000 | BREEDING METHOD NAME | Breeding method name | Yes |
| 1702 | 1000 | BREEDING METHOD ABBREVIATION | Breeding method abbreviation | Yes |
| 1703 | 1000 | BREEDING METHOD NUMBER | Breeding method number | Yes |
| 1704 | 1000 | BREEDING METHOD GROUP | Breeding method group | Yes |
| 1705 | 1000 | CROSS-FEMALE GID | Cross-female gid | Yes |
| 1706 | 1000 | CROSS-FEMALE PREFERRED NAME | Cross-female preferred name | Yes |
| 1707 | 1000 | CROSS-MALE GID | Cross-male gid | Yes |
| 1708 | 1000 | CROSS-MALE PREFERRED NAME | Cross-male preferred name | Yes |
| 1709 | 1000 | GERMPLASM DATE | Germplasm Date | Yes |
| 1711 | 1000 | PREFERRED ID | Preferred ID | Yes |
| 1712 | 1000 | PREFERRED NAME | Preferred Name | Yes |
| 1713 | 1000 | SEED RES | Seed reservation | Yes |
| 1714 | 1000 | COMMENT | Comment on inventory | Yes |
| 1715 | 1000 | LOT_ID | LOT Identification | Yes |
| 1716 | 1000 | NEW RES | Newly reserved inventory | Yes |
| 1717 | 1000 | RES | Reserved inventory | Yes |
| 1718 | 1000 | TOTAL | Total inventory | Yes |
| 1719 | 1000 | UNITS | Inventory units | Yes |
| 1720 | 1000 | LOCATION | Lot location | Yes |
| 1721 | 1000 | SCALE | Inventory Scale | Yes |
| 1722 | 1000 | AMOUNT | Inventory Amount | Yes |
| 1723 | 1000 | FEMALE PARENT | Name of Female Parent | Yes |
| 1724 | 1000 | MALE PARENT | Name of Male Parent | Yes |
| 1725 | 1000 | FGID | GID of Female Parent | Yes |
| 1726 | 1000 | MGID | GID of Male Parent | Yes |
| 1727 | 1000 | STOCKID | ID of an inventory deposit | Yes |
| 1728 | 1000 | DUPLICATE | Duplicate notes | Yes |
| 1729 | 1000 | BULK WITH | Stock IDs of stock list for bulking | Yes |
| 1730 | 1000 | BULK COMPL? | Is bulking completed? | Yes |
| 8200 | 1040 | PLOT_NO | Field plot - enumerated (number) | No |
| 8250 | 1040 | DESIGNATION | Germplasm identifier - assigned (DBCV) | No |
| 8300 | 1040 | ENTRY_CODE | Germplasm ID - Assigned (Code) | No |
| 8230 | 1040 | ENTRY_NO | Germplasm entry - enumerated (number) | No |
| 8240 | 1040 | GID | Germplasm identifier - assigned (DBID) | No |
| 8377 | 1040 | CROSS | The pedigree string of the germplasm | No |
| 8360 | 1040 | SEED_SOURCE | Seed source - Selected (Code) | No |
| 8255 | 1040 | ENTRY_TYPE | Entry type (test/check)- assigned (type) | No |
| 8400 | 1040 | FIELDMAP COLUMN | Column coordinate of plot in fieldplan | No |
| 8410 | 1040 | FIELDMAP RANGE | Row coordinate of plot in fieldplan | No |
| 1731 | 1000 | GROUP ID | Group ID of a germplasm | Yes |
B. Cvterms added via Liquibase
| cvterm_id | cv_id | name | definition | dB changelog |
|---|---|---|---|---|
| 8165 | 1040 | EXPT_DESIGN_SOURCE | Source of the experimental design. For example the name of csv file used for custom or preset designs. | 4_0_0_BETA_08.xml |
| 1900 | 1000 | has analysis variable | Relationship between a standard variable and a derived analysis variable | 4_0_0_BETA_09.xml |