Cultivar ID |
Base Entity | Lot |
Attribute Name | Cultivar ID |
Logical Rolename | |
ColumnName | cultivar_id |
RoleName | |
Definition | The Identifier for a cultivar. The structure is modeled on the Territorial Seed prototype which has an alpha abbreviation followed by a number. For example, Dragon Tongue mustard is MU522.. |
Lot Reference |
Base Entity | Lot |
Attribute Name | Lot Reference |
Logical Rolename | |
ColumnName | lot_ref |
RoleName | |
Definition | Lot Reference distinguishes one Lot from another for a given cultivar. Normally the year assigned to a packet of seeds by a vendor or the year seeds were collected iprovides uniqueness.,Typically this is all the gardener needs. In some cases gardeners collect multiple lots for a Cultivar for a given year and use year plus -1, -2, and so on if they want to tell one lot from another. |
Lot Unit Name |
Base Entity | Lot |
Attribute Name | Lot Unit Name |
Logical Rolename | |
ColumnName | lot_unit_name |
RoleName | |
Definition | The form or packaging that we acquire cultivar starts..Typically this would be a packet of seeds or a box of seedlings or a Bag of seeds from a prior harvest. |
Lot Unit Name Reference Value (Bound to Domain) |
Name | LotUnit |
Description | |
Type | By List |
Value | Value Description |
Packet | Packet of seeds |
Pad | Pad containing 50 seeds |
Bag | Harvested seeds |
Tape | Tape with embedded seeds |
Bundle | Bundle of starts such as cuttings, leeks, onions, etc. |
Box | Box containing one or more plants from another garden. |
Envelope | For tiny seeds. Comes inside packet. |
pot3x3 | Holder for purchased seedlings |
Planter | Host for volunteer seedlings |
Branch | Source for cuttings |
Pod | seedholder from parent Lot |
Bed | Host for volunteer seedlings |
Bulb | One or more bulbs ready to plant. |
Lot Unit Count |
Base Entity | Lot |
Attribute Name | Lot Unit Count |
Logical Rolename | |
ColumnName | lot_unit_count |
RoleName | |
Definition | Count of units originally in the lot. Typically this would be the number of packets of seeds. It might be the number of boxes of seedlings in a purchase or a count of seed disks. |
Planting Unit Name |
Base Entity | Lot |
Attribute Name | Planting Unit Name |
Logical Rolename | |
ColumnName | planting_unit_name |
RoleName | |
Definition | The name of the thing being planted. Normally, this would be seeds bot it might be seedlings, sets or something else. (see reference values). |
Planting Unit Name Reference Value (Bound to Domain) |
Name | Planting Unit |
Description | |
Type | By List |
Value | Value Description |
Pad | seeds set in a pad |
Plant | growing plant for transplant |
Quad | group of four seeds cut from a pad |
Seed | seeds |
Seedling | germinated cultivar ready to plant |
Setting | bulb such as onion setting |
Start | purchased start ready to transplant |
Tape | seeds set in a row |
Planting Unit Count |
Base Entity | Lot |
Attribute Name | Planting Unit Count |
Logical Rolename | |
ColumnName | planting_unit_count |
RoleName | |
Definition | The number of seeds or other planting units in all of the lot units for the lot.. |
Lot Vendor_ID |
Base Entity | Lot |
Attribute Name | Lot Vendor_ID |
Logical Rolename | |
ColumnName | lot_vendor_id |
RoleName | |
Definition | The identifier assigned by the vendor or other source for this Lot. |
Lot_Status Code |
Base Entity | Lot |
Attribute Name | Lot_Status Code |
Logical Rolename | |
ColumnName | lot_status_cd |
RoleName | |
Definition | A Lot may be Pending, In stock, or Out of stock., |
Lot_Status Code Reference Value (Bound to Domain) |
Name | Lot Status |
Description | Specify states for a Garden Lot |
Type | By List |
Value | Value Description |
O | Ordered |
A | Active |
I | Inactive |
Lot Year |
Base Entity | Lot |
Attribute Name | Lot Year |
Logical Rolename | |
ColumnName | lot_year |
RoleName | |
Definition | The optimal planting Year for the Lot. Normally this is the year after the seeds in the Lot were harvested. |
Lot Source |
Base Entity | Lot |
Attribute Name | Lot Source |
Logical Rolename | |
ColumnName | lot_source |
RoleName | |
Definition | The source of the lot. Normally this will be the name of whoever packaged the seeds or the location or harvest where the seeds were collected. |
Lot Description |
Base Entity | Lot |
Attribute Name | Lot Description |
Logical Rolename | |
ColumnName | lot_description |
RoleName | |
Definition | Optional narrative explaining relevant information about the lot. |