Field in Visual Basic .NET

Printer QR-Code in Visual Basic .NET Field

bigint varchar(50) varchar(30) varchar(30)

Description Primary key; automatically assigned. Required. Last name of this author. Required. First name of this author. Optional. Middle name or initial of this author. Optional.

|

varchar(10) smallint smallint varchar(250)

Description Name suffix, such as Jr. Optional. Year of birth. Use negative numbers for BC. Optional. Year of death. Use negative numbers for BC. Optional. Miscellaneous comments about this author. Optional.

ItemAuthor. An author, editor, and so on, for a specific named item. This table establishes a many-to-many relationship between the NamedItem and Author tables.

Description Primary key. The associated named item. Foreign reference to NamedItem.ID. Required. Primary key. The author associated with the named item. Foreign reference to Author.ID. Required. Relative order of this author among the authors for this named item. Authors with smaller numbers appear first. Required. The specific type of contribution given by this author for this named item. Foreign reference to CodeAuthorType.ID. Required.

bigint varchar(50)

ItemKeyword. Connects a keyword with a named item through a many-to-many relationship between the NamedItem and Keyword tables.

Description Primary key. The associated named item. Foreign reference to NamedItem.ID. Required. Primary key. The keyword to associate with the named item. Foreign reference to Keyword.ID. Required.

bigint varchar(150)

ItemSubject. Connects a subject with a named item through a many-to-many relationship between the NamedItem and Subject tables.

Description Primary key. The associated named item. Foreign reference to NamedItem.ID. Required. Primary key. The subject to associate with the named item. Foreign reference to Subject.ID. Required.

The tables in this section define the actual patron records and their relationship to item copies (when such copies are checked out by the patron). Patron. An identified library user. Patrons usually have checkout privileges.

ID LastName FirstName LastActivity Active Comments AdminMessage Barcode Password Email Phone Address City State Postal PatronGroup

bigint varchar(30) varchar(30) datetime bit varchar(max) varchar(500) varchar(20) varchar(20) varchar(100) varchar(20) varchar(50) varchar(20) varchar(2) varchar(10) bigint

Description Primary key; automatically assigned. Required. Last name of this patron. Required. First name of this patron. Required. Date of last checkout, renewal, or return. Optional. Is this an active patron 0 for False, 1 for True. Required. Any comments associated with this patron. Optional. Comments that are displayed to administrative users when the patron s record is accessed. Optional. Bar code found on this patron s library card. At this time, only numeric bar codes are supported. Optional. Patron s password, in an encrypted format. Required. Patron s email address. Optional. Patron s phone number. Optional. Patron s street address. Optional. Patron s city. Optional. Patron s state abbreviation. Optional. Patron s postal code. Optional. The group in which this patron appears. Foreign reference to CodePatronGroup.ID. Optional.

PatronCopy. This table manages item copies currently checked out by a patron, or item copies that were previously checked out and have since been returned.

|

Description Primary key; automatically assigned. Required. The associated patron. Foreign reference to Patron.ID. Required. The item copy currently or previously checked out by the patron. Foreign reference to ItemCopy.ID. Required. The date when this item copy was initially checked out. Required. The number of times this item copy has been renewed. Set to 0 when the item copy is first checked out. Required. Current due date for this item copy. Required. The date when this item copy was returned. Optional. Has the item copy been returned 0 for False, 1 for True. Required. Is the item copy missing and considered lost 0 for False, 1 for True. Required. Total fine accumulated for this item copy. Defaults to 0.00. An administrator may reduce an accumulated fine. Required. Total amount paid (in fees) for this item copy. Required. When an item copy is processed for overdue fines, this field contains the last date for which processing was done. Optional.

PatronPayment. Fines, payments, and dismissals on a patron copy record. Overdue fines are not recorded in this table, but administrator-initiated fines due to charges for missing items are recorded here.