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 
Active 
Clearance 
Inactive 
Obsolete 
Planned 
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.