ARM_ANSWERS

This table stores the answers for the questions.

Details

Object type: TABLE

Primary Key

Name	Columns
ARM_ANSWERS_PK	ANSWER_ID

Columns

Name	Data Type	Length	Precision	Scale	Null Allowed	Comments
ANSWER_ID	NUMBER		18	0	No	Unique ID
QUESTION_ID	NUMBER		18	0	No	Question that is answered
OBJECT_ID	NUMBER		18	0	No	Object this question/answer applies
VALUE_TEXT	VARCHAR2	4000			Yes	Text value (used for TEXT, MULTILINE_TEXT and BOOLEAN types)
VALUE_DATE	DATE				Yes	Date value (used for DATE and DATETIME types)
VALUE_NUMBER	NUMBER				Yes	Number type (used for NUMBER type)
VALUE_CHOICE_LIST_ID	NUMBER		18	0	Yes	Used for the case where the user chooses list value
OBJECT_VERSION_NUMBER	NUMBER		9	0	No	Used to implement optimistic locking. This number is incremented every time the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried.
LAST_UPDATE_LOGIN	NUMBER				Yes	Who column. Stores the login/session ID of the user who last updated this row.
LAST_UPDATE_DATE	DATE				No	Who column. Stores the date when this row was last updated.
LAST_UPDATED_BY	VARCHAR2	255			No	Who column. Stores the ID of the user who last updated this row.
CREATION_DATE	DATE				No	Who column. Stores the date when this row was created in the database.
CREATED_BY	VARCHAR2	255			No	Who column. Stores the ID of the user who created this row.

Indexes

Index	Uniqueness	Columns
ARM_ANSWERS_N1	NONUNIQUE	OBJECT_ID
ARM_ANSWERS_PK	UNIQUE	ANSWER_ID
ARM_ANSWERS_U1	NONUNIQUE	OBJECT_ID, QUESTION_ID