Empsphoto

Columns


Name	Type	Description
EmpsCitizenshipId [KEY]	Long	EmpsCitizenshipId of Empsphoto
EmpsDriversLicenseId [KEY]	Long	EmpsDriversLicenseId of Empsphoto
EmpsEffectiveStartDate [KEY]	Date	EmpsEffectiveStartDate of Empsphoto
EmpsPassportId [KEY]	Long	EmpsPassportId of Empsphoto
EmpsPersonId [KEY]	Long	EmpsPersonId of Empsphoto
EmpsReligionId [KEY]	Long	EmpsReligionId of Empsphoto
Image	String	Unique location of the image. Encrypted version of the file.
ImageName	String	Name of the image.
PrimaryFlag	Bool	Indicates whether the image is primary.
ImageId [KEY]	Long	Photo ID
PersonId	Long	PersonId of Empsphoto
ObjectVersionNumber	Int	Used to implement optimistic locking. This number is incremented every time a row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried.

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。