Name | Type | Nullable | Default value | Comment |
---|---|---|---|---|
PAGE_ID | NUMBER(38) | N | ||
URL_STUB | VARCHAR2(400.0) | N | ||
ORIGINAL_AUTHOR | NUMBER(38) | Y | ||
PAGE_TITLE | VARCHAR2(4000.0) | Y | ||
PAGE_BODY | CLOB | Y | ||
DRAFT_P | CHAR(1.0) | Y | 'f' | |
OBSOLETE_P | CHAR(1.0) | Y | 'f' | |
MEMBERS_ONLY_P | CHAR(1.0) | Y | 'f' | |
PRICE | NUMBER(38) | Y | ||
COPYRIGHT_INFO | VARCHAR2(4000.0) | Y | ||
ACCEPT_COMMENTS_P | CHAR(1.0) | Y | 't' | |
ACCEPT_LINKS_P | CHAR(1.0) | Y | 't' | |
INLINE_COMMENTS_P | CHAR(1.0) | Y | 't' | |
INLINE_LINKS_P | CHAR(1.0) | Y | 't' | |
INDEX_P | CHAR(1.0) | Y | 't' | |
INDEX_DECISION_MADE_BY | VARCHAR2(30.0) | Y | 'robot' | |
MENU_P | CHAR(1.0) | Y | 't' | |
UPLINK | VARCHAR2(200.0) | Y | ||
FILE_SIZE | NUMBER(38) | Y | ||
LAST_UPDATED | DATE | Y | ||
PUBLISH_DATE | DATE | Y |
Constraint Name | Columns |
---|---|
SYS_C002087200 | PAGE_ID |
Constraint Name | Check Condition |
---|---|
SYS_C002087188 | "PAGE_ID" IS NOT NULL |
SYS_C002087189 | "URL_STUB" IS NOT NULL |
SYS_C002087190 | draft_p in ('t','f') |
SYS_C002087191 | obsolete_p in ('t','f') |
SYS_C002087192 | members_only_p in ('t','f') |
SYS_C002087193 | accept_comments_p in ('t','f') |
SYS_C002087194 | accept_links_p in ('t','f') |
SYS_C002087195 | inline_comments_p in ('t','f') |
SYS_C002087196 | inline_links_p in ('t','f') |
SYS_C002087197 | index_p in ('t','f') |
SYS_C002087198 | index_decision_made_by in ('human', 'robot') |
SYS_C002087199 | menu_p in ('t','f') |
Constraint Name | Columns | Referenced table | Referenced Constraint | On Delete Rule |
---|---|---|---|---|
SYS_C002087202 | ORIGINAL_AUTHOR | USERS | SYS_C002087135 | NO ACTION |
Constraint name | Columns |
---|---|
SYS_C002087201 | URL_STUB |
Option | Settings |
---|---|
Index Organized | No |
Generated by Oracle | No |
Clustered | No |
Nested | No |
Temporary | No |
Index Name | Type | Unuqueness | Columns |
---|---|---|---|
SYS_C002087200 | NORMAL | UNIQUE | PAGE_ID |
SYS_C002087201 | NORMAL | UNIQUE | URL_STUB |
SYS_IL0001976317C00005$$ | LOB | UNIQUE |
Table | Constraint |
---|---|
STATIC_PAGE_AUTHORS | SYS_C002087207 |
COMMENTS | SYS_C002087224 |
LINKS | SYS_C002087233 |
LINK_KILL_PATTERNS | SYS_C002087239 |
USER_CONTENT_MAP | SYS_C002087246 |