vrpt_KeyRingItem

Updated December 24, 2025 13:07

Field Name	Field Description	Data Type	FK Join
Id	Key Ring Id	int	vr_KeyRing
kr_description	Key Ring Description	nvarchar
kr_kh_fk	Key Holder Id	int	vr_KeyHolder
kr_pk	Key Ring Id	int	vr_KeyRing
kr_tagNumber	Key Ring Tag Number	nvarchar
ktr_kh_fk	Key Holder Id	int	vr_KeyHolder
ktr_kr_fk	Key Ring Id	int	vr_KeyRing
ktr_kser_fk	Key Serial Id	int
ktr_ky_fk	Key Id	int	vr_Key
ktr_pk	Key Transaction Id	int	vr_KeyTransaction
ktr_quantity	Key Transaction Quantity	int
ktr_serialNumber	Key Transaction Serial Number	nvarchar
ky_description	Key Description	nvarchar
ky_number	Key Number	nvarchar
ky_pk	Key Id	int	vr_Key
ky_rc_fk	Repair Center Id	int	vr_RepairCenter