Real Time Information Director User Documentation

RTID Metadata Language
Hewlett-Packard Company 17 529618-002
Item
PK ItemID
FK1 ISBN
FK3,I1 BranchID
FK2 CheckedOutID
Title
PK ISBN
I1 Title
I2 LastName
I2 FirstName
CheckedOutCopies
CumulativeCheckouts
Category
CheckoutItem
PK,FK2 CheckoutID
PK,FK1 ItemID
CheckOutDate
DueDate
ReturnedDate
Checkout
PK CheckoutID
FK1,I1 CardID
FK2 BranchID
CheckoutDate
LibraryCard
PK CardID
I1 LastName
I1 FirstName
ItemsOut
Branch
PK BranchID
I1 BranchName
FictionCheckedOut
NonFictionCheckedOut
TitleAction
PK,FK1 ISBN
PK RequestDate
FK2,I1 BranchIDFrom
FK3,I2 BranchIDTo
ActionCode
Here is an excerpt from the document definition representing a checkout from the library.
This excerpt links the library card record to the checkout record through the CARDID,
which is not a primary key field in the checkout record; similarly, it links the branch
record to the checkout record through the BRANCHID, which is not a primary key field
in the checkout record.
new DocumentRecord(Library.checkoutRecord, new RelatedRecords[] {
new SplitRecord(Library.libraryCardRecord, new
DependentLinks("CARDID")),
new SplitRecord(Library.branchRecord, new
DependentLinks("BRANCHID")),
…
})
});
For more examples of dependent links, see the Stockbranch and Stocktitle document
definitions in the branch library example.