Person.Password - AdventureWorks

AdventureWorks

- AdventureWorks

Documentation	AdventureWorks
Schema	Person
Name	Password
Module	People

One way hashed authentication information

Columns

		Key	Name	Data type	Null	Attributes	References	Description
	1		BusinessEntityID	int			Person.Person
References: Person.Person
	2		PasswordHash	varchar(128)				Password for the e-mail account.
Password for the e-mail account.
	3		PasswordSalt	varchar(10)				Random value concatenated with the password string before the password is hashed.
Random value concatenated with the password string before the password is hashed.
	4		rowguid	uniqueidentifier		Default: newid()		ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample. Default: newid()
	5		ModifiedDate	datetime		Default: getdate()		Date and time the record was last updated.
Date and time the record was last updated. Default: getdate()

Relations

Foreign table		Primary table	Join	Title / Name / Description
Person.Password		Person.Person	Person.Password.BusinessEntityID = Person.Person.BusinessEntityID	FK_Password_Person_BusinessEntityID Foreign key constraint referencing Person.BusinessEntityID.
Person.Password.BusinessEntityID = Person.Person.BusinessEntityID Name: FK_Password_Person_BusinessEntityID Foreign key constraint referencing Person.BusinessEntityID.

Unique keys

	Key name	Columns	Description
	PK_Password_BusinessEntityID	BusinessEntityID	Primary key (clustered) constraint
Primary key (clustered) constraint

Uses

Name
Person.Password
Person.Person

Exported: 2019-02-04 23:13, Last imported: 2018-03-07 11:56