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

WP_ATTACHMENTS

Columns

NameTypeNullableDefault valueComment
ATTACH_IDNUMBER(38)N  
SLIDE_IDNUMBER(38)N  
ATTACHMENTBLOBN  
FILE_SIZENUMBER(38)N  
FILE_NAMEVARCHAR2(200.0)N  
MIME_TYPEVARCHAR2(100.0)N  
DISPLAYVARCHAR2(20.0)Y  

Primary key:

Constraint NameColumns
SYS_C002088168ATTACH_ID

Check Constraints:

Constraint NameCheck Condition
SYS_C002088162"SLIDE_ID" IS NOT NULL
SYS_C002088163"ATTACHMENT" IS NOT NULL
SYS_C002088164"FILE_SIZE" IS NOT NULL
SYS_C002088165"FILE_NAME" IS NOT NULL
SYS_C002088166"MIME_TYPE" IS NOT NULL
SYS_C002088167display in ('preamble', 'bullets', 'postamble', 'top', 'after-preamble', 'after-bullets', 'bottom')

Foreign Keys:

Constraint NameColumnsReferenced tableReferenced ConstraintOn Delete Rule
SYS_C002088169SLIDE_ID WP_SLIDES SYS_C002088148 CASCADE

Options:

OptionSettings
Index OrganizedNo
Generated by OracleNo
ClusteredNo
NestedNo
TemporaryNo

Indexes:

Index NameTypeUnuquenessColumns
SYS_C002088168NORMALUNIQUEATTACH_ID
SYS_IL0001976931C00003$$LOBUNIQUE 
WP_ATTACHMENTS_BY_SLIDENORMALNONUNIQUESLIDE_ID

Generated by OraSchemaDoc, (c) Aram Kananov, 2002