Skip to content

SAIF.Framework.Data.NHibernate database tables

This page catalogs the 48 database tables reachable through this library's 42 FluentNHibernate ClassMap<TEntity> mappings — 42 directly mapped entity tables plus 6 many-to-many join tables (COMPANY_ADDRESS, COMPANY_PHONE, COMPANY_PERSON, PERSON_ADDRESS, PERSON_EMAIL, PERSON_PHONE) that have no direct entity class. Schema is recorded as [unqualified]** for every table: no OWNER.TABLE_NAME-qualified reference or @LINK was found in any mapping file, and no connection-string/schema-owner override was found in app.config — the actual owning schema is resolved only at runtime by whichever connection string a consuming application supplies to IUnitOfWorkFactory.GetUnitOfWork(connectionString, batchSize, showSql).

Table catalog

Table Database Schema/Link CRUD Purpose Primary business object
ADDRESS_CODE Oracle-style naming* [unqualified]** C/R/U/D Reference/lookup code table for address types. AddressCode
ADDRESS Oracle-style naming* [unqualified]** C/R/U/D References ADDRESS_CODE; associated with COMPANY and PERSON via join tables. Address
COMPANY Oracle-style naming* [unqualified]** C/R/U/D Many-to-many with ADDRESS, PHONE, PERSON via join tables. Company
COMPANY_ADDRESS Oracle-style naming* [unqualified]** C/R/U/D (join table, no direct entity) Join table for the COMPANY-to-ADDRESS many-to-many association. Company <-> Address
COMPANY_PHONE Oracle-style naming* [unqualified]** C/R/U/D (join table, no direct entity) Join table for the COMPANY-to-PHONE many-to-many association. Company <-> Phone
COMPANY_PERSON Oracle-style naming* [unqualified]** C/R/U/D (join table, no direct entity) Join table for the COMPANY-to-PERSON many-to-many association. Company <-> Person
COUNTRY Oracle-style naming* [unqualified]** C/R/U/D Reference/lookup code table for countries. CountryCode
EMAIL_ADDRESS Oracle-style naming* [unqualified]** C/R/U/D References EMAIL_CODE; version-tracked via UpdateNum; referenced by EXT_USER. EmailAddress
EMAIL_CODE Oracle-style naming* [unqualified]** C/R/U/D Reference/lookup code table for email types. EmailCode
PERSON Oracle-style naming* [unqualified]** C/R/U/D Many-to-many with ADDRESS, EMAIL_ADDRESS, PHONE via join tables; referenced by EXT_USER. Person
PERSON_ADDRESS Oracle-style naming* [unqualified]** C/R/U/D (join table, no direct entity) Join table for the PERSON-to-ADDRESS many-to-many association. Person <-> Address
PERSON_EMAIL Oracle-style naming* [unqualified]** C/R/U/D (join table, no direct entity) Join table for the PERSON-to-EMAIL_ADDRESS many-to-many association. Person <-> EmailAddress
PERSON_PHONE Oracle-style naming* [unqualified]** C/R/U/D (join table, no direct entity) Join table for the PERSON-to-PHONE many-to-many association. Person <-> Phone
PHONE_CODE Oracle-style naming* [unqualified]** C/R/U/D Reference/lookup code table for phone types. PhoneCode
PHONE Oracle-style naming* [unqualified]** C/R/U/D References PHONE_CODE; associated with COMPANY and PERSON via join tables. Phone
ALL_STATES Oracle-style naming* [unqualified]** C/R/U/D Reference/lookup code table for U.S. states. StateCode
DEPLOYMENT_REQUEST unspecified* [unqualified]** C/R/U/D Deployment domain entity; ID generation strategy not confirmed. DeploymentRequest
DEPLOYMENT_RESULT unspecified* [unqualified]** C/R/U/D Deployment domain entity; ID generation strategy not confirmed. DeploymentResult
DEPLOYMENT_STAGED unspecified* [unqualified]** C/R/U/D Deployment domain entity; ID generation strategy not confirmed. DeploymentStaged
ADP_EMPLOYEE Oracle-style naming* [unqualified]** C/R/U/D Self-referencing via RPT_MGR_EMPLID (Supervisor). Employee
EMPLOYEE_STATUS_CODE Oracle-style naming* [unqualified]** C/R/U/D Reference/lookup code table for employee status. EmployeeStatusCode
WCIS_Employee unspecified - lower_snake_case columns* [unqualified]** C/R/U/D References a status code table (target entity inferred*). WcisEmployee
image Oracle-style naming* [unqualified]** C/R/U/D - populated via SQL-001, not a mapped generator Version-tracked via UpdateDate; read-only references to DocumentCategory/ImageSystem/DocumentType/DocumentName; has many ImageAffiliations. Image
IMAGE_AFFILIATION Oracle-style naming* [unqualified]** C/R/U/D References image (Image); dual ID-generation path (native generator and SQL-003) not reconciled.** ImageAffiliation
image_category_code Oracle-style naming* [unqualified]** C/R/U/D Has many ImageDocumentTypeCode (composite-keyed, Cascade.None()). ImageCategoryCode
image_document_name_code Oracle-style naming* [unqualified]** C/R/U/D Reference/lookup code table for image document names. ImageDocumentNameCode
image_document_name_gcode Oracle-style naming* [unqualified]** C/R/U/D Reference/lookup code table for image document names (grouped variant). ImageDocumentNameGCode
image_document_type_code Oracle-style naming* [unqualified]** C/R/U/D KeyReference to image_category_code composite key. ImageDocumentTypeCode
image_document_type_gcode Oracle-style naming* [unqualified]** C/R/U/D Reference/lookup code table for image document types (grouped variant). ImageDocumentTypeGCode
image_file_code Oracle-style naming* [unqualified]** C/R/U/D Reference/lookup code table for image document type groups. ImageDocumentTypeGroupCode
image_external_view_code Oracle-style naming* [unqualified]** C/R/U/D Reference/lookup code table for image external view types. ImageExternalViewCode
IMGSYS Oracle-style naming* [unqualified]** C/R/U/D - populated via SQL-002, not a mapped generator Has many Image; columns heavily abbreviated (IFNDS, IFNID, NPAGES, DELCD, CRTRID, IDXFL, SLEVEL, SCANDT, UPDTTS, UPDRID, BATID). ImageSystem
BOL_MENU_VW unspecified* [unqualified]** R only (maps a database view, not a base table)* Maps a database view rather than a base table. BusinessOnlineMenuItem
pdf_app_error_code Oracle-style naming* [unqualified]** C/R/U/D Version-tracked via CreateDate; referenced by pdf_tracking. PDFApplicationErrorCode
pdf_cache Oracle-style naming* [unqualified]** C/R/U/D PDF cache domain entity. PDFCache
pdf_cache_process Oracle-style naming* [unqualified]** C/R/U/D References pdf_cache_status_code (Status). PDFCacheProcess
pdf_cache_request Oracle-style naming* [unqualified]** C/R/U/D References pdf_cache_status_code (Status). PDFCacheRequest
pdf_cache_status_code Oracle-style naming* [unqualified]** C/R/U/D Reference/lookup code table referenced by pdf_cache_process, pdf_cache_request, pdf_tracking. PDFStatusCode
pdf_tracking_code Oracle-style naming* [unqualified]** C/R/U/D Reference/lookup code table referenced by pdf_tracking. PDFTrackingCode
pdf_tracking Oracle-style naming* [unqualified]** C/R/U/D Version-tracked via UpdateNumber; references pdf_app_error_code, pdf_cache_status_code, pdf_tracking_code. PDFTracking
XDOCUMENT Oracle-style naming* [unqualified]** C/R/U/D References XPRINT_CONTROL. XDocument
XPRINT_CONTROL Oracle-style naming* [unqualified]** C/R/U/D Has many XDOCUMENT (inverse, .Not.OptimisticLock()). XPrintControl
USER_PREFERENCE Oracle-style naming* [unqualified]** C/R/U/D User preferences domain entity. Preference
EXT_USER Oracle-style naming* [unqualified]** C/R/U/D Version-tracked via UpdateNumber; references EMAIL_ADDRESS, PERSON, ext_user_status_code (Status); has many ext_user_type (inverse, Cascade.AllDeleteOrphan()). ExternalUser
ext_user_status_code Oracle-style naming* [unqualified]** C/R/U/D Reference/lookup code table referenced by EXT_USER (Status). ExternalUserStatusCode
ext_user_type_code Oracle-style naming* [unqualified]** C/R/U/D Reference/lookup code table referenced by ext_user_type. ExternalUserTypeCode
ext_user_type Oracle-style naming* [unqualified]** C/R/U/D References COMPANY, EXT_USER (User), ext_user_type_code (UserTypeCode). ExternalUserType
Context unspecified* [unqualified]** C/R/U/D Several unmapped-column, convention-matched properties. WebContextItem

ADDRESS_CODE

Field Value
Database Oracle-style naming*
Schema/Link [unqualified]**
Purpose Reference/lookup code table for address types.
Access pattern Direct SQL (NHibernate-generated)
CRUD operations C/R/U/D
Sequence N/A
Business objects AddressCode

ADDRESS

Field Value
Database Oracle-style naming*
Schema/Link [unqualified]**
Purpose References ADDRESS_CODE; associated with COMPANY and PERSON via join tables.
Access pattern Direct SQL (NHibernate-generated)
CRUD operations C/R/U/D
Sequence ADDRESS_SEQ
Business objects Address

COMPANY

Field Value
Database Oracle-style naming*
Schema/Link [unqualified]**
Purpose Many-to-many with ADDRESS, PHONE, PERSON via join tables.
Access pattern Direct SQL (NHibernate-generated)
CRUD operations C/R/U/D
Sequence COMPANY_SEQ
Business objects Company

COMPANY_ADDRESS

Field Value
Database Oracle-style naming*
Schema/Link [unqualified]**
Purpose Join table for the COMPANY-to-ADDRESS many-to-many association.
Access pattern Direct SQL (NHibernate-generated)
CRUD operations C/R/U/D (join table, no direct entity)
Sequence N/A
Business objects Company <-> Address

COMPANY_PHONE

Field Value
Database Oracle-style naming*
Schema/Link [unqualified]**
Purpose Join table for the COMPANY-to-PHONE many-to-many association.
Access pattern Direct SQL (NHibernate-generated)
CRUD operations C/R/U/D (join table, no direct entity)
Sequence N/A
Business objects Company <-> Phone

COMPANY_PERSON

Field Value
Database Oracle-style naming*
Schema/Link [unqualified]**
Purpose Join table for the COMPANY-to-PERSON many-to-many association.
Access pattern Direct SQL (NHibernate-generated)
CRUD operations C/R/U/D (join table, no direct entity)
Sequence N/A
Business objects Company <-> Person

COUNTRY

Field Value
Database Oracle-style naming*
Schema/Link [unqualified]**
Purpose Reference/lookup code table for countries.
Access pattern Direct SQL (NHibernate-generated)
CRUD operations C/R/U/D
Sequence N/A
Business objects CountryCode

EMAIL_ADDRESS

Field Value
Database Oracle-style naming*
Schema/Link [unqualified]**
Purpose References EMAIL_CODE; version-tracked via UpdateNum; referenced by EXT_USER.
Access pattern Direct SQL (NHibernate-generated)
CRUD operations C/R/U/D
Sequence EMAIL_ADDRESS_SEQ
Business objects EmailAddress

EMAIL_CODE

Field Value
Database Oracle-style naming*
Schema/Link [unqualified]**
Purpose Reference/lookup code table for email types.
Access pattern Direct SQL (NHibernate-generated)
CRUD operations C/R/U/D
Sequence N/A
Business objects EmailCode

PERSON

Field Value
Database Oracle-style naming*
Schema/Link [unqualified]**
Purpose Many-to-many with ADDRESS, EMAIL_ADDRESS, PHONE via join tables; referenced by EXT_USER.
Access pattern Direct SQL (NHibernate-generated)
CRUD operations C/R/U/D
Sequence PERSON_SEQ
Business objects Person

PERSON_ADDRESS

Field Value
Database Oracle-style naming*
Schema/Link [unqualified]**
Purpose Join table for the PERSON-to-ADDRESS many-to-many association.
Access pattern Direct SQL (NHibernate-generated)
CRUD operations C/R/U/D (join table, no direct entity)
Sequence N/A
Business objects Person <-> Address

PERSON_EMAIL

Field Value
Database Oracle-style naming*
Schema/Link [unqualified]**
Purpose Join table for the PERSON-to-EMAIL_ADDRESS many-to-many association.
Access pattern Direct SQL (NHibernate-generated)
CRUD operations C/R/U/D (join table, no direct entity)
Sequence N/A
Business objects Person <-> EmailAddress

PERSON_PHONE

Field Value
Database Oracle-style naming*
Schema/Link [unqualified]**
Purpose Join table for the PERSON-to-PHONE many-to-many association.
Access pattern Direct SQL (NHibernate-generated)
CRUD operations C/R/U/D (join table, no direct entity)
Sequence N/A
Business objects Person <-> Phone

PHONE_CODE

Field Value
Database Oracle-style naming*
Schema/Link [unqualified]**
Purpose Reference/lookup code table for phone types.
Access pattern Direct SQL (NHibernate-generated)
CRUD operations C/R/U/D
Sequence N/A
Business objects PhoneCode

PHONE

Field Value
Database Oracle-style naming*
Schema/Link [unqualified]**
Purpose References PHONE_CODE; associated with COMPANY and PERSON via join tables.
Access pattern Direct SQL (NHibernate-generated)
CRUD operations C/R/U/D
Sequence PHONE_SEQ
Business objects Phone

ALL_STATES

Field Value
Database Oracle-style naming*
Schema/Link [unqualified]**
Purpose Reference/lookup code table for U.S. states.
Access pattern Direct SQL (NHibernate-generated)
CRUD operations C/R/U/D
Sequence N/A
Business objects StateCode

DEPLOYMENT_REQUEST

Field Value
Database unspecified*
Schema/Link [unqualified]**
Purpose Deployment domain entity; ID generation strategy not confirmed.
Access pattern Direct SQL (NHibernate-generated)
CRUD operations C/R/U/D
Sequence unspecified generator strategy**
Business objects DeploymentRequest

DEPLOYMENT_RESULT

Field Value
Database unspecified*
Schema/Link [unqualified]**
Purpose Deployment domain entity; ID generation strategy not confirmed.
Access pattern Direct SQL (NHibernate-generated)
CRUD operations C/R/U/D
Sequence unspecified generator strategy**
Business objects DeploymentResult

DEPLOYMENT_STAGED

Field Value
Database unspecified*
Schema/Link [unqualified]**
Purpose Deployment domain entity; ID generation strategy not confirmed.
Access pattern Direct SQL (NHibernate-generated)
CRUD operations C/R/U/D
Sequence unspecified generator strategy**
Business objects DeploymentStaged

ADP_EMPLOYEE

Field Value
Database Oracle-style naming*
Schema/Link [unqualified]**
Purpose Self-referencing via RPT_MGR_EMPLID (Supervisor).
Access pattern Direct SQL (NHibernate-generated)
CRUD operations C/R/U/D
Sequence N/A (EMPLID assigned by convention*)
Business objects Employee

EMPLOYEE_STATUS_CODE

Field Value
Database Oracle-style naming*
Schema/Link [unqualified]**
Purpose Reference/lookup code table for employee status.
Access pattern Direct SQL (NHibernate-generated)
CRUD operations C/R/U/D
Sequence N/A
Business objects EmployeeStatusCode

WCIS_Employee

Field Value
Database unspecified - lower_snake_case columns*
Schema/Link [unqualified]**
Purpose References a status code table (target entity inferred*).
Access pattern Direct SQL (NHibernate-generated)
CRUD operations C/R/U/D
Sequence N/A (user_name assigned by convention*)
Business objects WcisEmployee

image

Field Value
Database Oracle-style naming*
Schema/Link [unqualified]**
Purpose Version-tracked via UpdateDate; read-only references to DocumentCategory/ImageSystem/DocumentType/DocumentName; has many ImageAffiliations.
Access pattern Direct SQL (NHibernate-generated)
CRUD operations C/R/U/D - populated via SQL-001, not a mapped generator
Sequence N/A (no GeneratedBy clause; ID obtained externally via SQL-001)
Business objects Image

SQL referencing IMAGE

Operations referencing IMAGE

IMAGE_AFFILIATION

Field Value
Database Oracle-style naming*
Schema/Link [unqualified]**
Purpose References image (Image); dual ID-generation path (native generator and SQL-003) not reconciled.**
Access pattern Direct SQL (NHibernate-generated)
CRUD operations C/R/U/D
Sequence IMAGE_AFFILIATION_SEQ (native) - also independently queryable via SQL-003*
Business objects ImageAffiliation

SQL referencing IMAGE_AFFILIATION

Operations referencing IMAGE_AFFILIATION

image_category_code

Field Value
Database Oracle-style naming*
Schema/Link [unqualified]**
Purpose Has many ImageDocumentTypeCode (composite-keyed, Cascade.None()).
Access pattern Direct SQL (NHibernate-generated)
CRUD operations C/R/U/D
Sequence N/A (composite key: image_file_code, code)
Business objects ImageCategoryCode

image_document_name_code

Field Value
Database Oracle-style naming*
Schema/Link [unqualified]**
Purpose Reference/lookup code table for image document names.
Access pattern Direct SQL (NHibernate-generated)
CRUD operations C/R/U/D
Sequence N/A
Business objects ImageDocumentNameCode

image_document_name_gcode

Field Value
Database Oracle-style naming*
Schema/Link [unqualified]**
Purpose Reference/lookup code table for image document names (grouped variant).
Access pattern Direct SQL (NHibernate-generated)
CRUD operations C/R/U/D
Sequence N/A
Business objects ImageDocumentNameGCode

image_document_type_code

Field Value
Database Oracle-style naming*
Schema/Link [unqualified]**
Purpose KeyReference to image_category_code composite key.
Access pattern Direct SQL (NHibernate-generated)
CRUD operations C/R/U/D
Sequence N/A (composite key: KeyReference(Category) + code)
Business objects ImageDocumentTypeCode

image_document_type_gcode

Field Value
Database Oracle-style naming*
Schema/Link [unqualified]**
Purpose Reference/lookup code table for image document types (grouped variant).
Access pattern Direct SQL (NHibernate-generated)
CRUD operations C/R/U/D
Sequence N/A (composite key: code, culture_code, image_category_code, image_file_code)
Business objects ImageDocumentTypeGCode

image_file_code

Field Value
Database Oracle-style naming*
Schema/Link [unqualified]**
Purpose Reference/lookup code table for image document type groups.
Access pattern Direct SQL (NHibernate-generated)
CRUD operations C/R/U/D
Sequence N/A
Business objects ImageDocumentTypeGroupCode

image_external_view_code

Field Value
Database Oracle-style naming*
Schema/Link [unqualified]**
Purpose Reference/lookup code table for image external view types.
Access pattern Direct SQL (NHibernate-generated)
CRUD operations C/R/U/D
Sequence N/A
Business objects ImageExternalViewCode

IMGSYS

Field Value
Database Oracle-style naming*
Schema/Link [unqualified]**
Purpose Has many Image; columns heavily abbreviated (IFNDS, IFNID, NPAGES, DELCD, CRTRID, IDXFL, SLEVEL, SCANDT, UPDTTS, UPDRID, BATID).
Access pattern Direct SQL (NHibernate-generated)
CRUD operations C/R/U/D - populated via SQL-002, not a mapped generator
Sequence N/A (no GeneratedBy clause; ID obtained externally via SQL-002)
Business objects ImageSystem

SQL referencing IMGSYS

Operations referencing IMGSYS

BOL_MENU_VW

Field Value
Database unspecified*
Schema/Link [unqualified]**
Purpose Maps a database view rather than a base table.
Access pattern Direct SQL (NHibernate-generated)
CRUD operations R only (maps a database view, not a base table)*
Sequence N/A (composite key: MENUITEMSEQNUM, FAVORITEFLAG)
Business objects BusinessOnlineMenuItem

pdf_app_error_code

Field Value
Database Oracle-style naming*
Schema/Link [unqualified]**
Purpose Version-tracked via CreateDate; referenced by pdf_tracking.
Access pattern Direct SQL (NHibernate-generated)
CRUD operations C/R/U/D
Sequence N/A
Business objects PDFApplicationErrorCode

pdf_cache

Field Value
Database Oracle-style naming*
Schema/Link [unqualified]**
Purpose PDF cache domain entity.
Access pattern Direct SQL (NHibernate-generated)
CRUD operations C/R/U/D
Sequence N/A (assigned)
Business objects PDFCache

pdf_cache_process

Field Value
Database Oracle-style naming*
Schema/Link [unqualified]**
Purpose References pdf_cache_status_code (Status).
Access pattern Direct SQL (NHibernate-generated)
CRUD operations C/R/U/D
Sequence N/A (pdf_cache_process_id, GeneratedBy.Assigned())
Business objects PDFCacheProcess

pdf_cache_request

Field Value
Database Oracle-style naming*
Schema/Link [unqualified]**
Purpose References pdf_cache_status_code (Status).
Access pattern Direct SQL (NHibernate-generated)
CRUD operations C/R/U/D
Sequence N/A (pdf_cache_process_id, GeneratedBy.Assigned())
Business objects PDFCacheRequest

pdf_cache_status_code

Field Value
Database Oracle-style naming*
Schema/Link [unqualified]**
Purpose Reference/lookup code table referenced by pdf_cache_process, pdf_cache_request, pdf_tracking.
Access pattern Direct SQL (NHibernate-generated)
CRUD operations C/R/U/D
Sequence N/A
Business objects PDFStatusCode

pdf_tracking_code

Field Value
Database Oracle-style naming*
Schema/Link [unqualified]**
Purpose Reference/lookup code table referenced by pdf_tracking.
Access pattern Direct SQL (NHibernate-generated)
CRUD operations C/R/U/D
Sequence N/A
Business objects PDFTrackingCode

pdf_tracking

Field Value
Database Oracle-style naming*
Schema/Link [unqualified]**
Purpose Version-tracked via UpdateNumber; references pdf_app_error_code, pdf_cache_status_code, pdf_tracking_code.
Access pattern Direct SQL (NHibernate-generated)
CRUD operations C/R/U/D
Sequence pdf_tracking_seq (native)
Business objects PDFTracking

XDOCUMENT

Field Value
Database Oracle-style naming*
Schema/Link [unqualified]**
Purpose References XPRINT_CONTROL.
Access pattern Direct SQL (NHibernate-generated)
CRUD operations C/R/U/D
Sequence XDOCUMENT_SEQ (native)
Business objects XDocument

XPRINT_CONTROL

Field Value
Database Oracle-style naming*
Schema/Link [unqualified]**
Purpose Has many XDOCUMENT (inverse, .Not.OptimisticLock()).
Access pattern Direct SQL (NHibernate-generated)
CRUD operations C/R/U/D
Sequence N/A (XPRINT_CONTROL_SEQ_NUM, GeneratedBy.Assigned())
Business objects XPrintControl

USER_PREFERENCE

Field Value
Database Oracle-style naming*
Schema/Link [unqualified]**
Purpose User preferences domain entity.
Access pattern Direct SQL (NHibernate-generated)
CRUD operations C/R/U/D
Sequence USER_PREFERENCE_SEQ (native)
Business objects Preference

EXT_USER

Field Value
Database Oracle-style naming*
Schema/Link [unqualified]**
Purpose Version-tracked via UpdateNumber; references EMAIL_ADDRESS, PERSON, ext_user_status_code (Status); has many ext_user_type (inverse, Cascade.AllDeleteOrphan()).
Access pattern Direct SQL (NHibernate-generated)
CRUD operations C/R/U/D
Sequence EXT_USER_SEQ (native)
Business objects ExternalUser

ext_user_status_code

Field Value
Database Oracle-style naming*
Schema/Link [unqualified]**
Purpose Reference/lookup code table referenced by EXT_USER (Status).
Access pattern Direct SQL (NHibernate-generated)
CRUD operations C/R/U/D
Sequence N/A
Business objects ExternalUserStatusCode

ext_user_type_code

Field Value
Database Oracle-style naming*
Schema/Link [unqualified]**
Purpose Reference/lookup code table referenced by ext_user_type.
Access pattern Direct SQL (NHibernate-generated)
CRUD operations C/R/U/D
Sequence N/A
Business objects ExternalUserTypeCode

ext_user_type

Field Value
Database Oracle-style naming*
Schema/Link [unqualified]**
Purpose References COMPANY, EXT_USER (User), ext_user_type_code (UserTypeCode).
Access pattern Direct SQL (NHibernate-generated)
CRUD operations C/R/U/D
Sequence ext_user_type_seq (native)
Business objects ExternalUserType

Context

Field Value
Database unspecified*
Schema/Link [unqualified]**
Purpose Several unmapped-column, convention-matched properties.
Access pattern Direct SQL (NHibernate-generated)
CRUD operations C/R/U/D
Sequence unspecified generator strategy**
Business objects WebContextItem

Table relationship diagram

The following diagram shows relationships between tables used by this library, derived from the FluentNHibernate mapping associations (References/HasMany/HasManyToMany/KeyReference).

erDiagram
    ADDRESS_CODE ||--o{ ADDRESS : "one-to-many"
    COMPANY ||--o{ ADDRESS : "many-to-many (COMPANY_ADDRESS)"
    COMPANY ||--o{ PHONE : "many-to-many (COMPANY_PHONE)"
    COMPANY ||--o{ PERSON : "many-to-many (COMPANY_PERSON)"
    PERSON ||--o{ ADDRESS : "many-to-many (PERSON_ADDRESS)"
    PERSON ||--o{ EMAIL_ADDRESS : "many-to-many (PERSON_EMAIL)"
    PERSON ||--o{ PHONE : "many-to-many (PERSON_PHONE)"
    EMAIL_CODE ||--o{ EMAIL_ADDRESS : "one-to-many"
    PHONE_CODE ||--o{ PHONE : "one-to-many"
    ADP_EMPLOYEE ||--o{ ADP_EMPLOYEE : "self-referencing (Supervisor)"
    image_category_code ||--o{ image_document_type_code : "one-to-many (composite)"
    IMGSYS ||--o{ image : "one-to-many"
    image ||--o{ IMAGE_AFFILIATION : "one-to-many"
    pdf_cache_status_code ||--o{ pdf_cache_process : "one-to-many"
    pdf_cache_status_code ||--o{ pdf_cache_request : "one-to-many"
    pdf_app_error_code ||--o{ pdf_tracking : "one-to-many"
    pdf_cache_status_code ||--o{ pdf_tracking : "one-to-many"
    pdf_tracking_code ||--o{ pdf_tracking : "one-to-many"
    XPRINT_CONTROL ||--o{ XDOCUMENT : "one-to-many"
    EMAIL_ADDRESS ||--o{ EXT_USER : "one-to-many"
    PERSON ||--o{ EXT_USER : "one-to-many"
    ext_user_status_code ||--o{ EXT_USER : "one-to-many"
    EXT_USER ||--o{ ext_user_type : "one-to-many"
    COMPANY ||--o{ ext_user_type : "one-to-many"
    ext_user_type_code ||--o{ ext_user_type : "one-to-many"

Note: Statements marked with * were inferred from code structure, naming conventions, or contextual evidence where direct confirmation was not available in source artifacts. Statements marked with ** could not be confirmed; treat as unknown until verified.

Sources

  • Mappings/Contacts/AddressCodeMap.cs
  • Mappings/Contacts/AddressMap.cs
  • Mappings/Contacts/CompanyMap.cs
  • Mappings/Contacts/CountryCodeMap.cs
  • Mappings/Contacts/EmailAddressMap.cs
  • Mappings/Contacts/EmailCodeMap.cs
  • Mappings/Contacts/PersonMap.cs
  • Mappings/Contacts/PhoneCodeMap.cs
  • Mappings/Contacts/PhoneMap.cs
  • Mappings/Contacts/StateCodeMap.cs
  • Mappings/Deployment/DeploymentRequestMap.cs
  • Mappings/Deployment/DeploymentResultMap.cs
  • Mappings/Deployment/DeploymentStagedMap.cs
  • Mappings/Employee/EmployeeMap.cs
  • Mappings/Employee/EmployeeStatusMap.cs
  • Mappings/Employee/WCISEmployeeMap.cs
  • Mappings/Imaging/ImageMap.cs
  • Mappings/Imaging/ImageAffiliationMap.cs
  • Mappings/Imaging/ImageCategoryCodeMap.cs
  • Mappings/Imaging/ImageDocumentNameCodeMap.cs
  • Mappings/Imaging/ImageDocumentNameGCodeMap.cs
  • Mappings/Imaging/ImageDocumentTypeCodeMap.cs
  • Mappings/Imaging/ImageDocumentTypeGCodeMap.cs
  • Mappings/Imaging/ImageDocumentTypeGroupCodeMap.cs
  • Mappings/Imaging/ImageExternalViewCodeMap.cs
  • Mappings/Imaging/ImageSystemMap.cs
  • Mappings/Menu/BusinessOnlineMenuItemMap.cs
  • Mappings/PDF/PDFAppErrorCodeMap.cs
  • Mappings/PDF/PDFCacheMap.cs
  • Mappings/PDF/PDFCacheProcessMap.cs
  • Mappings/PDF/PDFCacheRequestMap.cs
  • Mappings/PDF/PDFStatusCodeMap.cs
  • Mappings/PDF/PDFTrackingCodeMap.cs
  • Mappings/PDF/PDFTrackingMap.cs
  • Mappings/Printing/XDocumentMap.cs
  • Mappings/Printing/XPrintControlMap.cs
  • Mappings/Preferences/PreferencesMap.cs
  • Mappings/Users/ExternalUserMap.cs
  • Mappings/Users/ExternalUserStatusCodeMap.cs
  • Mappings/Users/ExternalUserTypeCodeMap.cs
  • Mappings/Users/ExternalUserTypeMap.cs
  • Mappings/WebContext/WebContextItemMap.cs