SURVSIMP_QUESTION_RESPONSES_UN
Columns
| Name | Type | Nullable | Insertable | Updatable | Deletable | Comment |
|---|
| RESPONSE_ID | NUMBER(38) | N | YES | YES | YES | |
| QUESTION_ID | NUMBER(38) | N | YES | YES | YES | |
| CHOICE_ID | NUMBER(38) | Y | YES | YES | YES | |
| BOOLEAN_ANSWER | CHAR(1.0) | Y | YES | YES | YES | |
| CLOB_ANSWER | CLOB | Y | YES | YES | YES | |
| NUMBER_ANSWER | NUMBER(38) | Y | YES | YES | YES | |
| VARCHAR_ANSWER | VARCHAR2(4000.0) | Y | YES | YES | YES | |
| DATE_ANSWER | DATE | Y | YES | YES | YES | |
| ATTACHMENT_ANSWER | BLOB | Y | YES | YES | YES | |
| ATTACHMENT_FILE_NAME | VARCHAR2(500.0) | Y | YES | YES | YES | |
| ATTACHMENT_FILE_TYPE | VARCHAR2(100.0) | Y | YES | YES | YES | |
| ATTACHMENT_FILE_EXTENSION | VARCHAR2(50.0) | Y | YES | YES | YES | |
Query:
select qr.*
from survsimp_question_responses qr, survsimp_responses_unique r
where qr.response_id=r.response_id
Generated by OraSchemaDoc,
(c) Aram Kananov, 2002