Plant

Plant

Logical Entity Name	Plant
Default Table Name	plants
Owner	garden
Definition	A Plant is a planting that consists of a single plant. It makes it possible to track a plant in a pot wherever it may be moved.It also supports maintaining an inventory of perennials such as trees on a tree by tree basis.

Plant Attributes

Attribute/Logical Rolename Domain Datatype NULL Definition

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

Plant Tag Code Identifier-Code NVARCHAR(15) YES A tag to distinguish one Plant from another. The prototype tag code is a three digit number assigned by Puget Sound Energy to trees on the boundary of the map.

Plant Size Count Count Small SMALLINT NO The size in the specified unit of measure of some aspect of the plant.

Attribute/Logical Rolename	Domain	Datatype	NULL	Definition
Planting Id	Sequence	INTEGER	NO	The identifier for a planting.
Plant Tag Code	Identifier-Code	NVARCHAR(15)	YES	A tag to distinguish one Plant from another. The prototype tag code is a three digit number assigned by Puget Sound Energy to trees on the boundary of the map.
Plant Size Count	Count Small	SMALLINT	NO	The size in the specified unit of measure of some aspect of the plant.