Table Structure

Following is the list of tables in the database. Click on table name to view the structure of the table.

• Contact
  • Organisation
  • Contact
• Site
  • Location
  • Site Type
  • Meteorology Station
  • Site 
  • Site Year
• Genotype
  • Crop (Genus)
  • Genotype
• Trial
  • Trial Type
  • Operation Type
  • Design Type
  • Unit Position of Trial Unit
  • Treatment
  • Sample Type for Raw Data
  • Trial
  • Trial Operation 
  • Trial Unit of Trial Design
  • Raw Data (Sample Measurement)
• Analysis
  • Analysis of Variance (AOV)
  • Multi Environment Trial (MET) Analysis
• System
  • Sub-system
  • System Group
  • System User
  • Column and Column Alias
  • Virtual Column and Virtual Column Alias
  • Trait and Trait Alias
  • Misc Group (for Datagrid and Export Wizard)
  • Reserved Keywords
  • System Queries (for future expansion)