Show field labels |
Show database names
DB Table Name |
plantName
|
Table |
Plant Name
|
Notes |
This table stores plant names
|
Field | DB Field Name | Req'd? | Data Type | Misc Flag | List? | Definition |
ID
|
PLANTNAME_ID
|
no
|
serial
|
PK
|
no
|
Database assigned value to each unique record in the plantName table.
|
Plant Name
|
plantName
|
required
|
varchar (255)
|
n/a
|
no
|
The plant name.
|
Reference
|
reference_ID
|
no
|
Integer
|
FK
|
no
|
Foreign key into the reference table to identify the original source of the name (usually the type description).
|
Date Entered
|
dateEntered
|
no
|
Date
|
n/a
|
no
|
Field stores the date that the name was entered into the database.
|
|