| Name | Type | Nullable | Default value | Comment |
|---|---|---|---|---|
| SECTION_ID | NUMBER(38) | N | ||
| SCOPE | VARCHAR2(20.0) | N | ||
| SECTION_TYPE | VARCHAR2(20.0) | N | ||
| REQUIRES_REGISTRATION_P | CHAR(1.0) | Y | 'f' | |
| VISIBILITY | VARCHAR2(20.0) | N | ||
| USER_ID | NUMBER(38) | Y | ||
| GROUP_ID | NUMBER(38) | Y | ||
| SECTION_KEY | VARCHAR2(30.0) | N | ||
| MODULE_KEY | VARCHAR2(30.0) | Y | ||
| SECTION_URL_STUB | VARCHAR2(200.0) | Y | ||
| SECTION_PRETTY_NAME | VARCHAR2(200.0) | N | ||
| SORT_KEY | NUMBER(38) | Y | ||
| ENABLED_P | CHAR(1.0) | Y | 't' | |
| INTRO_BLURB | VARCHAR2(4000.0) | Y | ||
| HELP_BLURB | VARCHAR2(4000.0) | Y | ||
| INDEX_PAGE_ENABLED_P | CHAR(1.0) | Y | 'f' | |
| BODY | CLOB | Y | ||
| HTML_P | CHAR(1.0) | Y | 'f' |
| Constraint Name | Columns |
|---|---|
| SYS_C002087416 | SECTION_ID |
| Constraint Name | Check Condition |
|---|---|
| CONTENT_SECTIONS_SCOPE_CHECK | (scope='group' and group_id is not null and user_id is null) or (scope='user' and user_id is not null and group_id is null) or (scope='public' and user_id is null and group_id is null) |
| CONTENT_SECTIONS_TYPE_CHECK | (section_type='static' and section_url_stub is not null) or ((section_type='system' or section_type='admin') and module_key is not null) or (section_type='custom') |
| SYS_C002087406 | "SCOPE" IS NOT NULL |
| SYS_C002087407 | "SECTION_TYPE" IS NOT NULL |
| SYS_C002087408 | "VISIBILITY" IS NOT NULL |
| SYS_C002087409 | "SECTION_KEY" IS NOT NULL |
| SYS_C002087410 | "SECTION_PRETTY_NAME" IS NOT NULL |
| SYS_C002087411 | requires_registration_p in ('t','f') |
| SYS_C002087412 | visibility in ('private', 'public') |
| SYS_C002087413 | enabled_p in ('t','f') |
| SYS_C002087414 | index_page_enabled_p in ('t','f') |
| SYS_C002087415 | html_p in ('t','f') |
| Constraint Name | Columns | Referenced table | Referenced Constraint | On Delete Rule |
|---|---|---|---|---|
| SYS_C002087417 | USER_ID | USERS | SYS_C002087135 | NO ACTION |
| SYS_C002087418 | GROUP_ID | USER_GROUPS | SYS_C002087305 | NO ACTION |
| SYS_C002087419 | MODULE_KEY | ACS_MODULES | SYS_C002087057 | NO ACTION |
| Constraint name | Columns |
|---|---|
| CONTENT_SECTIONS_UNIQUE_CHECK | SCOPE , SECTION_KEY , USER_ID , GROUP_ID |
| Option | Settings |
|---|---|
| Index Organized | No |
| Generated by Oracle | No |
| Clustered | No |
| Nested | No |
| Temporary | No |
| Index Name | Type | Unuqueness | Columns |
|---|---|---|---|
| CONTENT_SECTIONS_UNIQUE_CHECK | NORMAL | UNIQUE | SCOPE , SECTION_KEY , USER_ID , GROUP_ID |
| SYS_C002087416 | NORMAL | UNIQUE | SECTION_ID |
| SYS_IL0001976441C00017$$ | LOB | UNIQUE |
| Table | Constraint |
|---|---|
| CONTENT_FILES | SYS_C002087427 |
| CONTENT_SECTION_LINKS | SYS_C002087431 |
| CONTENT_SECTION_LINKS | SYS_C002087432 |