--- title: SAIF.Application.LogView database tables summary: Database tables used by this library with relationships and usage context. status: draft owner: SAIF Doc Gen last_reviewed: 2026-07-24 library: SAIF.Application.LogView reference_type: package --- # SAIF.Application.LogView database tables This page catalogs database tables accessed by this library. ## Table catalog | Table | Database | Schema/Link | CRUD | Purpose | Primary business object | | --- | --- | --- | --- | --- | --- | | [App_Error](#app_error) | SQL Server | `NetFramework.dbo` (insert), `[unqualified]` (read/update) | C/R/U | Application error log storage | `clsAppError` | | [App_Info](#app_info) | SQL Server | `NetFramework.dbo` (insert), `[unqualified]` (read) | C/R | Application info/audit log storage | `clsAppInfo` | --- ## App_Error | Field | Value | | --- | --- | | **Database** | SQL Server | | **Schema/Link** | `NetFramework.dbo` for inserts; `[unqualified]` for collection reads and update SQL | | **Purpose** | Stores application error log entries, search text, user context, and deleted-flag state. | | **Access pattern** | Direct SQL via `IBusinessCriteria` | | **CRUD operations** | Create, Read, Update | | **Key columns used** | `App_Error_Seq_Num`, `App_Name`, `Deleted_Flag`, `Environment`, `Error_Date`, `Error_Info`, `Error_Source`, `Machine_Name`, `Page_Name`, `State_Info`, `User_Name` | | **Sequence** | Identity value retrieved through `Select @@IDENTITY` | | **Related tables** | None | | **Business objects** | `clsAppError`, `clsAppErrorCollection` | ### Operations referencing this table - [Create a new application error log entry from struct](operations/error-logging.md) - [Create a new application error log entry from discrete parameters](operations/error-logging.md) - [Retrieve a single error log entry](operations/error-retrieval.md) - [Update an error deleted flag](operations/error-deleted-flag-update.md) - [Search application error logs](operations/error-search.md) - [Normalize free-text search terms](operations/error-search.md) ### Business rules referencing this table - [BR-001: Search results are capped at 300 rows](business-rules.md#br-001-search-results-are-capped-at-300-rows) - [BR-002: All sentinel suppresses selected filters](business-rules.md#br-002-all-sentinel-suppresses-selected-filters) - [BR-003: Semicolon-delimited filters expand to SQL IN lists](business-rules.md#br-003-semicolon-delimited-filters-expand-to-sql-in-lists) - [BR-004: Search text is normalized for full-text queries](business-rules.md#br-004-search-text-is-normalized-for-full-text-queries) - [BR-005: Single-object retrieval requires exactly one row](business-rules.md#br-005-single-object-retrieval-requires-exactly-one-row) - [BR-006: Inserts must affect exactly one row](business-rules.md#br-006-inserts-must-affect-exactly-one-row) ### SQL referencing this table - [SQL-001: clsAppError identity retrieval](sql/SQL-001-saif-application-logview.md) - [SQL-003: clsAppError.InsertSQL](sql/SQL-003-saif-application-logview.md) - [SQL-005: clsAppErrorCollection.RetrieveSQL](sql/SQL-005-saif-application-logview.md) - [SQL-006: clsAppErrorCollection.RetrieveSQLCount](sql/SQL-006-saif-application-logview.md) - [SQL-009: clsAppError.UpdateSQL](sql/SQL-009-saif-application-logview.md) --- ## App_Info | Field | Value | | --- | --- | | **Database** | SQL Server | | **Schema/Link** | `NetFramework.dbo` for inserts; `[unqualified]` for collection reads | | **Purpose** | Stores application info/audit messages, supplemental data text, and purge-date retention metadata. | | **Access pattern** | Direct SQL via `IBusinessCriteria` | | **CRUD operations** | Create, Read | | **Key columns used** | `App_Info_Seq_Num`, `App_Name`, `Create_Date`, `Data_Text`, `Environment`, `Machine_Name`, `Message_Text`, `Page_Name`, `Purge_Date`, `User_Name` | | **Sequence** | Identity value retrieved through `Select @@IDENTITY` | | **Related tables** | None | | **Business objects** | `clsAppInfo`, `clsAppInfoCollection` | ### Operations referencing this table - [Create a new application info log entry from struct](operations/info-logging.md) - [Create a new application info log entry from discrete parameters](operations/info-logging.md) - [Retrieve or create a single application info object](operations/info-retrieval.md) - [Search application info logs](operations/info-search.md) - [Normalize free-text search terms](operations/info-search.md) ### Business rules referencing this table - [BR-001: Search results are capped at 300 rows](business-rules.md#br-001-search-results-are-capped-at-300-rows) - [BR-002: All sentinel suppresses selected filters](business-rules.md#br-002-all-sentinel-suppresses-selected-filters) - [BR-003: Semicolon-delimited filters expand to SQL IN lists](business-rules.md#br-003-semicolon-delimited-filters-expand-to-sql-in-lists) - [BR-004: Search text is normalized for full-text queries](business-rules.md#br-004-search-text-is-normalized-for-full-text-queries) - [BR-005: Single-object retrieval requires exactly one row](business-rules.md#br-005-single-object-retrieval-requires-exactly-one-row) - [BR-006: Inserts must affect exactly one row](business-rules.md#br-006-inserts-must-affect-exactly-one-row) - [BR-007: Audit rows receive a 30-day purge date](business-rules.md#br-007-audit-rows-receive-a-30-day-purge-date) - [BR-008: Audit searches exclude EPAY and DirectDeposit](business-rules.md#br-008-audit-searches-exclude-epay-and-directdeposit) ### SQL referencing this table - [SQL-002: clsAppInfo identity retrieval](sql/SQL-002-saif-application-logview.md) - [SQL-004: clsAppInfo.InsertSQL](sql/SQL-004-saif-application-logview.md) - [SQL-007: clsAppInfoCollection.RetrieveSQL](sql/SQL-007-saif-application-logview.md) - [SQL-008: clsAppInfoCollection.RetrieveSQLCount](sql/SQL-008-saif-application-logview.md) --- ## Table relationship diagram No cross-table relationships were identified in this library's SQL. ## Related documentation - [Index](index.md) - [Overview](overview.md) - [Architecture](architecture.md) - [Dependencies](dependencies.md) - [Operations and processes](operations-processes.md) - [Business rules](business-rules.md) - [SQL catalog](sql/index.md) - [API reference](api/index.md) ## Sources - `Application\SAIF.Application.LogView\clsAppError.vb` - `Application\SAIF.Application.LogView\clsAppErrorCollection.vb` - `Application\SAIF.Application.LogView\clsAppInfo.vb` - `Application\SAIF.Application.LogView\clsAppInfoCollection.vb`