History


Columns

Column Type Size Nulls Auto Default Children Parents Comments
TransactionId int 4 null
HistoryTransactions.TransactionId History_HistoryTransactions_ForeignKey C
HistoryId uniqueidentifier 16 null
HistoryValues.HistoryId HistoryValues_History_ForeignKey C
qryHistory.HistoryId Implied Constraint R
DBTable nvarchar 240 null
Action int 4 null
AnalysisActions.Action Implied Constraint R
Key nvarchar 240 null
KeyValue uniqueidentifier 16 null
DBUsername nvarchar 240 null
UserId uniqueidentifier 16 null
Users.UserId Implied Constraint R
Sequence int identity 4 null
Version.Sequence Implied Constraint R
Date datetime 16 null
Undone bit 1 null

Table contained 0 rows

Indexes

Constraint Name Type Sort Column(s)
History_PrimaryKey Primary key Asc HistoryId
History_HistoryId_Index Performance Asc HistoryId
History_TransactionId_Index Performance Asc TransactionId

Relationships