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  

ONLINE_MEDIA

Columns

Column Datatype Nullable Default value Comment
PRODUCT_ID NUMBER(6,0) N    
PRODUCT_PHOTO ORDIMAGE(1) Y    
PRODUCT_PHOTO_SIGNATURE ORDIMAGESIGNATURE(1) Y    
PRODUCT_THUMBNAIL ORDIMAGE(1) Y    
PRODUCT_VIDEO ORDVIDEO(1) Y    
PRODUCT_AUDIO ORDAUDIO(1) Y    
PRODUCT_TEXT CLOB(4000) Y    
PRODUCT_TESTIMONIALS ORDDOC(1) Y    

Primary key

Primary key Columns
ONLINEMEDIA__PK PRODUCT_ID

Indexes

Index Type Uniqueness Columns
ONLINEMEDIA_PK NORMAL UNIQUE PRODUCT_ID
SYS_IL0000029622C00003$$ LOB UNIQUE  
SYS_IL0000029622C00017$$ LOB UNIQUE  
SYS_IL0000029622C00019$$ LOB UNIQUE  
SYS_IL0000029622C00034$$ LOB UNIQUE  
SYS_IL0000029622C00042$$ LOB UNIQUE  
SYS_IL0000029622C00054$$ LOB UNIQUE  
SYS_IL0000029622C00062$$ LOB UNIQUE  
SYS_IL0000029622C00069$$ LOB UNIQUE  
SYS_IL0000029622C00071$$ LOB UNIQUE  
SYS_IL0000029622C00080$$ 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