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)	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

Operations referencing this table

• Generate VB Case statement block
• Generate VB Enum member list

Business rules referencing this table

• BR-001: Enum member identifiers must be unique within a generated block
• BR-002: Generated enum-member identifiers must be legal VB identifiers
• BR-003: Enum-member identifier derivation strips non-alphabetic characters from the description

SQL referencing this table

• SQL-001: Select code table reference rows

Table relationship diagram

No cross-table relationships were identified in this library's SQL.

Related documentation

• Index
• Overview
• Architecture
• Dependencies
• Operations and processes
• Business rules
• SQL catalog
• API reference

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

Sources

• SAIF.Framework.CodeGen\CodeTableMap.vb