Overview Tables Views Indexes Constraints Triggers Procedures Functions Packages Sequences Index

PM


Description  Columns  Primary key  Check constraints  Foreign keys  Unique keys  Indexes  Options  Referenced by  Triggers  

PRINT_MEDIA

Columns

Column Datatype Nullable Default value Comment
PRODUCT_ID NUMBER(6,0) N    
AD_ID NUMBER(6,0) N    
AD_COMPOSITE BLOB(4000) Y    
AD_SOURCETEXT CLOB(4000) Y    
AD_FINALTEXT CLOB(4000) Y    
AD_FLTEXTN NCLOB(4000) Y    
AD_TEXTDOCS_NTAB TEXTDOC_TAB(16) Y    
AD_PHOTO BLOB(4000) Y    
AD_GRAPHIC BFILE(530) Y    
AD_HEADER ADHEADER_TYP(1) Y    
PRESS_RELEASE LONG(0) Y    

Primary key

Primary key Columns
PRINTMEDIA__PK PRODUCT_ID, AD_ID

Unique keys

Unique key Columns
SYS_C002451  

Indexes

Index Type Uniqueness Columns
PRINTMEDIA_PK NORMAL UNIQUE PRODUCT_ID, AD_ID
SYS_C002451 NORMAL UNIQUE  
SYS_IL0000029644C00003$$ LOB UNIQUE  
SYS_IL0000029644C00004$$ LOB UNIQUE  
SYS_IL0000029644C00005$$ LOB UNIQUE  
SYS_IL0000029644C00006$$ LOB UNIQUE  
SYS_IL0000029644C00009$$ LOB UNIQUE  
SYS_IL0000029644C00015$$ LOB UNIQUE  

Options

Option Setting
Clustered N
Generated by Oracle N
Index Organized N
Logging Y
Partitioned N
Temporary N
Nested N


Generated by
OraDoclet, Copyright © Oracle Corporation 2005      Last updated: 01.01.2005