---
title: SAIF.Framework.CodeGen database tables
summary: Database tables used by this library with relationships and usage context.
status: draft
owner: <owner>
last_reviewed: 2026-07-23
library: SAIF.Framework.CodeGen
reference_type: package
---

# SAIF.Framework.CodeGen database tables

This page catalogs database tables accessed by `SAIF.Framework.CodeGen`. The library performs exactly one ad hoc SQL operation against a caller-supplied, runtime-resolved table — there is no fixed table literal anywhere in the source.

## Table catalog

| Table | Database | Schema/Link | CRUD | Purpose | Primary business object |
| --- | --- | --- | --- | --- | --- |
| [CODE_TABLE (caller-supplied)](#code_table-caller-supplied) | Oracle | `[unqualified]**` | R | Source of `code`/`code_descr` reference rows used to generate VB `Case` statements or `Enum` members | N/A — not a BOF business object |

## CODE_TABLE (caller-supplied)

| Field | Value |
| --- | --- |
| **Database** | Oracle |
| **Schema/Link** | `[unqualified]**` — no `OWNER.TABLE_NAME` qualifier appears in the SQL text, and no `Web.config`/`App.config` exists in this project to resolve the connecting Oracle user |
| **Purpose** | Provides the `code`/`code_descr` reference-data rows that `CodeTableMap` transforms into generated VB `Case` statement blocks or `Enum` member lists |
| **Access pattern** | Direct SQL (ad hoc, application/tooling-layer) |
| **CRUD operations** | Read |
| **Key columns used** | `code`, `code_descr` |
| **Sequence** | N/A |
| **Related tables** | None — single-table query, no `JOIN` clause |
| **Business objects** | N/A — `CodeTableMap` is not a BOF business object |

<!-- Table name is a caller-supplied runtime parameter (String.Format substitution); no fixed literal table name exists anywhere in this library's source. -->

### Operations referencing this table
- [Generate VB Case statement block](operations-processes.md#generate-vb-case-statement-block)
- [Generate VB Enum member list](operations-processes.md#generate-vb-enum-member-list)

### Business rules referencing this table
- [BR-001: Enum member identifiers must be unique within a generated block](business-rules.md#br-001-enum-member-identifiers-must-be-unique-within-a-generated-block)
- [BR-002: Generated enum-member identifiers must be legal VB identifiers](business-rules.md#br-002-generated-enum-member-identifiers-must-be-legal-vb-identifiers)
- [BR-003: Enum-member identifier derivation strips non-alphabetic characters from the description](business-rules.md#br-003-enum-member-identifier-derivation-strips-non-alphabetic-characters-from-the-description)

### SQL referencing this table
- [SQL-001: Select code table reference rows](sql/SQL-001-select-code-table.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)

> **Note:** Statements marked with `**` could not be confirmed; treat as unknown until verified.

## Sources
- SAIF.Framework.CodeGen\CodeTableMap.vb