ObjectLoans


Columns

Column Type Size Nulls Auto Default Children Parents Comments
ObjectLoansSeq int identity 4 √ null
EventObjectBookings.ObjectLoansSeq FK_EventObjectBookings_ObjectLoans_ObjectLoansSeq R
ObjectBookingsSeq int 4 null
ObjectBookings.ObjectBookingsSeq FK_ObjectLoans_ObjectBookings R
ObjectNumber int 4 null
Objects.ObjectNumber FK_ObjectLoans_Objects R
ID int 4 √ null
Community.ID FK_ObjectLoans_Community_ID R
LoanedDate datetime 16,3 √ null
ReturnedDate datetime 16,3 √ null
Comment varchar 255 ('')
IssuedByID int 4 √ null
Community.ID FK_ObjectLoans_Community_IssuedByID R
ReturnedToID int 4 √ null
Community.ID FK_ObjectLoans_Community_ReturnedToID R
PABXPIN int 4 √ null
PABXPINStatusCode varchar 15 ('')
DebtorID int 4 √ null
ProcessOverdueChargeFlag bit 1 ((1))
ProcessOverdueReversalFlag bit 1 ((1))

Table contained -1 rows

Indexes

Constraint Name Type Sort Column(s)
PK_ObjectLoans_ObjectLoansSeq Primary key Asc ObjectLoansSeq
AK_ObjectLoans_ID Performance Asc ID
AK_ObjectLoans_LoanedDate Performance Asc LoanedDate
AK_ObjectLoans_ObjectBookingsSeq Performance Asc ObjectBookingsSeq

Relationships

Close relationships within degrees of separation