| Name | Type | Nullable | Default value | Comment |
|---|---|---|---|---|
| DOMAIN_ID | NUMBER(38) | N | ||
| DOMAIN | VARCHAR2(21.0) | N | ||
| ENTRANTS_TABLE_NAME | VARCHAR2(30.0) | Y | ||
| PRETTY_NAME | VARCHAR2(100.0) | N | ||
| HOME_URL | VARCHAR2(200.0) | Y | ||
| PREAMBLE | VARCHAR2(4000.0) | Y | ||
| POST_ENTRY_URL | VARCHAR2(200.0) | Y | ||
| CONFIRM_ENTRY | VARCHAR2(4000.0) | Y | ||
| MAINTAINER | NUMBER(38) | N | ||
| NOTIFY_OF_ADDITIONS_P | CHAR(1.0) | Y | 'f' | |
| US_ONLY_P | CHAR(1.0) | Y | 'f' | |
| START_DATE | DATE | Y | ||
| END_DATE | DATE | Y | ||
| VOTING_P | CHAR(1.0) | Y | ||
| MULTIPLE_ENTRIES_P | CHAR(1.0) | Y |
| Constraint Name | Columns |
|---|---|
| SYS_C002087608 | DOMAIN_ID |
| Constraint Name | Check Condition |
|---|---|
| CD_DOMAIN_ID_PK | "DOMAIN_ID" IS NOT NULL |
| CD_MAINTAINER_FK | "MAINTAINER" IS NOT NULL |
| CD_M_ENTRIES_P_CK | multiple_entries_p in ('t','f') |
| CD_NOTIFY_OF_ADDTIONS_P_CK | notify_of_additions_p in ('t', 'f') |
| CD_US_ONLY_P_CK | us_only_p in ('t', 'f') |
| CD_VOTING_P_CK | voting_p in ('t','f') |
| C_DOMAIN_UN | "DOMAIN" IS NOT NULL |
| SYS_C002087602 | "PRETTY_NAME" IS NOT NULL |
| Constraint Name | Columns | Referenced table | Referenced Constraint | On Delete Rule |
|---|---|---|---|---|
| SYS_C002087610 | MAINTAINER | USERS | SYS_C002087135 | NO ACTION |
| Constraint name | Columns |
|---|---|
| SYS_C002087609 | DOMAIN |
| Option | Settings |
|---|---|
| Index Organized | No |
| Generated by Oracle | No |
| Clustered | No |
| Nested | No |
| Temporary | No |
| Index Name | Type | Unuqueness | Columns |
|---|---|---|---|
| SYS_C002087608 | NORMAL | UNIQUE | DOMAIN_ID |
| SYS_C002087609 | NORMAL | UNIQUE | DOMAIN |
| Table | Constraint |
|---|---|
| CONTEST_EXTRA_COLUMNS | CEC_DOMAIN_ID_FK |
| CONTEST_VOTES | CONTEST_VOTES_DOMAIN_ID_FK |