PSM_Photo (ver2.0)
This table contains photo images.
Column Name | Initial Version | Data Type | Description |
---|---|---|---|
ID | 2.0 | Number(19,0) | Unique sequential number generated by the application. Required. |
ImageData | 2.0 | BLOB | Photo image. |
MimeType | 2.0 | Varchar2(50) | Type of data stored in ImageData, such as image/jpeg, image/tiff, or image/png. |
WhenCreated | 2.0 | Timestamp(6) | Date and time the record was created. Defaults to system date. |
WhenModified | 2.0 | Timestamp(6) | Date and time the record was modified. Defaults to system date. |
WhoCreated | 2.0 | Varchar2(100) | The user login that created the record. Defaults to database user. |
WhoModified | 2.0 | Varchar2(100) | The user login that modified the record. Defaults to database user. |