| Name | Type | Nullable | Default value | Comment |
|---|---|---|---|---|
| RESPONSE_ID | NUMBER(38) | N | ||
| QUESTION_ID | NUMBER(38) | N | ||
| CHOICE_ID | NUMBER(38) | Y | ||
| BOOLEAN_ANSWER | CHAR(1.0) | Y | ||
| CLOB_ANSWER | CLOB | Y | ||
| NUMBER_ANSWER | NUMBER(38) | Y | ||
| VARCHAR_ANSWER | VARCHAR2(4000.0) | Y | ||
| DATE_ANSWER | DATE | Y | ||
| ATTACHMENT_ANSWER | BLOB | Y | ||
| ATTACHMENT_FILE_NAME | VARCHAR2(500.0) | Y | ||
| ATTACHMENT_FILE_TYPE | VARCHAR2(100.0) | Y | ||
| ATTACHMENT_FILE_EXTENSION | VARCHAR2(50.0) | Y |
| Constraint Name | Check Condition |
|---|---|
| SYS_C002088589 | "RESPONSE_ID" IS NOT NULL |
| SYS_C002088590 | "QUESTION_ID" IS NOT NULL |
| SYS_C002088591 | boolean_answer in ('t','f') |
| Constraint Name | Columns | Referenced table | Referenced Constraint | On Delete Rule |
|---|---|---|---|---|
| SYS_C002088592 | RESPONSE_ID | SURVSIMP_RESPONSES | SYS_C002088585 | NO ACTION |
| SYS_C002088593 | QUESTION_ID | SURVSIMP_QUESTIONS | SYS_C002088572 | NO ACTION |
| SYS_C002088594 | CHOICE_ID | SURVSIMP_QUESTION_CHOICES | SYS_C002088578 | NO ACTION |
| Option | Settings |
|---|---|
| Index Organized | No |
| Generated by Oracle | No |
| Clustered | No |
| Nested | No |
| Temporary | No |
| Index Name | Type | Unuqueness | Columns |
|---|---|---|---|
| SURVSIMP_RESPONSE_INDEX | NORMAL | NONUNIQUE | RESPONSE_ID , QUESTION_ID |
| SYS_IL0001977214C00005$$ | LOB | UNIQUE | |
| SYS_IL0001977214C00009$$ | LOB | UNIQUE |