| Name | Type | Nullable | Default value | Comment |
|---|---|---|---|---|
| QUESTION_ID | NUMBER(38) | N | ||
| SURVEY_ID | NUMBER(38) | N | ||
| SORT_KEY | NUMBER(38) | N | ||
| QUESTION_TEXT | CLOB | N | ||
| ABSTRACT_DATA_TYPE | VARCHAR2(30.0) | N | ||
| REQUIRED_P | CHAR(1.0) | Y | ||
| ACTIVE_P | CHAR(1.0) | Y | ||
| PRESENTATION_TYPE | VARCHAR2(20.0) | N | ||
| PRESENTATION_OPTIONS | VARCHAR2(50.0) | Y | ||
| PRESENTATION_ALIGNMENT | VARCHAR2(15.0) | Y | 'below' | |
| CREATION_USER | NUMBER(38) | N | ||
| CREATION_DATE | DATE | Y | sysdate |
| Constraint Name | Columns |
|---|---|
| SYS_C002088572 | QUESTION_ID |
| Constraint Name | Check Condition |
|---|---|
| SYS_C002088562 | "SURVEY_ID" IS NOT NULL |
| SYS_C002088563 | "SORT_KEY" IS NOT NULL |
| SYS_C002088564 | "QUESTION_TEXT" IS NOT NULL |
| SYS_C002088565 | "ABSTRACT_DATA_TYPE" IS NOT NULL |
| SYS_C002088566 | "PRESENTATION_TYPE" IS NOT NULL |
| SYS_C002088567 | "CREATION_USER" IS NOT NULL |
| SYS_C002088568 | required_p in ('t','f') |
| SYS_C002088569 | active_p in ('t','f') |
| SYS_C002088570 | presentation_type in ('textbox','textarea','select','radio', 'checkbox', 'date', 'upload_file') |
| SYS_C002088571 | presentation_alignment in ('below','beside') |
| Constraint Name | Columns | Referenced table | Referenced Constraint | On Delete Rule |
|---|---|---|---|---|
| SYS_C002088573 | SURVEY_ID | SURVSIMP_SURVEYS | SYS_C002088559 | NO ACTION |
| SYS_C002088574 | CREATION_USER | USERS | SYS_C002087135 | NO ACTION |
| Option | Settings |
|---|---|
| Index Organized | No |
| Generated by Oracle | No |
| Clustered | No |
| Nested | No |
| Temporary | No |
| Index Name | Type | Unuqueness | Columns |
|---|---|---|---|
| SYS_C002088572 | NORMAL | UNIQUE | QUESTION_ID |
| SYS_IL0001977203C00004$$ | LOB | UNIQUE |
| Table | Constraint |
|---|---|
| SURVSIMP_QUESTION_CHOICES | SYS_C002088579 |
| SURVSIMP_QUESTION_RESPONSES | SYS_C002088593 |