MAILEXPRESS

Basic Index   Expanded Index

Table Name: medatabase.Actor_passwordHistory
Description: History of user's previous passwords.
Primary Keys: Actor_identifier
passwordHistory_ORDER
Field Type Defaults Nulls? Comments
Actor_identifier numeric (19) None No ID to map back to the 'Actor' table.
passwordHistory nvarchar (255) None Yes An entry in the collection.
passwordHistory_ORDER int None No An entry in the collection.

Index Clustered? Unique? Fields
PK__Actor_pa__2625C8AE379CBB89 Yes Yes

No check constraints
Internal Foreign Key Constraint Affected Field Source Table
FK_Actor_passwordHistory Actor_identifier Actor

No primary keys as foreign key constraints
No triggers