TableActiveIngredient.java [src/java/wqm/utils] Revision: Date:
/*
* To change this license header, choose License Headers in Project Properties.
* To change this template file, choose Tools | Templates
* and open the template in the editor.
*/
package wqm.utils;
import data.table.column.ColumnInteger;
import data.table.column.ColumnString;
import data.table.Table;
/**
*
* @author <a href="mailto:shaun.case@colostate.edu">Shaun Case</a>
*/
public class TableActiveIngredient extends Table {
public static final String AI_ID = "ai_id";
public static final String AI_NAME = "ai_name";
public static final String HUM_PHR_LEACH = "op_phr_leach_human";
public static final String FISH_PHR_LEACH = "op_phr_leach_matcfish";
public static final String HUM_PHR_SORUN = "op_phr_sorun_human";
public static final String FISH_PHR_SORUN = "op_phr_sorun_matcfish";
public static final String HUM_PHR_ADRUN = "op_phr_adrun_human";
public static final String FISH_PHR_ADRUN = "op_phr_adrun_stvfish";
public static final String HUM_PHR_LEACH_NUMBER = "op_phr_leach_human_number";
public static final String FISH_PHR_LEACH_NUMBER = "op_phr_leach_matcfish_number";
public static final String HUM_PHR_SORUN_NUMBER = "op_phr_sorun_human_number";
public static final String FISH_PHR_SORUN_NUMBER = "op_phr_sorun_matcfish_number";
public static final String HUM_PHR_ADRUN_NUMBER = "op_phr_adrun_human_number";
public static final String FISH_PHR_ADRUN_NUMBER = "op_phr_adrun_stvfish_number";
private static final String[] AI_ID_DATA = {AI_ID, "Pesticide active ingredient database Id"};
private static final String[] AI_NAME_DATA = {AI_NAME, "Pesticide active ingredient name associated with the active ingredient database Id"};
private static final String[] HUM_PHR_LEACH_NUMBER_DATA = {HUM_PHR_LEACH_NUMBER, "Farm Operation Pesticide Leaching Hazard Rating - Humans"};
private static final String[] FISH_PHR_LEACH_NUMBER_DATA = {FISH_PHR_LEACH_NUMBER, "Farm Operation Pesticide Leaching Hazard Rating - Fish"};
private static final String[] HUM_PHR_SORUN_NUMBER_DATA = {HUM_PHR_SORUN_NUMBER, "Farm Operation Pesticide Solution Runoff Hazard Rating - Humans"};
private static final String[] FISH_PHR_SORUN_NUMBER_DATA = {FISH_PHR_SORUN_NUMBER, "Farm Operation Pesticide Solution Runoff Hazard Rating - Fish"};
private static final String[] HUM_PHR_ADRUN__NUMBER_DATA = {HUM_PHR_ADRUN_NUMBER, "Farm Operation Pesticide Adsorbed Runoff Hazard Rating - Humans"};
private static final String[] FISH_PHR_ADRUN_NUMBER_DATA = {FISH_PHR_ADRUN_NUMBER, "Farm Operation Pesticide Adsorbed Runoff Hazard Rating - Fish"};
private static final String[] HUM_PHR_LEACH_DATA = {HUM_PHR_LEACH, "Farm Operation Pesticide Leaching Hazard Rating - Humans"};
private static final String[] FISH_PHR_LEACH_DATA = {FISH_PHR_LEACH, "Farm Operation Pesticide Leaching Hazard Rating - Fish"};
private static final String[] HUM_PHR_SORUN_DATA = {HUM_PHR_SORUN, "Farm Operation Pesticide Solution Runoff Hazard Rating - Humans"};
private static final String[] FISH_PHR_SORUN_DATA = {FISH_PHR_SORUN, "Farm Operation Pesticide Solution Runoff Hazard Rating - Fish"};
private static final String[] HUM_PHR_ADRUN_DATA = {HUM_PHR_ADRUN, "Farm Operation Pesticide Adsorbed Runoff Hazard Rating - Humans"};
private static final String[] FISH_PHR_ADRUN_DATA = {FISH_PHR_ADRUN, "Farm Operation Pesticide Adsorbed Runoff Hazard Rating - Fish"};
public TableActiveIngredient() {
addDataColumn(AI_ID, new ColumnInteger(AI_ID_DATA));
addDataColumn(AI_NAME, new ColumnString(AI_NAME_DATA));
addDataColumn(HUM_PHR_LEACH, new ColumnString(HUM_PHR_LEACH_DATA));
addDataColumn(FISH_PHR_LEACH, new ColumnString(FISH_PHR_LEACH_DATA));
addDataColumn(HUM_PHR_SORUN, new ColumnString(HUM_PHR_SORUN_DATA));
addDataColumn(FISH_PHR_SORUN, new ColumnString(FISH_PHR_SORUN_DATA));
addDataColumn(HUM_PHR_ADRUN, new ColumnString(HUM_PHR_ADRUN_DATA));
addDataColumn(FISH_PHR_ADRUN, new ColumnString(FISH_PHR_ADRUN_DATA));
addDataColumn(HUM_PHR_LEACH_NUMBER, new ColumnInteger(HUM_PHR_LEACH_NUMBER_DATA));
addDataColumn(FISH_PHR_LEACH_NUMBER, new ColumnInteger(FISH_PHR_LEACH_NUMBER_DATA));
addDataColumn(HUM_PHR_SORUN_NUMBER, new ColumnInteger(HUM_PHR_SORUN_NUMBER_DATA));
addDataColumn(FISH_PHR_SORUN_NUMBER, new ColumnInteger(FISH_PHR_SORUN_NUMBER_DATA));
addDataColumn(HUM_PHR_ADRUN_NUMBER, new ColumnInteger(HUM_PHR_ADRUN__NUMBER_DATA));
addDataColumn(FISH_PHR_ADRUN_NUMBER, new ColumnInteger(FISH_PHR_ADRUN_NUMBER_DATA));
}
public void ai_id(int value) {
columns.get(AI_ID).setValue(value);
}
public int ai_id() {
return ((int) columns.get(AI_ID).getValue());
}
public void ai_name(String value) {
columns.get(AI_NAME).setValue(value);
}
public String ai_name() {
return ((String) columns.get(AI_NAME).getValue());
}
public void phr_leach_human(String value) {
columns.get(HUM_PHR_LEACH).setValue(value);
}
public String phr_leach_human() {
return ((String) columns.get(HUM_PHR_LEACH).getValue());
}
public void phr_leach_matcfish(String value) {
columns.get(FISH_PHR_LEACH).setValue(value);
}
public String phr_leach_matcfish() {
return ((String) columns.get(FISH_PHR_LEACH).getValue());
}
public void phr_sorun_human(String value) {
columns.get(HUM_PHR_SORUN).setValue(value);
}
public String phr_sorun_human() {
return ((String) columns.get(HUM_PHR_SORUN).getValue());
}
public void phr_sorun_matcfish(String value) {
columns.get(FISH_PHR_SORUN).setValue(value);
}
public String phr_sorun_matcfish() {
return ((String) columns.get(FISH_PHR_SORUN).getValue());
}
public void phr_adrun_human(String value) {
columns.get(HUM_PHR_ADRUN).setValue(value);
}
public String phr_adrun_human() {
return ((String) columns.get(HUM_PHR_ADRUN).getValue());
}
public void phr_adrun_stvfish(String value) {
columns.get(FISH_PHR_ADRUN).setValue(value);
}
public String phr_adrun_stvfish() {
return ((String) columns.get(FISH_PHR_ADRUN).getValue());
}
public void phr_leach_human_number(int value) {
columns.get(HUM_PHR_LEACH_NUMBER).setValue(value);
}
public int phr_leach_human_number() {
return ((int) columns.get(HUM_PHR_LEACH_NUMBER).getValue());
}
public void phr_leach_matcfish_number(int value) {
columns.get(FISH_PHR_LEACH_NUMBER).setValue(value);
}
public int phr_leach_matcfish_number() {
return ((int) columns.get(FISH_PHR_LEACH_NUMBER).getValue());
}
public void phr_sorun_human_number(int value) {
columns.get(HUM_PHR_SORUN_NUMBER).setValue(value);
}
public int phr_sorun_human_number() {
return ((int) columns.get(HUM_PHR_SORUN_NUMBER).getValue());
}
public void phr_sorun_matcfish_number(int value) {
columns.get(FISH_PHR_SORUN_NUMBER).setValue(value);
}
public int phr_sorun_matcfish_number() {
return ((int) columns.get(FISH_PHR_SORUN_NUMBER).getValue());
}
public void phr_adrun_human_number(int value) {
columns.get(HUM_PHR_ADRUN_NUMBER).setValue(value);
}
public int phr_adrun_human_number() {
return ((int) columns.get(HUM_PHR_ADRUN_NUMBER).getValue());
}
public void phr_adrun_stvfish_number(int value) {
columns.get(FISH_PHR_ADRUN_NUMBER).setValue(value);
}
public int phr_adrun_stvfish_number() {
return ((int) columns.get(FISH_PHR_ADRUN_NUMBER).getValue());
}
}