| Name | Type | Nullable | Default value | Comment |
|---|---|---|---|---|
| SURVEY_ID | NUMBER(38) | N | ||
| NAME | VARCHAR2(100.0) | N | ||
| SHORT_NAME | VARCHAR2(20.0) | N | ||
| DESCRIPTION | VARCHAR2(4000.0) | N | ||
| DESCRIPTION_HTML_P | CHAR(1.0) | Y | 'f' | |
| CREATION_USER | NUMBER(38) | N | ||
| CREATION_DATE | DATE | Y | sysdate | |
| ENABLED_P | CHAR(1.0) | Y | 'f' | |
| SINGLE_RESPONSE_P | CHAR(1.0) | Y | 'f' | |
| SINGLE_EDITABLE_P | CHAR(1.0) | Y | 't' |
| Constraint Name | Columns |
|---|---|
| SYS_C002088559 | SURVEY_ID |
| Constraint Name | Check Condition |
|---|---|
| SURVSIMP_SUR_DESC_HTML_P_CK | description_html_p in ('t','f') |
| SYS_C002088551 | "NAME" IS NOT NULL |
| SYS_C002088552 | "SHORT_NAME" IS NOT NULL |
| SYS_C002088553 | "DESCRIPTION" IS NOT NULL |
| SYS_C002088554 | "CREATION_USER" IS NOT NULL |
| SYS_C002088556 | enabled_p in ('t','f') |
| SYS_C002088557 | single_response_p in ('t','f') |
| SYS_C002088558 | single_editable_p in ('t','f') |
| Constraint Name | Columns | Referenced table | Referenced Constraint | On Delete Rule |
|---|---|---|---|---|
| SYS_C002088561 | CREATION_USER | USERS | SYS_C002087135 | NO ACTION |
| Constraint name | Columns |
|---|---|
| SYS_C002088560 | SHORT_NAME |
| Option | Settings |
|---|---|
| Index Organized | No |
| Generated by Oracle | No |
| Clustered | No |
| Nested | No |
| Temporary | No |
| Index Name | Type | Unuqueness | Columns |
|---|---|---|---|
| SYS_C002088559 | NORMAL | UNIQUE | SURVEY_ID |
| SYS_C002088560 | NORMAL | UNIQUE | SHORT_NAME |
| Table | Constraint |
|---|---|
| SURVSIMP_QUESTIONS | SYS_C002088573 |
| SURVSIMP_RESPONSES | SYS_C002088586 |