Aeon Database Tables

Sara Juel

Updated May 15, 2024 13:16

This page provides a complete alphabetical list of the database tables and fields used in Aeon.

Primary keys for the tables are designated in the PK column in each table.

Accounts

PK	Field Name	Field Type
PK	ID	nvarchar(50)
	Description	nvarchar(255)

Activities

PK	Field Name	Field Type
PK	ID	int
	Name	nvarchar(100)
	Description	nvarchar(255)
	ActivityType	nvarchar(100)
	ReferenceName	nvarchar(100)
	ReferenceNumber	nvarchar(30)
	BeginDate	datetime
	EndDate	datetime
	Active	bit
	Location	nvarchar(150)
	ActivityInfo1	nvarchar(255)
	ActivityInfo2	nvarchar(255)
	ActivityInfo3	nvarchar(255)
	ActivityInfo4	nvarchar(255)
	ActivityInfo5	nvarchar(255)
	ActivityStatus	nvarchar(255)
	ActivityStatusDate	datetime
	BillingCategory	nvarchar(50)

ActivityAttendance

PK	Field Name	Field Type
PK	ID	int
	ActivityID	int
	AttendanceDate	date
	AttendanceCount	int

ActivityHistory

PK	Field Name	Field Type
PK	ID	int
	ActivityID	int
	HistoryDate	datetime
	HistoryType	nvarchar(20)
	Entry	nvarchar(max)
	Username	nvarchar(50)

ActivityLink

PK	Field Name	Field Type
PK	ID	int
PK	Username	nvarchar(50)

ActivityNotes

PK	Field Name	Field Type
PK	ID	int
	ActivityID	int
	NoteDate	datetime
	Note	nvarchar(max)
	Username	nvarchar(50)

Addons

PK	Field Name	Field Type
PK	ID	int
	Name	nvarchar(100)
	AddonType	nvarchar(50)
	Active	bit
	Package	varbinary(max)
	Settings	nvarchar(max)
	Permissions	nvarchar(max)
	LastUpdated	datetime

Alerts

PK	Field Name	Field Type
PK	AlertID	int
	IdentifierType	nvarchar(50)
	IdentifierValue	nvarchar(50)
	AlertTitle	nvarchar(255)
	AlertMessage	nvarchar(max)
	CreatedDate	datetime
	ActiveDate	date
	ExpirationDate	date
	AddedBy	nvarchar(50)

Appointments

PK	Field Name	Field Type
PK	ID	int
FK	Username	nvarchar(50)
FK	ReadingRoomID	int
	StartTime	datetime
	StopTime	datetime
	Name	nvarchar(50)
	AvailableToProxies	bit
	CreationDate	datetime
	AppointmentStatus	nvarchar(20)
	ReminderSent	bit

AppointmentExceptions

PK	Field Name	Field Type
PK	ID	int
FK	ReadingRoomID	int
	Type	nvarchar(20)
	NumSeatsReserved	int
	StartDate	datetime
	EndDate	datetime
	PublicNotes	nvarchar(100)

AppointmentHistory

PK	Field Name	Field Type
PK	ID	int
	AppointmentID	int
	HistoryDate	DateTime
	HistoryType	nvarchar(20) This field can have one of two values: Rescheduled: If ReadingRoomID, StartTime, or StopTime is changed on the appointment record Updated: If any other values are changed on the appointment record
	FieldName	nvarchar(128)
	OldValue	nvarchar(50)
	NewValue	nvarchar(50)
	Username	nvarchar(50)

AppointmentNotes

PK	Field Name	Field Type
PK	ID	int
	AppointmentID	int
	NoteDate	datetime
	Note	nvarchar(max)
	Username	nvarchar(50)

BatchProcessing

PK	Field Name	Field Type
PK	Name	nvarchar(100)
	StartingStatuses	nvarchar(max)
	EndStatus	int

BillingDefaults

PK	Field Name	Field Type
PK	BillingContext	nvarchar(255)
PK	BillingType	nvarchar(255)
PK	BillingCategory	nvarchar(50)
	BaseFee	money
	UnitFee	money
	TaxRate	float
	IsUnitPageCount	bit

BillingDetails

PK	Field Name	Field Type
PK	ID	int
	TransactionNumber	int
	BillingContext	nvarchar(255)
	BillingType	nvarchar(255)
	BaseFee	money
	UnitFee	money
	TaxRate	float
	Quantity	int
	BillingDate	datetime

BillingGateways

PK	Field Name	Field Type
PK	ID	int
	Configuration	varbinary(max)

BillingGatewayTransactionLinks

PK	Field Name	Field Type
PK	BillingGatewayTransactionID	int
PK	BillingGatewayTransactionNumber	int

BillingGatewayTransactions

PK	Field Name	Field Type
PK	ID	int
	TransactionDate	datetime
	System	nvarchar(20)
	ProcessorUsername	nvarchar(50)
	Username	nvarchar(50)
	Amount	money
	AuthorizationCode	nvarchar(100)
	ResponseData	nvarchar(max)
	SystemTransactionID	nvarchar(100)
	TransactionAuthenticationKey	nvarchar(50)
	CustomData	nvarchar(max)

BillingPayments

PK	Field Name	Field Type
PK	ID	int
	TransactionNumber	int
	PaymentMethod	nvarchar(30)
	PaymentReference	nvarchar(50)
	PaymentAmount	money
	PaymentDate	datetime
	AuthorizationCode	nvarchar(100)

Bundles

PK	Field Name	Field Type
PK	ID	int
	Name	nvarchar(500)
	Description	nvarchar(max)

CustomDropDown

PK	Field Name	Field Type
PK	GroupName	nvarchar(100)
PK	LabelName	nvarchar(200)
	LabelValue	nvarchar(255)

CustomFieldsDefinition

PK	Field Name	Field Type
PK	ID	int
	ContextType	int 1 for Transaction 2 for User 3 for Activity
	DataType	int 1 for Date 2 for DateTime 3 for Integer 4 for Short Text 5 for Long Text 6 for CustomDropDown 7 for Boolean
	ShortName	nvarchar(50)
	Label	nvarchar(255)

CustomFieldValues

PK	Field Name	Field Type
PK	ID	int
FK	TransactionNumber	int
FK	ActivityID	int
FK	Username	nvarchar(50)
FK	CustomFieldDefinitionId	int
	DateTimeValue	datetime
	IntValue	int
	TextValue	nvarchar(255)
	BoolValue	bit

CustomFlags

PK	Field Name	Field Type
PK	ID	int
	FlagName	nvarchar(50)

Customization

PK	Field Name	Field Type
PK	CustKey	nvarchar(100)
	Value	nvarchar(255)
	Description	nvarchar(255)
	AdminCat	nvarchar(50)
	AdminKey	nvarchar(50)
	AdminType	nvarchar(50)

CustomizationTracking

PK	Field Name	Field Type
PK	CustKey	nvarchar(100)
	ValueChangedFrom	nvarchar(255)
	ValueChangedTo	nvarchar(255)
PK	ChangedTime	datetime
	ChangedBy	nvarchar(50)

EADMapping

PK	Field Name	Field Type
PK	ID	int
	SortOrder	int
	URIMatchString	nvarchar(255)
	XPathMatchString	nvarchar(255)
	NameSpace	nvarchar(100)
	CollectionXSLTFileName	nvarchar(100)

EmailCopies

PK	Field Name	Field Type
PK	ID	int
	EmailDate	datetime
	EmailType	nvarchar(50)
	EmailReference	nvarchar(50)
	EmailTo	nvarchar(255)
	EmailFrom	nvarchar(255)
	EmailCC	nvarchar(255)
	EmailBCC	nvarchar(255)
	Subject	nvarchar(255)
	Body	nvarchar(max)
	Staff	nvarchar(50)
	Status	nvarchar(20)
	Note	nvarchar(255)

EmailRouting

PK	Field Name	Field Type
PK	TemplateName	nvarchar(50)
	TransactionStatus	int
	PhotoduplicationStatus	int

EmailTemplates

PK	Field Name	Field Type
PK	Name	nvarchar(50)
	Description	nvarchar(255)
	Subject	nvarchar(255)
	CCAddress	nvarchar(255)
	Text	nvarchar(max)
	ToName	nvarchar(100)
	ToAddress	nvarchar(100)
	Type	nvarchar(30)
	BCCAddress	nvarchar(255)

ExternalRequestsReceived

PK	Field Name	Field Type
PK	ID	int
	WebPlatformConfigID	int
	TransactionNumber	int
	ExternalID	nvarchar(100)
	CallbackUrlSuffix	nvarchar(150)
	State	nvarchar(50)
	Response	nvarchar(max)

FieldCustomizations

PK	Field Name	Field Type
PK	TemplateName	nvarchar(50)
PK	FieldName	nvarchar(50)
	DisplayName	nvarchar(50)
	IsHidden	bit

FileInformation

PK	Field Name	Field Type
PK	ID	int
	FileName	nvarchar(75)
	FileSize	int
	Modified	datetime
	ModifiedBy	nvarchar(50)

Files

PK	Field Name	Field Type
	FileID	int
	FileData	varbinary(max)

History

PK	Field Name	Field Type
PK	ID	int
	TransactionNumber	int
	HistoryDate	datetime
	Entry	nvarchar(255)
	Username	nvarchar(50)

LocalInfo

PK	Field Name	Field Type
PK	Type	nvarchar(50)
	SystemName	nvarchar(50)
	SystemURL	nvarchar(50)
	InstitutionName	nvarchar(50)
	LibraryName	nvarchar(50)
	GeneralContactName	nvarchar(50)
	GeneralPhone	nvarchar(50)
	GeneralEmailAddress	nvarchar(50)
	GeneralAddress1	nvarchar(50)
	GeneralAddress2	nvarchar(50)
	GeneralCity	nvarchar(50)
	GeneralState	nvarchar(50)
	GeneralZip	nvarchar(50)
	GeneralFax	nvarchar(50)
	GeneralHours	nvarchar(100)
	GeneralCountry	nvarchar(50)

Log

PK	Field Name	Field Type
PK	ID	int
	LogDateTime	datetime
	Source	nvarchar(50)
	Version	nvarchar(50)
	Type	nvarchar(50)
	Message	nvarchar(255)
	Identifier	nvarchar(50)

Notes

PK	Field Name	Field Type
PK	ID	int
	TransactionNumber	int
	NoteDate	datetime
	Note	nvarchar(max)
	Username	nvarchar(50)
	NoteType	nvarchar(50)

OpenURLMapping

PK	Field Name	Field Type
	URL_Ver	nvarchar(50)
	rfr_id	nvarchar(100)
	AeonAction	nvarchar(50)
	AeonFieldName	nvarchar(100)
	OpenURLFieldValues	nvarchar(255)
	AeonValue	nvarchar(100)

ProxyLink

PK	Field Name	Field Type
PK	ResearcherUsername	nvarchar(50)
PK	ProxyUsername	nvarchar(50)

Queues

PK	Field Name	Field Type
PK	ID	int
	QueueName	nvarchar(50)
	DisplayName	nvarchar(50)
	StateCode	int
	InternalCode	int
	Active	bit
	IncludeInRequestLimit	bit
	QueueType	nvarchar(50)
	MenuGroup	nvarchar(50)

ReadingRooms

PK	Field Name	Field Type
PK	ReadingRoomID	int
	ReadingRoomName	nvarchar(50)
	ReadingRoomDescription	nvarchar(1000)
	AvailableSeats	int
	TimeZoneID	nvarchar(50)
	MinLeadDays (Aeon 5.1 only)	int This field was removed in Aeon 5.2.
	MaxLeadDays (Aeon 5.1 only)	int This field was removed in Aeon 5.2.
	MinAppointmentLength	int
	MaxAppointmentLength	int
	AppointmentPadding	int
	AppointmentIncrement	int
	LastModifiedTime	datetime
	AppointmentRequired (Aeon 5.1 only)	bit This field was moved to the ReadingRoomPolicies table in Aeon 5.2.

ReadingRoomsForSites

PK	Field Name	Field Type
PK FK	Site	nvarchar(20)
PK FK	ReadingRoomID	int

ReadingRoomHistory

PK	Field Name	Field Type
PK	ID	int
	Username	nvarchar(50)
	TimeIn	datetime
	TimeOut	datetime
	ReadingRoom	nvarchar(50)
	Location	nvarchar(50)
	SignedInBy	nvarchar(50)
	SignedOutBy	nvarchar(50)

ReadingRoomOpenHours

PK	Field Name	Field Type
PK FK	ReadingRoomID	int
PK	DayOfWeek	int
PK	OpenTime	time
PK	CloseTime	time

ReadingRoomPolicies

PK	Field Name	Field Type
PK	ID	int
	ReadingRoomID	int
	UserStatus	nvarchar(50)
	AppointmentMinLeadDays	int
	AppointmentMaxLeadDays	int
	RequestMinLeadDays	int
	RequestMaxLeadDays	int
	AppointmentRequired	bit
	AutoConfirmAppointments	bit
	AppointmentReminderDays	int
	NotifyAppointmentReceived	bit

ReasonsForCancellation

PK	Field Name	Field Type
PK	ReasonNumber	int
	Reason	nvarchar(150)
	DefaultNote	nvarchar(255)

ReferenceQueues

PK	Field Name	Field Type
PK	ID	int
	QueueName	nvarchar(50)
	DisplayName	nvarchar(50)
	StateCode	int
	InternalCode	int
	Active	bit

ReferenceRequests

PK	Field Name	Field Type
PK	ID	int
	Status	int

ResearcherTags

PK	Field Name	Field Type
	Username	nvarchar(50)
	TransactionNumber	int
	Tag	nvarchar(100)

RestrictedFieldGroups

PK	Field Name	Field Type
PK	GroupName	nvarchar(50)
	Description	nvarchar(50)

RestrictedFields

PK	Field Name	Field Type
PK	GroupName	nvarchar(50)
PK	TableName	nvarchar(20)
PK	FieldName	nvarchar(20)

Routing

PK	Field Name	Field Type
PK	RuleNo	int
	RuleActive	nvarchar(3)
	TransactionStatus	int
	MatchString	nvarchar(max)
	NewTransactionStatus	int
	RuleDescription	nvarchar(255)

ServerAddons

PK	Field Name	Field Type
PK	ID	int
	Name	nvarchar(100)
	Configuration	nvarchar(max)
	Code	nvarchar(max)

ServicePackageLinks

PK	Field Name	Field Type
FK	ServicePackageID	int
FK	BillingContext	nvarchar(255)
FK	BillingType	nvarchar(255)
FK	BillingCategory	nvarchar(50)

ServicePackages

PK	Field Name	Field Type
PK	ID	int
	Name	nvarchar(100)
	BillingCategory	nvarchar(50)

SiteGroups

PK	Field Name	Field Type
PK	SiteGroup	nvarchar(20)
	Description	nvarchar(50)

SiteGroupSites

PK	Field Name	Field Type
PK	SiteGroup	nvarchar(20)
PK	Site	nvarchar(20)

Sites

PK	Field Name	Field Type
PK	Site	nvarchar(20)
	Description	nvarchar(50)
	Parent	nvarchar(20)

StaffLayouts

PK	Field Name	Field Type
PK	Username	nvarchar(50)
PK	LayoutType	nvarchar(150)
	Layout	varbinary(max)
	LayoutGroup	nvarchar(50)

StaffProfiles

PK	Field Name	Field Type
PK	Profile	nvarchar(20)
	WebClientLayout	nvarchar(20)

StaffRestrictedFieldGroups

PK	Field Name	Field Type
PK	Profile	nvarchar(20)
PK	GroupName	nvarchar(50)

StaffSessions

PK	Field Name	Field Type
PK	ID	int
	LastPing	datetime
	StaffUsername	nvarchar(50)
	Workstation	nvarchar(100)

StaffSiteGroups

PK	Field Name	Field Type
PK	Username	nvarchar(50)
PK	SiteGroup	nvarchar(20)
	Active	bit

StaffWebClientSessions

PK	Field Name	Field Type
PK	Username	nvarchar(50)
	AccessToken	nvarchar(2048)
PK	RefreshToken	nvarchar(100)
	ExpirationDate	datetime

Staff

PK	Field Name	Field Type
PK	Username	nvarchar(50)
	Password	nvarchar(255)
	StaffFirstName	nvarchar(50)
	StaffLastName	nvarchar(50)
	StaffDescription	nvarchar(100)
	ClientAccess	nvarchar(3)
	CustomizationManagerAccess	nvarchar(3)
	StaffManagerAccess	nvarchar(3)
	AddonAccess	nvarchar(3)
	AllowDataExport	nvarchar(3)
	TemplateName	nvarchar(50)
	TemplateModifiedBy	nvarchar(50)
	TemplateModifiedDate	datetime
	IsTemplate	bit
	LayoutTemplateCustomization	nvarchar(3)
	AllowLogonToWeb	nvarchar(3)
	WebClientProfile	nvarchar(20)
	MultiFactorAuthKey	nvarchar(100)

SystemInformation

PK	Field Name	Field Type
PK	Source	nvarchar(50)
PK	Type	nvarchar(50)
	Information	nvarchar(255)

Tracking

PK	Field Name	Field Type
PK	ID	int
	TransactionNumber	int
	ChangedDate	datetime
	ChangedTo	int
	ChangedBy	nvarchar(50)

TransactionAccountLinks

PK	Field Name	Field Type
PK	TransactionNumber	int
PK	AccountId	nvarchar(50)

TransactionAttachments

PK	Field Name	Field Type
	TransactionNumber	int
	FieldID	int

TransactionFlags

PK	Field Name	Field Type
PK	ID	int
	TransactionNumber	int
	FlagID	int

TransactionLinks

PK	Field Name	Field Type
PK	Transaction1	int
PK	Transaction2	int
	Comment	nvarchar(255)
	CreatedDate	datetime
	CreatedBy	nvarchar(50)

Transactions

PK	Field Name	Field Type
PK	TransactionNumber	int
	Site	nvarchar(20)
	Username	nvarchar(50)
	ResearcherUsername	nvarchar(50)
	ActivityID	int
	TransactionStatus	int
	TransactionDate	datetime
	DocumentType	nvarchar(50)
	ItemAuthor	nvarchar(255)
	ItemTitle	nvarchar(255)
	ItemSubTitle	nvarchar(255)
	ItemDate	nvarchar(50)
	ItemEdition	nvarchar(50)
	ItemVolume	nvarchar(255)
	ItemIssue	nvarchar(255)
	ItemPages	nvarchar(50)
	ItemISxN	nvarchar(50)
	ItemCitation	nvarchar(255)
	ItemNumber	nvarchar(50)
	EADNumber	nvarchar(255)
	ReferenceNumber	nvarchar(50)
	PageCount	int
	CallNumber	nvarchar(255)
	Location	nvarchar(255)
	SubLocation	nvarchar(255)
	ReasonForCancellation	nvarchar(150)
	MaxCost	nvarchar(50)
	InternalAcctNo	int
	InvoiceNumber	int
	WebRequestForm	nvarchar(100)
	CancelNote	nvarchar(255)
	Format	nvarchar(255)
	ServiceLevel	nvarchar(255)
	ShippingOption	nvarchar(255)
	ForPublication	nvarchar(3)
	ScheduledDate	datetime
	ItemInfo1	nvarchar(255)
	ItemInfo2	nvarchar(255)
	ItemInfo3	nvarchar(255)
	ItemInfo4	nvarchar(255)
	ItemInfo5	nvarchar(255)
	CreationDate	datetime
	ItemPlace	nvarchar(255)
	ItemPublisher	nvarchar(255)
	SpecialRequest	nvarchar(255)
	PhotoduplicationStatus	int
	PhotoduplicationDate	datetime
	AppointmentID	int
	AccessRestrictions	nvarchar(255)
	ContainerID	nvarchar(255)
	ReshelvingLocation	nvarchar(255)

UserAccountLinks

PK	Field Name	Field Type
PK	Username	nvarchar(50)
PK	AccountId	nvarchar(50)

UserAttachments

PK	Field Name	Field Type
PK	Users_Username	nvarchar(50)
PK	FileInformation_ID	int

UserChangeHistory

PK	Field Name	Field Type
	UserName	nvarchar(50)
	FieldName	nvarchar(50)
	OldValue	nvarchar(255)
	NewValue	nvarchar(255)
	ChangedBy	nvarchar(50)
	ChangedDate	datetime

UserHistory

PK	Field Name	Field Type
PK	ID	int
	Username	nvarchar(50)
	HistoryDate	datetime
	HistoryType	nvarchar(20)
	Entry	nvarchar(max)
	StaffUsername	nvarchar(50)

UserImages

PK	Field Name	Field Type
PK	ID	int
	UserName	nvarchar(50)
	CreatedBy	nvarchar(50)
	CreatedDate	datetime
	Image	varbinary(max)

UserNotes

PK	Field Name	Field Type
PK	ID	int
	UserName	nvarchar(50)
	NoteDate	datetime
	Note	nvarchar(max)
	AddedBy	nvarchar(50)

Users

PK	Field Name	Field Type
PK	UserName	nvarchar(50)
	LastName	nvarchar(50)
	FirstName	nvarchar(50)
	DateOfBirth	date
	ID	nvarchar(50)
	IDType	nvarchar(50)
	AltID	nvarchar(50)
	AltIDType	nvarchar(50)
	Status	nvarchar(50)
	Department	nvarchar(100)
	Organization	nvarchar(50)
	EmailAddress	nvarchar(100)
	Phone	nvarchar(50)
	Fax	nvarchar(50)
	Password	nvarchar(255)
	PasswordHint	nvarchar(50)
	AuthType	nvarchar(50)
	RegistrationStatus	nvarchar(15)
	NotificationMethod	nvarchar(30)
	DeliveryMethod	nvarchar(30)
	LastChangedDate	datetime
	ExpirationDate	date
	Address	nvarchar(50)
	Address2	nvarchar(50)
	City	nvarchar(50)
	State	nvarchar(50)
	Zip	nvarchar(50)
	Country	nvarchar(50)
	BillingCategory	nvarchar(50)
	RSSID	nvarchar(50)
	SAddress	nvarchar(50)
	SAddress2	nvarchar(50)
	SCity	nvarchar(50)
	SState	nvarchar(50)
	SZip	nvarchar(50)
	SCountry	nvarchar(50)
	Cleared	nvarchar(10)
	RequestLimit	int
	ResearchTopics	nvarchar(255)
	ResearchTopicsSharing	nvarchar(3)
	ImageID	int
	UserInfo1	nvarchar(255)
	UserInfo2	nvarchar(255)
	UserInfo3	nvarchar(255)
	UserInfo4	nvarchar(255)
	UserInfo5	nvarchar(255)
	CreationDate	datetime
	PreferredName	nvarchar(50)

UserValidation

PK	Field Name	Field Type
PK	UserName	nvarchar(50)
	LastName	nvarchar(50)
	FirstName	nvarchar(50)
	ID	nvarchar(50)
	AltID	nvarchar(50)
	Status	nvarchar(50)
	Department	nvarchar(100)
	Organization	nvarchar(50)
	EmailAddress	nvarchar(50)
	Phone	nvarchar(50)
	Fax	nvarchar(50)
	Password	nvarchar(255)
	PasswordHint	nvarchar(50)
	PlainTextPassword	nvarchar(50)
	AuthType	nvarchar(50)
	RegistrationStatus	nvarchar(15)
	NotificationMethod	nvarchar(30)
	DeliveryMethod	nvarchar(30)
	LastChangedDate	datetime
	ExpirationDate	date
	Address	nvarchar(50)
	Address2	nvarchar(50)
	City	nvarchar(50)
	State	nvarchar(50)
	Zip	nvarchar(50)
	Country	nvarchar(50)
	BillingCategory	nvarchar(50)
	RSSID	nvarchar(50)
	SAddress	nvarchar(50)
	SAddress2	nvarchar(50)
	SCity	nvarchar(50)
	SState	nvarchar(50)
	SZip	nvarchar(50)
	SCountry	nvarchar(50)
	Blocked	nvarchar(10)
	DateOfBirth	date
	IDType	nvarchar(50)
	AltIDType	nvarchar(50)
	RequestLimit	int
	UserInfo1	nvarchar(255)
	UserInfo2	nvarchar(255)
	UserInfo3	nvarchar(255)
	UserInfo4	nvarchar(255)
	UserInfo5	nvarchar(255)

WebClientFields

PK	Field Name	Field Type
PK	TableName	nvarchar(20)
PK	WebClientLayout	nvarchar(20)
PK	GroupName	nvarchar(50)
PK	FieldName	nvarchar(50)
	FieldIndex	int
	DisplayName	nvarchar(50)
	Width	nvarchar(6)

WebClientGroups

PK	Field Name	Field Type
PK	TableName	nvarchar(20)
PK	WebClientLayout	nvarchar(20)
PK	GroupName	nvarchar(50)
	GroupDisplayName	nvarchar(50)
	Context	nvarchar(20)
	GroupIndex	int

WebClientLayouts

PK	Field Name	Field Type
PK	LayoutName	nvarchar(20)

WebFormValues

PK	Field Name	Field Type
PK	Formname	nvarchar(100)
PK	SubmitButtonValue	nvarchar(100)
	SubmitButtonText	nvarchar(100)

WebPlatformConfig

PK	Field Name	Field Type
PK	ID	int
	APIKey	uniqueidentifier
	BaseWebserviceUrl	nvarchar(256)
	Description	nvarchar(100)

WebSession

PK	Field Name	Field Type
PK	Username	nvarchar(50)
	SessionID	nvarchar(255)
PK	SessionType	nvarchar(50)
	Expiration	datetime
	LastFormSignature	nvarchar(100)

WebValidation

PK	Field Name	Field Type
PK	Formname	nvarchar(100)
PK	Fieldname	nvarchar(100)
	Validation	nvarchar(255)
	Error	nvarchar(255)
	ErrorTag	nvarchar(60)

ZProfiles

PK	Field Name	Field Type
PK	ProfileName	nvarchar(50)
	DBName	nvarchar(50)
	Port	nvarchar(10)
	SearchSystemNumber	nvarchar(200)
	SearchTitle	nvarchar(200)
	SearchAuthor	nvarchar(200)
	SearchISSN	nvarchar(200)
	SearchISBN	nvarchar(200)
	SearchDate	nvarchar(200)
	SearchKeywordTitle	nvarchar(200)
	SearchKeywordAuthor	nvarchar(200)
	ZType	nvarchar(50)
	ZIdentifier	nvarchar(50)
	ZCallNumber	nvarchar(50)
	ZAvailability	nvarchar(50)
	ZLocation	nvarchar(50)
	AvailabilityType	nvarchar(50)
	AvailabilityRegExp	nvarchar(255)
	AvailableTextType	nvarchar(50)
	AvailableText	nvarchar(50)
	NotAvailableTextType	nvarchar(50)
	NotAvailableText	nvarchar(50)
	SearchCallNumber	nvarchar(200)

ZSearches

PK	Field Name	Field Type
PK	SearchNumber	int
	SearchName	nvarchar(50)
	ServerConfigNumbers	nvarchar(100)
	DefaultSearch	nvarchar(20)
	SortOrder	int

ZServerConfig

PK	Field Name	Field Type
PK	ServerConfigNumber	int
	Name	nvarchar(50)
	Server	nvarchar(50)
	Port	int
	DBName	nvarchar(50)
	ServerType	nvarchar(50)
	SearchSystemNumber	nvarchar(200)
	SearchTitle	nvarchar(200)
	SearchAuthor	nvarchar(200)
	SearchISSN	nvarchar(200)
	SearchISBN	nvarchar(200)
	SearchDate	nvarchar(200)
	SearchKeywordTitle	nvarchar(200)
	SearchKeywordAuthor	nvarchar(200)
	AuthUser	nvarchar(100)
	AuthPass	nvarchar(100)
	ZType	nvarchar(50)
	ZIdentifier	nvarchar(50)
	ZCallNumber	nvarchar(50)
	ZAvailability	nvarchar(50)
	ZLocation	nvarchar(50)
	AvailabilityType	nvarchar(50)
	AvailabilityRegExp	nvarchar(255)
	AvailableTextType	nvarchar(50)
	AvailableText	nvarchar(50)
	NotAvailableTextType	nvarchar(50)
	SearchCallNumber	nvarchar(200)