fi.paatti.paattidatabaseutils.names
Class PaattiColumnNames

java.lang.Object
  extended by fi.paatti.paattidatabaseutils.names.PaattiColumnNames

public class PaattiColumnNames
extends Object

The column names used by the application's database.

Since:
0.0.2
Author:
Lauri Satokangas, lauri.n.satokangas@student.jyu.fi
 

Field Summary
static String ADMINISTERS_description
           
static String ADMINISTERS_editTime
           
static String ADMINISTERS_EVENT_eventID
           
static String ADMINISTERS_rowStatus
           
static String ADMINISTERS_USER_userID
           
static String BELONGS_editTime
           
static String BELONGS_rowStatus
           
static String BELONGS_USER_userID
           
static String BELONGS_USERGROUP_usergroupID
           
static String BINARYDATA_binarydataID
           
static String BINARYDATA_rowStatus
           
static String BINARYDATA_sequence
           
static String BINARYDATA_TASKDATA_taskDataID
           
static String CHOICE_choiceID
           
static String CHOICE_description
           
static String CHOICE_rowStatus
           
static String CHOICE_sequence
           
static String CHOICE_TASK_contains_taskID
           
static String CHOICE_TASK_leadsto_taskID
           
static String CHOICE_value
           
static String EVENT_description
           
static String EVENT_estimatedTime
           
static String EVENT_eventID
           
static String EVENT_EVENTTIME_eventTimeID
           
static String EVENT_EVENTTYPE_eventTypeID
           
static String EVENT_origEventID
           
static String EVENT_rowStatus
           
static String EVENT_SCHEDULE_scheduleID
           
static String EVENT_status
           
static String EVENT_title
           
static String EVENTSTATUS_eventStatusID
           
static String EVENTSTATUS_status
           
static String EVENTTIME_absolute
           
static String EVENTTIME_day
           
static String EVENTTIME_eventTimeID
           
static String EVENTTIME_fromHour
           
static String EVENTTIME_hoursLeft
           
static String EVENTTIME_minute
           
static String EVENTTIME_month
           
static String EVENTTIME_rowStatus
           
static String EVENTTIME_week
           
static String EVENTTIME_weekday
           
static String EVENTTIME_year
           
static String EVENTTYPE_description
           
static String EVENTTYPE_eventTypeID
           
static String EVENTTYPE_rowStatus
           
static String RESEARCH_description
           
static String RESEARCH_name
           
static String RESEARCH_researchID
           
static String RESEARCH_rowStatus
           
static String ROLE_description
           
static String ROLE_name
           
static String ROLE_roleID
           
static String ROLE_rowStatus
           
static String SCHEDULE_description
           
static String SCHEDULE_rowStatus
           
static String SCHEDULE_scheduleID
           
static String SCHEDULE_USERGROUP_usergroupID
           
static String SCHEDULE_zeroTime
           
static String TASK_content
           
static String TASK_description
           
static String TASK_EVENT_eventID
           
static String TASK_posX
           
static String TASK_posY
           
static String TASK_rowStatus
           
static String TASK_sequence
           
static String TASK_taskID
           
static String TASK_TASKTYPE_taskTypeID
           
static String TASK_url
           
static String TASKDATA_CHOICE_choiceID
           
static String TASKDATA_executionTime
           
static String TASKDATA_rowStatus
           
static String TASKDATA_sequence
           
static String TASKDATA_taskDataID
           
static String TASKDATA_USER_userID
           
static String TASKTYPE_binarydataMax
           
static String TASKTYPE_binarydataMin
           
static String TASKTYPE_description
           
static String TASKTYPE_rowStatus
           
static String TASKTYPE_taskTypeID
           
static String TASKTYPE_textMax
           
static String TASKTYPE_textMin
           
static String TEXT_rowStatus
           
static String TEXT_sequence
           
static String TEXT_TASKDATA_taskDataID
           
static String TEXT_textID
           
static String TEXTDATA_data
           
static String TEXTDATA_rowStatus
           
static String TEXTDATA_sequence
           
static String TEXTDATA_TASKDATA_taskDataID
           
static String TEXTDATA_textDataID
           
static String USER_description
           
static String USER_firstName
           
static String USER_lastName
           
static String USER_name
           
static String USER_password
           
static String USER_rowStatus
           
static String USER_userID
           
static String USERGROUP_description
           
static String USERGROUP_editedBy
           
static String USERGROUP_editTime
           
static String USERGROUP_name
           
static String USERGROUP_RESEARCH_researchID
           
static String USERGROUP_ROLE_roleID
           
static String USERGROUP_rowStatus
           
static String USERGROUP_usergroupID
           
 
Method Summary
static ArrayList<String> getColumnNames(String tableName)
          Returns the table column names as a list of strings.
static String[] getColumnNamesInArray(String tableName)
          Returns the table column names as a string array.
 
Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
 

Field Detail

ADMINISTERS_editTime

public static final String ADMINISTERS_editTime
See Also:
Constant Field Values

ADMINISTERS_description

public static final String ADMINISTERS_description
See Also:
Constant Field Values

ADMINISTERS_USER_userID

public static final String ADMINISTERS_USER_userID
See Also:
Constant Field Values

ADMINISTERS_EVENT_eventID

public static final String ADMINISTERS_EVENT_eventID
See Also:
Constant Field Values

ADMINISTERS_rowStatus

public static final String ADMINISTERS_rowStatus
See Also:
Constant Field Values

BELONGS_rowStatus

public static final String BELONGS_rowStatus
See Also:
Constant Field Values

BELONGS_USER_userID

public static final String BELONGS_USER_userID
See Also:
Constant Field Values

BELONGS_USERGROUP_usergroupID

public static final String BELONGS_USERGROUP_usergroupID
See Also:
Constant Field Values

BELONGS_editTime

public static final String BELONGS_editTime
See Also:
Constant Field Values

BINARYDATA_rowStatus

public static final String BINARYDATA_rowStatus
See Also:
Constant Field Values

BINARYDATA_TASKDATA_taskDataID

public static final String BINARYDATA_TASKDATA_taskDataID
See Also:
Constant Field Values

BINARYDATA_sequence

public static final String BINARYDATA_sequence
See Also:
Constant Field Values

BINARYDATA_binarydataID

public static final String BINARYDATA_binarydataID
See Also:
Constant Field Values

CHOICE_rowStatus

public static final String CHOICE_rowStatus
See Also:
Constant Field Values

CHOICE_TASK_leadsto_taskID

public static final String CHOICE_TASK_leadsto_taskID
See Also:
Constant Field Values

CHOICE_TASK_contains_taskID

public static final String CHOICE_TASK_contains_taskID
See Also:
Constant Field Values

CHOICE_value

public static final String CHOICE_value
See Also:
Constant Field Values

CHOICE_sequence

public static final String CHOICE_sequence
See Also:
Constant Field Values

CHOICE_description

public static final String CHOICE_description
See Also:
Constant Field Values

CHOICE_choiceID

public static final String CHOICE_choiceID
See Also:
Constant Field Values

EVENT_rowStatus

public static final String EVENT_rowStatus
See Also:
Constant Field Values

EVENT_EVENTTIME_eventTimeID

public static final String EVENT_EVENTTIME_eventTimeID
See Also:
Constant Field Values

EVENT_EVENTTYPE_eventTypeID

public static final String EVENT_EVENTTYPE_eventTypeID
See Also:
Constant Field Values

EVENT_SCHEDULE_scheduleID

public static final String EVENT_SCHEDULE_scheduleID
See Also:
Constant Field Values

EVENT_origEventID

public static final String EVENT_origEventID
See Also:
Constant Field Values

EVENT_status

public static final String EVENT_status
See Also:
Constant Field Values

EVENT_estimatedTime

public static final String EVENT_estimatedTime
See Also:
Constant Field Values

EVENT_description

public static final String EVENT_description
See Also:
Constant Field Values

EVENT_title

public static final String EVENT_title
See Also:
Constant Field Values

EVENT_eventID

public static final String EVENT_eventID
See Also:
Constant Field Values

EVENTSTATUS_status

public static final String EVENTSTATUS_status
See Also:
Constant Field Values

EVENTSTATUS_eventStatusID

public static final String EVENTSTATUS_eventStatusID
See Also:
Constant Field Values

EVENTTIME_rowStatus

public static final String EVENTTIME_rowStatus
See Also:
Constant Field Values

EVENTTIME_hoursLeft

public static final String EVENTTIME_hoursLeft
See Also:
Constant Field Values

EVENTTIME_fromHour

public static final String EVENTTIME_fromHour
See Also:
Constant Field Values

EVENTTIME_week

public static final String EVENTTIME_week
See Also:
Constant Field Values

EVENTTIME_minute

public static final String EVENTTIME_minute
See Also:
Constant Field Values

EVENTTIME_weekday

public static final String EVENTTIME_weekday
See Also:
Constant Field Values

EVENTTIME_day

public static final String EVENTTIME_day
See Also:
Constant Field Values

EVENTTIME_month

public static final String EVENTTIME_month
See Also:
Constant Field Values

EVENTTIME_year

public static final String EVENTTIME_year
See Also:
Constant Field Values

EVENTTIME_absolute

public static final String EVENTTIME_absolute
See Also:
Constant Field Values

EVENTTIME_eventTimeID

public static final String EVENTTIME_eventTimeID
See Also:
Constant Field Values

EVENTTYPE_rowStatus

public static final String EVENTTYPE_rowStatus
See Also:
Constant Field Values

EVENTTYPE_description

public static final String EVENTTYPE_description
See Also:
Constant Field Values

EVENTTYPE_eventTypeID

public static final String EVENTTYPE_eventTypeID
See Also:
Constant Field Values

RESEARCH_researchID

public static final String RESEARCH_researchID
See Also:
Constant Field Values

RESEARCH_description

public static final String RESEARCH_description
See Also:
Constant Field Values

RESEARCH_name

public static final String RESEARCH_name
See Also:
Constant Field Values

RESEARCH_rowStatus

public static final String RESEARCH_rowStatus
See Also:
Constant Field Values

ROLE_rowStatus

public static final String ROLE_rowStatus
See Also:
Constant Field Values

ROLE_description

public static final String ROLE_description
See Also:
Constant Field Values

ROLE_name

public static final String ROLE_name
See Also:
Constant Field Values

ROLE_roleID

public static final String ROLE_roleID
See Also:
Constant Field Values

SCHEDULE_USERGROUP_usergroupID

public static final String SCHEDULE_USERGROUP_usergroupID
See Also:
Constant Field Values

SCHEDULE_description

public static final String SCHEDULE_description
See Also:
Constant Field Values

SCHEDULE_rowStatus

public static final String SCHEDULE_rowStatus
See Also:
Constant Field Values

SCHEDULE_zeroTime

public static final String SCHEDULE_zeroTime
See Also:
Constant Field Values

SCHEDULE_scheduleID

public static final String SCHEDULE_scheduleID
See Also:
Constant Field Values

TASK_rowStatus

public static final String TASK_rowStatus
See Also:
Constant Field Values

TASK_TASKTYPE_taskTypeID

public static final String TASK_TASKTYPE_taskTypeID
See Also:
Constant Field Values

TASK_EVENT_eventID

public static final String TASK_EVENT_eventID
See Also:
Constant Field Values

TASK_sequence

public static final String TASK_sequence
See Also:
Constant Field Values

TASK_url

public static final String TASK_url
See Also:
Constant Field Values

TASK_content

public static final String TASK_content
See Also:
Constant Field Values

TASK_description

public static final String TASK_description
See Also:
Constant Field Values

TASK_taskID

public static final String TASK_taskID
See Also:
Constant Field Values

TASK_posX

public static final String TASK_posX
See Also:
Constant Field Values

TASK_posY

public static final String TASK_posY
See Also:
Constant Field Values

TASKDATA_rowStatus

public static final String TASKDATA_rowStatus
See Also:
Constant Field Values

TASKDATA_CHOICE_choiceID

public static final String TASKDATA_CHOICE_choiceID
See Also:
Constant Field Values

TASKDATA_USER_userID

public static final String TASKDATA_USER_userID
See Also:
Constant Field Values

TASKDATA_sequence

public static final String TASKDATA_sequence
See Also:
Constant Field Values

TASKDATA_executionTime

public static final String TASKDATA_executionTime
See Also:
Constant Field Values

TASKDATA_taskDataID

public static final String TASKDATA_taskDataID
See Also:
Constant Field Values

TASKTYPE_rowStatus

public static final String TASKTYPE_rowStatus
See Also:
Constant Field Values

TASKTYPE_binarydataMax

public static final String TASKTYPE_binarydataMax
See Also:
Constant Field Values

TASKTYPE_textMax

public static final String TASKTYPE_textMax
See Also:
Constant Field Values

TASKTYPE_textMin

public static final String TASKTYPE_textMin
See Also:
Constant Field Values

TASKTYPE_binarydataMin

public static final String TASKTYPE_binarydataMin
See Also:
Constant Field Values

TASKTYPE_description

public static final String TASKTYPE_description
See Also:
Constant Field Values

TASKTYPE_taskTypeID

public static final String TASKTYPE_taskTypeID
See Also:
Constant Field Values

TEXT_textID

public static final String TEXT_textID
See Also:
Constant Field Values

TEXT_sequence

public static final String TEXT_sequence
See Also:
Constant Field Values

TEXT_TASKDATA_taskDataID

public static final String TEXT_TASKDATA_taskDataID
See Also:
Constant Field Values

TEXT_rowStatus

public static final String TEXT_rowStatus
See Also:
Constant Field Values

TEXTDATA_rowStatus

public static final String TEXTDATA_rowStatus
See Also:
Constant Field Values

TEXTDATA_data

public static final String TEXTDATA_data
See Also:
Constant Field Values

TEXTDATA_TASKDATA_taskDataID

public static final String TEXTDATA_TASKDATA_taskDataID
See Also:
Constant Field Values

TEXTDATA_sequence

public static final String TEXTDATA_sequence
See Also:
Constant Field Values

TEXTDATA_textDataID

public static final String TEXTDATA_textDataID
See Also:
Constant Field Values

USER_rowStatus

public static final String USER_rowStatus
See Also:
Constant Field Values

USER_description

public static final String USER_description
See Also:
Constant Field Values

USER_password

public static final String USER_password
See Also:
Constant Field Values

USER_name

public static final String USER_name
See Also:
Constant Field Values

USER_firstName

public static final String USER_firstName
See Also:
Constant Field Values

USER_lastName

public static final String USER_lastName
See Also:
Constant Field Values

USER_userID

public static final String USER_userID
See Also:
Constant Field Values

USERGROUP_ROLE_roleID

public static final String USERGROUP_ROLE_roleID
See Also:
Constant Field Values

USERGROUP_RESEARCH_researchID

public static final String USERGROUP_RESEARCH_researchID
See Also:
Constant Field Values

USERGROUP_editTime

public static final String USERGROUP_editTime
See Also:
Constant Field Values

USERGROUP_editedBy

public static final String USERGROUP_editedBy
See Also:
Constant Field Values

USERGROUP_description

public static final String USERGROUP_description
See Also:
Constant Field Values

USERGROUP_name

public static final String USERGROUP_name
See Also:
Constant Field Values

USERGROUP_usergroupID

public static final String USERGROUP_usergroupID
See Also:
Constant Field Values

USERGROUP_rowStatus

public static final String USERGROUP_rowStatus
See Also:
Constant Field Values
Method Detail

getColumnNames

public static ArrayList<String> getColumnNames(String tableName)
Returns the table column names as a list of strings.

Parameters:
tableName - The name of the table.

getColumnNamesInArray

public static String[] getColumnNamesInArray(String tableName)
Returns the table column names as a string array.

Parameters:
tableName - the name of the table.
Returns:
The column names in an array.


Copyright © 2012. All Rights Reserved.