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.
        
    
    
 | 
                   
                
              
             
           |