Plant Position

Plant Position

Logical Entity Name	Plant Position
Default Table Name	plant_positions
Owner	garden
Definition	Plant Position provides the position of one or more instances of a particular plant in a display of a box in a planting bed.. By our gardener's convention, position is based on vertical and horizontal distance in the territory unit of measure from the southwest (upper left) corner of a garden box.

Plant Position Attributes

Attribute/Logical Rolename Domain Datatype NULL Definition

Bed Name (PK)(FK) Name NVARCHAR(50) NO The name of the Bed containing the Box.

Box Name NVARCHAR(50) NO The name of the Box where the Plant is located.

Plant Sequence (PK) Sequence SMALLINT NO Identifier for a plant display within a garden Box. This is assigned by the software as Plants get added to the Box.

Location Name (FK) Location NVARCHAR(35) NO The name of the Location that is hosting the Planting Container.

Planting Id (FK) Sequence INTEGER NO The identifier for a planting.

Location Start Date (FK) Date DATE NO The date the Location became host to the Planting in the Container.

Cultivar ID NVARCHAR(35) YES The identifier for the Cultivar that is linked to a specific graphic Image in the cultivar_images table.

Image Type Code-1Char CHAR(1) YES Distinguishes one type of an image from another, It is used to support having more than one graphic for a cultivar
Values are:
S - Single pic
R - Row of pics
C - Column of pics

Plant X Distance Distance NUMERIC(7, 1) YES Distance of the plant in the territory unit of measure on the x-axis from the base point of the Box. In the garden database the base point is the southwest corner of the Box.

Plant Y Distance Distance NUMERIC(7, 1) YES The distance of the plant in the territory unit of measure on the y-axis from the base point of the box.

Plant Count Count INTEGER YES The number of plants associated with the display in the Plant Location.

Plant Status Code Status NVARCHAR(1) NO The status of the plant illustration in the display.
A - Active The gardener wants to see the plant in the display of a Box in a Bed.
O - Obselete. The illustration is no longer relevant and should be removed from the display.

Plant Status Date Date DATE YES The effective date of the Plant Status Code.

Attribute/Logical Rolename	Domain	Datatype	NULL	Definition
Bed Name	Name	NVARCHAR(50)	NO	The name of the Bed containing the Box.
Box Name		NVARCHAR(50)	NO	The name of the Box where the Plant is located.
Plant Sequence	Sequence	SMALLINT	NO	Identifier for a plant display within a garden Box. This is assigned by the software as Plants get added to the Box.
Location Name	Location	NVARCHAR(35)	NO	The name of the Location that is hosting the Planting Container.
Planting Id	Sequence	INTEGER	NO	The identifier for a planting.
Location Start Date	Date	DATE	NO	The date the Location became host to the Planting in the Container.
Cultivar ID		NVARCHAR(35)	YES	The identifier for the Cultivar that is linked to a specific graphic Image in the cultivar_images table.
Image Type	Code-1Char	CHAR(1)	YES	Distinguishes one type of an image from another, It is used to support having more than one graphic for a cultivar Values are: S - Single pic R - Row of pics C - Column of pics
Plant X Distance	Distance	NUMERIC(7, 1)	YES	Distance of the plant in the territory unit of measure on the x-axis from the base point of the Box. In the garden database the base point is the southwest corner of the Box.
Plant Y Distance	Distance	NUMERIC(7, 1)	YES	The distance of the plant in the territory unit of measure on the y-axis from the base point of the box.
Plant Count	Count	INTEGER	YES	The number of plants associated with the display in the Plant Location.
Plant Status Code	Status	NVARCHAR(1)	NO	The status of the plant illustration in the display. A - Active The gardener wants to see the plant in the display of a Box in a Bed. O - Obselete. The illustration is no longer relevant and should be removed from the display.
Plant Status Date	Date	DATE	YES	The effective date of the Plant Status Code.