/*
 * 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.Table;
import data.table.column.ColumnInteger;
import data.table.column.ColumnString;

/**
 *
 * @author <a href="mailto:shaun.case@colostate.edu">Shaun Case</a>
 */
public class TablePesticide extends Table{

    public static final String PEST_ID = "pesticide_product_id";
    public static final String PEST_NAME = "pesticide_product_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[] PEST_ID_DATA = {PEST_ID, "Database Id of the product name (prod_name) and EPA registration number (reg_no) combination of the pesticide product selected to use"};
    private static final String[] PEST_NAME_DATA = {PEST_NAME, "Pesticide product name associated with the pesticide database id specified."};
    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 TablePesticide() {
        addDataColumn(PEST_ID, new ColumnInteger(PEST_ID_DATA));
        addDataColumn(PEST_NAME, new ColumnString(PEST_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 pest_id(int value) {
        columns.get(PEST_ID).setValue(value);
    }

    public int pest_id() {
        return ((int) columns.get(PEST_ID).getValue());
    }    
    
    public void pest_name(String value) {
        columns.get(PEST_NAME).setValue(value);
    }

    public String pest_name() {
        return ((String) columns.get(PEST_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());
    }    
}