Aeon Database Tables

Follow

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)

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)

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)

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)

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)

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)

Routing

PK Field Name Field Type
PK RuleNo int
  RuleActive nvarchar(3)
  TransactionStatus int
  MatchString nvarchar(500)
  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)

Sites

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

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)

StaffLayouts

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

StaffSessions

PK Field Name Field Type
PK ID int
  LastPing datetime
  StaffUsername nvarchar(50)
  Workstation 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

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

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)

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)

Questions?

If this article didn’t resolve your issue, please take a moment and answer a few questions to help improve our documentation:

Feedback