DBA Data[Home] [Help] [Dependency Information]

TABLE: HR.PER_IMAGES

Object Details
Object Name: PER_IMAGES
Object Type: TABLE
Owner: HR
FND Design Data: TablePER.PER_IMAGES
Subobject Name:
Status: VALID


PER_IMAGES stores the images of any entity. It holds it by the entity
name and primary key of the entity.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Primary Key: PER_IMAGES_PK
  1. ColumnIMAGE_ID
Unique Key: PER_IMAGES_UK2
  1. ColumnTABLE_NAME
  2. ColumnPARENT_ID
Indexes
Index Type Uniqueness Tablespace Column
PER_IMAGES_PK NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnIMAGE_ID
PER_IMAGES_UK2 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnTABLE_NAME
ColumnPARENT_ID
SYS_IL0000043902C00004$$ LOB UNIQUE TablespaceAPPS_TS_TX_DATA
Columns
Name Datatype Length Mandatory Comments
IMAGE_ID NUMBER (15) Yes System generated unique identifier from PER_IMAGES_S.
PARENT_ID NUMBER (15) Yes Primary key of row for which image is held.
TABLE_NAME VARCHAR2 (30) Yes Table holding row for which image is held.
IMAGE BLOB (4000) Yes The digitized image, held in TIFF, BMP, JFIF, PCX, PICT or other supported format.
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT IMAGE_ID
,      PARENT_ID
,      TABLE_NAME
,      IMAGE
FROM HR.PER_IMAGES;

Dependencies

[top of page]

HR.PER_IMAGES does not reference any database object

HR.PER_IMAGES is referenced by following:

SchemaHR
ViewPER_IMAGES#