Table: unanet_properties_history

Previous: unanet_properties

Unanet Data Model

Next: unit_of_measure

Columns

		Column Name	Data Type	Default Value	References Table	Foreign Key Name
1.	PK	updated_timestamp	datetime	(getdate())
2.	PK	updater_key	decimal(15)		person	fk_unanet_properties_history1
3.	PK	property_name	varchar(200)
4.		property_old_value	varchar(4000)
5.		property_new_value	varchar(4000)

Foreign Keys

Column	References		Foreign Key Name
	Table	Column
updater_key	person	person_key	fk_unanet_properties_history1

Indices

Index Name	Unique	Column Name	Asc Or Desc
pk_unanet_properties_history	true	updated_timestamp	Asc
		updater_key
		property_name