Image

Image

Logical Entity Name	Image
Default Table Name	images
Owner	garden
Definition	Image provides information to access and use an image.. An image may be a graphic depiction of a type of cultivar or it may be a photograph usually of a bed. In either case the image includes sizing information and the name of the image stored as a graphic file in a folder accessible by Python.

Image Attributes

Attribute/Logical Rolename Domain Datatype NULL Definition

Image Name (PK) Name NVARCHAR(50) NO The name of a ,png file in the plant_images folder within the Python folder.. This is used by software to associate an image with a plant in a display.

Image Subject Code Code-1Char CHAR(1) YES Indicates the subject of an image.
C - Cultivar Usually a drawing
B - Bed Always a photo

Image Type Type NVARCHAR(3) NO Distinguishes one type of an image from another, Values are:
S - Single pic
R - Row of pics
C - Column of pics

Image Label Name NVARCHAR(50) YES The display label for the image..

Image Width Count INTEGER YES The relative width of the Image using a standard single plant image as a basic unit. For example a row of peas might be displayed as one unit high and 8 units wide.

Image Height Count INTEGER YES The relative height of the image using a single plant image as a basis. For example images of columns containg many plants such as beets and peas have an image height of 5. Tall plants like dill and brussels sprouts have an image height of 2.

Attribute/Logical Rolename	Domain	Datatype	NULL	Definition
Image Name	Name	NVARCHAR(50)	NO	The name of a ,png file in the plant_images folder within the Python folder.. This is used by software to associate an image with a plant in a display.
Image Subject Code	Code-1Char	CHAR(1)	YES	Indicates the subject of an image. C - Cultivar Usually a drawing B - Bed Always a photo
Image Type	Type	NVARCHAR(3)	NO	Distinguishes one type of an image from another, Values are: S - Single pic R - Row of pics C - Column of pics
Image Label	Name	NVARCHAR(50)	YES	The display label for the image..
Image Width	Count	INTEGER	YES	The relative width of the Image using a standard single plant image as a basic unit. For example a row of peas might be displayed as one unit high and 8 units wide.
Image Height	Count	INTEGER	YES	The relative height of the image using a single plant image as a basis. For example images of columns containg many plants such as beets and peas have an image height of 5. Tall plants like dill and brussels sprouts have an image height of 2.