Main Tables Views Indexes Constraints Triggers Procedures Functions Packages Sanity check Index

ACS3 Data Model
Description Columns Primary key Check Constraints Foreign keys Unique Keys Options Indexes Referenced by Triggers

PAGE_LOGOS

Columns

NameTypeNullableDefault valueComment
LOGO_IDNUMBER(38)N  
SCOPEVARCHAR2(20.0)N  
USER_IDNUMBER(38)Y  
GROUP_IDNUMBER(38)Y  
LOGO_ENABLED_PCHAR(1.0)Y'f'  
LOGO_FILE_TYPEVARCHAR2(100.0)N  
LOGO_FILE_EXTENSIONVARCHAR2(50.0)N  
LOGOBLOBN  

Primary key:

Constraint NameColumns
SYS_C002087640LOGO_ID

Check Constraints:

Constraint NameCheck Condition
PAGE_LOGOS_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')
SYS_C002087635"SCOPE" IS NOT NULL
SYS_C002087636"LOGO_FILE_TYPE" IS NOT NULL
SYS_C002087637"LOGO_FILE_EXTENSION" IS NOT NULL
SYS_C002087638"LOGO" IS NOT NULL
SYS_C002087639logo_enabled_p in ('t', 'f')

Foreign Keys:

Constraint NameColumnsReferenced tableReferenced ConstraintOn Delete Rule
SYS_C002087641USER_ID USERS SYS_C002087135 NO ACTION
SYS_C002087642GROUP_ID USER_GROUPS SYS_C002087305 NO ACTION

Unique Keys:

Constraint nameColumns
PAGE_LOGOS_SCOPE_UNIQUESCOPE , USER_ID , GROUP_ID

Options:

OptionSettings
Index OrganizedNo
Generated by OracleNo
ClusteredNo
NestedNo
TemporaryNo

Indexes:

Index NameTypeUnuquenessColumns
PAGE_LOGOS_SCOPE_UNIQUENORMALUNIQUESCOPE , USER_ID , GROUP_ID
SYS_C002087640NORMALUNIQUELOGO_ID
SYS_IL0001976589C00008$$LOBUNIQUE 

Generated by OraSchemaDoc, (c) Aram Kananov, 2002