| Name | Type | Nullable | Default value | Comment |
|---|---|---|---|---|
| POLL_ID | NUMBER(38) | N | ||
| NAME | VARCHAR2(100.0) | N | ||
| DESCRIPTION | VARCHAR2(4000.0) | Y | ||
| START_DATE | DATE | Y | ||
| END_DATE | DATE | Y | ||
| REQUIRE_REGISTRATION_P | CHAR(1.0) | N | 'f' |
| Constraint Name | Columns |
|---|---|
| SYS_C002088184 | POLL_ID |
| Constraint Name | Check Condition |
|---|---|
| SYS_C002088180 | "POLL_ID" IS NOT NULL |
| SYS_C002088181 | "NAME" IS NOT NULL |
| SYS_C002088182 | "REQUIRE_REGISTRATION_P" IS NOT NULL |
| SYS_C002088183 | require_registration_p in ('t','f') |
| Option | Settings |
|---|---|
| Index Organized | No |
| Generated by Oracle | No |
| Clustered | No |
| Nested | No |
| Temporary | No |
| Index Name | Type | Unuqueness | Columns |
|---|---|---|---|
| SYS_C002088184 | NORMAL | UNIQUE | POLL_ID |
| Table | Constraint |
|---|---|
| POLL_CHOICES | SYS_C002088189 |
| POLL_USER_CHOICES | SYS_C002088194 |