Location Name |
Base Entity | Planting Location |
Attribute Name | Location Name |
Logical Rolename | |
ColumnName | location_name |
RoleName | |
Definition | The name of the Location that is hosting the Planting Container. |
Location Name Reference Value (Bound to Domain) |
Name | Garden Location |
Description | |
Type | By List |
Value | Value Description |
Cloche | In a cloche on the deck |
Deck | Upper Deck on the house |
Fridge | In the refrigeratorKi |
Jeanne | Martin house in Port Townsend |
KitchenNE | Northeast Kitchen Bed |
KiychenSE | Southeast Kitchen Bed |
KitchenE | Northeast and Southeast Kitchen beds |
KitchenNC | North Center Kitchen bed |
KitchenSC | South Center Kitchen Bed |
KitchenC | North and South Center Kitchen Beds |
KitchenNW | Northwest Kitchen Bed |
KitchenSW | Southwest Kitchen Bed |
KitchenW | Northwest and Southwest Kitchen beds |
FlowerN | Flower bed North of Stairs |
FlowerS | Flower bed south of Stairs |
Tacoma | Mary House in Tacoma |
Utility-Lights | Under grow lights in the utility room |
Cherry Tree | Cherry Tree flower bed |
Location Start Date |
Base Entity | Planting Location |
Attribute Name | Location Start Date |
Logical Rolename | |
ColumnName | location_start_date |
RoleName | |
Definition | The date the Location became host to the Planting in the Container. |
Planting Id |
Base Entity | Planting Location |
Attribute Name | Planting Id |
Logical Rolename | |
ColumnName | planting_id |
RoleName | |
Definition | The identifier for a planting. |
Location Start Count |
Base Entity | Planting Location |
Attribute Name | Location Start Count |
Logical Rolename | |
ColumnName | location_start_count |
RoleName | |
Definition | The count of planting units at the Cultivar when the Location became host to the Planting in the Container Type |
Location Current Count |
Base Entity | Planting Location |
Attribute Name | Location Current Count |
Logical Rolename | |
ColumnName | location_current_count |
RoleName | |
Definition | The current count of plants from the planting at this location. This may be reduced by transplants from or compost from the location. Also, it may be edited. |
Container Unit Count |
Base Entity | Planting Location |
Attribute Name | Container Unit Count |
Logical Rolename | |
ColumnName | container_unit_count |
RoleName | |
Definition | Count of containers for the planting hosted at the location. |
Reason |
Base Entity | Planting Location |
Attribute Name | Reason |
Logical Rolename | |
ColumnName | reason |
RoleName | |
Definition | The reason for including the planting at the Location. |
Tag Code |
Base Entity | Planting Location |
Attribute Name | Tag Code |
Logical Rolename | |
ColumnName | tag_code |
RoleName | |
Definition | Tag Code supports monitoring specific plants or groups of plants at a location. Tag Code value is assigned and managed by the gardener. |
Location Status Code |
Base Entity | Planting Location |
Attribute Name | Location Status Code |
Logical Rolename | |
ColumnName | location_status_code |
RoleName | |
Definition | The current status of the planting at the location. G - Germinating M - Maturing H - Harvest I - Interim pending fix P - Pending final transplant O- Obsolete, planting gone |
Location Status Code Reference Value (Bound to Domain) |
Name | Status |
Description | |
Type | By List |
Value | Value Description |
A | Active |
C | Clearance |
I | Inactive |
O | Obsolete |
P | Planned |
R | Reference Only |
Location Status Date |
Base Entity | Planting Location |
Attribute Name | Location Status Date |
Logical Rolename | |
ColumnName | location_status_date |
RoleName | |
Definition | The date that the current status became effective. |