/*
 * 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 m.ahat;

import csip.ServiceException;
import data.table.Table;
import data.table.column.ColumnBoolean;
import data.table.column.ColumnDouble;
import data.table.column.ColumnInteger;
import database.ahat.AHATcrdb;
import java.sql.SQLException;

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

    public static final String SWINE_HEATING_FUEL_TYPE = "swine_heating_fuel_type";
    public static final String UNIT_ELECTRIC_COST = "unit_electric_cost";
    public static final String FARROWING_CRATES = "farrowing_crates";
    public static final String MONTHS_USE_FARROWING_HEATER = "months_use_farrowing_heater";
    public static final String FARROWING_ANNUAL_FUEL_USE = "farrowing_annual_fuel_use";
    public static final String FEEDER_PIGS = "feeder_pigs";
    public static final String MONTHS_USE_NURSERY_HEATER = "months_use_nursery_heater";
    public static final String NURSERY_FUEL_USE = "nursery_fuel_use";
    public static final String FINISHING_PIGS = "finishing_pigs";
    public static final String MONTHS_USE_FINISHING_HEATER = "months_use_finishing_heater";
    public static final String FINISHING_FUEL_USE = "finishing_fuel_use";
    public static final String FARROWING_LIGHTING_TYPE = "farrowing_lighting_type";
    public static final String FARROWING_VENTILATION_SYSTEM = "farrowing_ventilation_system";
    public static final String FARROWING_FAN_BLADES_SHUTTERS = "farrowing_fan_blades_shutters";
    public static final String FARROWING_FAN_MOTORS_BELTS = "farrowing_fan_motors_belts";
    public static final String FARROWING_HEATING_SYSTEM_TYPE = "farrowing_heating_system_type";
    public static final String MINIMIZE_FARROWING_HOUSE_DRAFTS = "minimize_farrowing_house_drafts";
    public static final String INSULATE_FARROWING_HOUSE = "insulate_farrowing_house";
    public static final String NURSERY_LIGHTING_TYPE = "nursery_lighting_type";
    public static final String NURSERY_VENTILATION_SYSTEM = "nursery_ventilation_system";
    public static final String NURSERY_FAN_BLADES_SHUTTERS = "nursery_fan_blades_shutters";
    public static final String NURSERY_FAN_MOTORS_BELTS = "nursery_fan_motors_belts";
    public static final String NURSERY_HEATING_SYSTEM_TYPE = "nursery_heating_system_type";
    public static final String MINIMIZE_NURSERY_HOUSE_DRAFTS = "minimize_nursery_house_drafts";
    public static final String INSULATE_NURSERY_HOUSE = "insulate_nursery_house";
    public static final String FINISHING_LIGHTING_TYPE = "finishing_lighting_type";
    public static final String FINISHING_VENTILATION_SYSTEM = "finishing_ventilation_system";
    public static final String FINISHING_FAN_BLADES_SHUTTERS = "finishing_fan_blades_shutters";
    public static final String FINISHING_FAN_MOTORS_BELTS = "finishing_fan_motors_belts";
    public static final String FINISHING_HEATING_SYSTEM_TYPE = "finishing_heating_system_type";
    public static final String MINIMIZE_FINISHING_HOUSE_DRAFTS = "minimize_finishing_house_drafts";
    public static final String INSULATE_FINISHING_HOUSE = "insulate_finishing_house";
    
    
    private AHATcrdb _db;

    public AHATSwine(AHATcrdb db) throws SQLException, ServiceException {
        _db = db;

        addDataColumn(SWINE_HEATING_FUEL_TYPE, new ColumnInteger(SWINE_HEATING_FUEL_TYPE, "Type of fuel used to heat swine housing facility"));
        addDataColumn(UNIT_ELECTRIC_COST, new ColumnDouble(UNIT_ELECTRIC_COST, "Dollars per kilowatt-hour $/kwh (minimum $0.001 and maximum $0.50.)"));
        addDataColumn(FARROWING_CRATES, new ColumnInteger(FARROWING_CRATES, "Number of crates in farrowing operation"));
        addDataColumn(MONTHS_USE_FARROWING_HEATER, new ColumnInteger(MONTHS_USE_FARROWING_HEATER, "Number of months heater used in farrowing operation"));
        addDataColumn(FARROWING_ANNUAL_FUEL_USE, new ColumnDouble(FARROWING_ANNUAL_FUEL_USE, "Amount of fuel used annually in farrowing operation"));
        addDataColumn(FEEDER_PIGS, new ColumnInteger(FEEDER_PIGS, "Number of feeder pigs in nursery operation"));
        addDataColumn(MONTHS_USE_NURSERY_HEATER, new ColumnInteger(MONTHS_USE_NURSERY_HEATER, "Number of months heater used in nursery operation"));
        addDataColumn(NURSERY_FUEL_USE, new ColumnDouble(NURSERY_FUEL_USE, "Amount of fuel used annually in nursery operation"));
        addDataColumn(FINISHING_PIGS, new ColumnInteger(FINISHING_PIGS, "Number of pigs in finishing operation"));
        addDataColumn(MONTHS_USE_FINISHING_HEATER, new ColumnInteger(MONTHS_USE_FINISHING_HEATER, "Number of months heater used in finishing operation"));
        addDataColumn(FINISHING_FUEL_USE, new ColumnDouble(FINISHING_FUEL_USE, "Amount of fuel used annually in finishing operation"));
        addDataColumn(FARROWING_LIGHTING_TYPE, new ColumnInteger(FARROWING_LIGHTING_TYPE, "Type of lighting used in the farrowing house"));
        addDataColumn(FARROWING_VENTILATION_SYSTEM, new ColumnBoolean(FARROWING_VENTILATION_SYSTEM, "Does the farrowing house have an energy efficient ventilation system?"));
        addDataColumn(FARROWING_FAN_BLADES_SHUTTERS, new ColumnBoolean(FARROWING_FAN_BLADES_SHUTTERS, "Are farrowing house ventilation fan blades cleaned and maintained after every turn?"));
        addDataColumn(FARROWING_FAN_MOTORS_BELTS, new ColumnBoolean(FARROWING_FAN_MOTORS_BELTS, "Are farrowing house ventilation fan motors and belts checked and maintained after every turn?"));
        addDataColumn(FARROWING_HEATING_SYSTEM_TYPE, new ColumnInteger(FARROWING_HEATING_SYSTEM_TYPE, "Type of farrowing house heating system"));
        addDataColumn(MINIMIZE_FARROWING_HOUSE_DRAFTS, new ColumnBoolean(MINIMIZE_FARROWING_HOUSE_DRAFTS, "Have drafts in the nursery been minimized?"));
        addDataColumn(INSULATE_FARROWING_HOUSE, new ColumnBoolean(INSULATE_FARROWING_HOUSE, "Has the finishing house been insulated?"));
        addDataColumn(NURSERY_LIGHTING_TYPE, new ColumnInteger(NURSERY_LIGHTING_TYPE, "Type of lighting used in the nursery house"));
        addDataColumn(NURSERY_VENTILATION_SYSTEM, new ColumnBoolean(NURSERY_VENTILATION_SYSTEM, "Does the nursery house have an energy efficient ventilation system?"));
        addDataColumn(NURSERY_FAN_BLADES_SHUTTERS, new ColumnBoolean(NURSERY_FAN_BLADES_SHUTTERS, "Are nursery house ventilation fan blades cleaned and maintained after every turn?"));
        addDataColumn(NURSERY_FAN_MOTORS_BELTS, new ColumnBoolean(NURSERY_FAN_MOTORS_BELTS, "Are nursery house ventilation fan motors and belts checked and maintained after every turn?"));
        addDataColumn(NURSERY_HEATING_SYSTEM_TYPE, new ColumnInteger(NURSERY_HEATING_SYSTEM_TYPE, "Type of nursery house heating system"));
        addDataColumn(MINIMIZE_NURSERY_HOUSE_DRAFTS, new ColumnBoolean(MINIMIZE_NURSERY_HOUSE_DRAFTS, "Have drafts in the nursery house been minimized?"));
        addDataColumn(INSULATE_NURSERY_HOUSE, new ColumnBoolean(INSULATE_NURSERY_HOUSE, "Has the nursery house been insulated?"));
        addDataColumn(FINISHING_LIGHTING_TYPE, new ColumnInteger(FINISHING_LIGHTING_TYPE, "Type of lighting used in the farrowing house"));
        addDataColumn(FINISHING_VENTILATION_SYSTEM, new ColumnBoolean(FINISHING_VENTILATION_SYSTEM, "Does the finishing house have an energy efficient ventilation system?"));
        addDataColumn(FINISHING_FAN_BLADES_SHUTTERS, new ColumnBoolean(FINISHING_FAN_BLADES_SHUTTERS, "Are finishing house ventilation fan blades cleaned and maintained after every turn?"));
        addDataColumn(FINISHING_FAN_MOTORS_BELTS, new ColumnBoolean(FINISHING_FAN_MOTORS_BELTS, "Are finishing house ventilation fan motors and belts checked and maintained after every turn?"));
        addDataColumn(FINISHING_HEATING_SYSTEM_TYPE, new ColumnInteger(FINISHING_HEATING_SYSTEM_TYPE, "Type of finishing house heating system"));
        addDataColumn(MINIMIZE_FINISHING_HOUSE_DRAFTS, new ColumnBoolean(MINIMIZE_FINISHING_HOUSE_DRAFTS, "Have drafts in the finishing house been minimized?"));
        addDataColumn(INSULATE_FINISHING_HOUSE, new ColumnBoolean(INSULATE_FINISHING_HOUSE, "Has the finishing house been insulated?"));
    }
}