Database Documentation

Comprehensive documentation for Axiom Genesis database architecture, covering schema design, conventions, and best practices.

Overview

Axiom Genesis uses a two-database architecture:

Database	Purpose	Key Tables
RADICS_CFG	Configuration & metadata	Tenants, users, roles, object registries, page/workflow/dataview configs
RADICS_DATA	Business transactions	Application-specific data (projects, tasks, files, etc.)

Supported Databases

• MSSQL Server 2022+ (Primary)
• PostgreSQL 15+ (Supported)

Documentation Sections

Document	Audience	Content
Technical Dictionary	Developers, DBAs	Column definitions, datatypes, indexes, JSON schemas
Business Dictionary	Business analysts, Product	Table purposes, field meanings, enums, relationships
Copilot Instructions	AI assistants	Schema conventions for code generation
Migration Guide	DevOps, DBAs	Database migration procedures
Performance Guide	Developers, DBAs	Query optimization, indexing strategies
Data Model Conventions	Developers	Naming conventions, column prefixes
Config Table Catalog	Developers	Configuration table reference

Key Conventions

Column Naming

All columns use a 3-letter prefix matching the table:

Table	Prefix	Example
app_users	usr_	usr_id, usr_email_id, usr_tenant_id
app_tenants	tnt_	tnt_id, tnt_tenant_code, tnt_status
app_navigation_configs	nvc_	nvc_id, nvc_code, nvc_config

Required Columns

Every table includes:

Column Pattern	Type	Purpose
{prefix}_id	BIGINT IDENTITY	Primary key
{prefix}_tenant_id	BIGINT	Multi-tenant isolation
{prefix}_is_deleted	TINYINT	Soft delete (0/1)
{prefix}_audit_data	JSON	Audit trail (created_by, updated_at, etc.)

Status Values

Standard status codes across all tables:

Value	Meaning
1	Active
0	Inactive
-1	Archived

Table Categories

1. Tenant & User Management (5 tables)

• app_tenants - Tenant/organization configuration
• app_users - User accounts
• app_roles - Role definitions
• app_subscriptions - Subscription plans
• app_connections - External database connections

2. Object & Configuration (9 tables)

• app_object_registries - Entity metadata
• app_object_profiles - Field-level security policies
• app_value_set - Dropdown/enum values
• app_applications - Application definitions
• app_templates - Reusable templates
• app_config_versions - Configuration versioning
• app_patch_tracker - Database patch tracking

3. UI/UX Configuration (5 tables)

• app_page_configs - Page/form layouts
• app_dataview_configs - Data grid configurations
• app_navigation_configs - Menu structure
• app_dashboard_configs - Dashboard layouts
• app_scrumboard_configs - Kanban board configs

4. Workflow Engine (11 tables)

• app_workflow_configs - Workflow definitions
• app_workflow_schedulers - Scheduled workflows
• wft_templates - Workflow templates
• wft_instances - Running instances
• wft_nodes - Node definitions
• wft_steps - Execution steps
• wft_node_states - Node state tracking
• wft_approvals - Approval requests
• wft_logs - Execution logs
• wft_ai_usage - AI token usage
• wft_agent_memory - AI agent memory

5. Collaboration (6 tables)

• apt_projects - Project definitions
• apt_tasks - Task management
• apt_scb_cards - Scrumboard cards
• apt_messages - Messaging
• apt_notes - Notes
• apt_files - File storage
• apt_events - Calendar events

Quick Links

• Technical Dictionary - Full schema reference
• Business Dictionary - Field meanings and enums
• Copilot Instructions - AI coding guidelines