Logical Entity Name  Transplant 
Default Table Name  transplants 
Owner  garden 
Definition  A transplant is a planting that has been transferred from one type of container to another.
Typically a seedling will be transplanted into one or more intermediate containers before ending up the container (bed or planter) where it will mature.
A Planting may have any number of Transplants
A Transplant has one Transplant From Planting  

Transplant Attributes 
Attribute/Logical Rolename  Domain  Datatype  NULL  Definition 
Planting Id(PK)(FK)  Sequence  INTEGER  NO  The identifier for a planting. 
Transplant From Planting Id(FK)  Sequence  INTEGER  NO  The source planting for the transplant. 
Transplant Date  Date  DATE  NO  The date that a plant was transplanted from one container to another 
Transplant From Container Count  Count  INTEGER  NO  Count of containers that were consumed to support the transplant..This is important to keep track of one location's plantings being transplanted to multiple locations. 
Transplant Tme  Time  CHAR(8)  NO  Time in format hh:mm [am | pm] that the transplant occurred. This provides a basis for one of the factors that may affect the success of the transplanted cultivars.