/*
 * 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());
    }
}