Table in the Database

There are 2 categories of the table that can be used in Katmandoo.

• Table that store data of the column (NOT VIRTUAL COLUMN) in the database
• Table that store data of the Virtual Column in the database

These tables contain the column (NOT VIRTUAL COLUMN) in the database. Since it is part of the database structure, we can not add new column using Katmandoo (but the system developer can modify the table if required).

Table Name	Remarks
ActivityLog	Stores activity information of users.
AuthorisedGenus	Stores permission of System Group on Genus.
AuthorisedResource	Stores permission of System Group on Resource (ie table).
AuthorisedSystemGroup	Stores System Group of system users.
Contact	Stores contact information.
DesignType	Stores Design type information.
Factor	Stores System Column and Virutal Column information.
FactorAlias	Stores Alias for System Column and Virutal Column.
FactorSubSystem	Stores Validation Rule for System Column and Virutal Column.
Genotype	Stores Genotype, selection history and pedigree information.
GenotypeAlias	Stores Alias for Genotype.
GenotypeTrait	Stores Genotype specific Trait performance.
Genus	Stores Genus information.
GroupType	Stores Group Type information.
Location	Stores Location information.
METGroup	Stores MET (Multi Environment Trial Analysis) Group information.
METGroupEGV	Stores MET (Multi Environment Trial Analysis) Group EGV data.
METGroupTrial	Stores MET (Multi Environment Trial Analysis) Group Trial information.
MetStation	Stores Meteorology Station information.
METSubGroup	Stores MET (Multi Environment Trial Analysis) Sub-group information.
MiscGroup	Stores Misc Group information.
MiscGroupFactorSubSystem	Stores System Column and Virtual Column list for the Misc Groups.
MultiEnvTrial	Stores MET (Multi Environment Trial Analysis) information.
OperationType	Stores Operation Type information.
Organisation	Stores Organisation information.
ReservedKeyword	Stores Reserved Keywords.
SampleMeasurement	Stores Raw Data for each trait+sampletype+trial unit.
SampleType	Stores Sample Type information.
Site	Stores Site information.
SiteSubSystem	Stores List of sites that can be used with different Sub-systems.
SiteType	Stores Site Type information.
SiteYear	Stores Site Year (annual information of site such as rain fall, cooperator etc) information.
SubSystem	Stores Sub-system information.
SubSystemFactor	Stores Sub-system options.
SystemGroup	Stores System Groups information.
SystemQuery	Stores System Queries.
SystemResource	Stores System Resources (eg table) information.
SystemRole	Stores System Roles.
SystemUser	Stores System Users.
Trait	Stores Trait information.
TraitAlias	Stores Alias for Trait.
TraitSubSystem	Stores Validation rules for Trait.
Treatment	Stores Treatment information.
Trial	Stores Trial Meta-data (header) information.
TrialAnalysis	Stores Trial Analysis meta-data (header) information.
TrialAOV	Stores Trial AOV (Analysis of Variance).
TrialMean	Stores Genotype Means within a trial.
TrialOperation	Stores Trial Operation Meta-data (header) information.
TrialOpsMeasurement	Stores Trait Measurements recorded on each Trial Operation.
TrialType	Stores Trial Type information.
TrialTypeGenotype	Stores Genotype List for each Trial Type.
TrialUnit	Stores Trial Units of Trial Design.
UnitPosition	Stores Unit Position information.
Variate	Stores Variate information.
VariateOperator	Stores Variate Operator information.

These tables are used to store data for the respective virtual column and has FactorId, FactorValue and Primary Key of the Parent table in which the table is dependant.

For example, TrialFactor table has these columns

Column Name	Column Description	Data Example
FactorId	Id that identifies a virtual column	101 (Average Plot Length)
TrialId	Id that identifies a trial for which data of the virtual column is being store on this record.	2.01 (Trial Acronym: WRSA08COWA)
FactorValue	Data of the virtual column	6.21

While adding virtual column select one of the table name list below so that data of the virtual column are stored in the selected table.

Table Name	Remarks
ContactFactor	Stores data for virtual columns of Contact.
GenotypeFactor	Stores data for virtual columns of Genotype.
LocationFactor	Stores data for virtual columns of Location.
METGroupEGVFactor	Stores data for virtual columns of MET Group EGV.
MetStationFactor	Stores data for virtual columns of Meteorology Station.
METSubGroupFactor	Stores data for virtual columns of MET SubGroup.
SiteFactor	Stores data for virtual columns of Site.
SiteYearFactor	Stores data for virtual columns of Site Year.
TreatmentFactor	Stores data for virtual columns of Treatment.
TrialAnalysisFactor	Stores data for virtual columns of Trial Analysis.
TrialAOVFactor	Stores data for virtual columns of Trial AOV.
TrialDesignParameter	Stores data for parameters of Trial Design.
TrialFactor	Stores data for virtual columns of Trial.
TrialOpsFactor	Stores data for virtual columns of Trial Operation.
TrialOpsTreatment	Stores data for virtual columns of Trial Operation Treatment.
UnitPositionFactor	Stores data for virtual columns of Unit Position. Design factors of the trial should use this table name.