| Parameter | Current Value | Specification & Rule |
|---|---|---|
| Service Architecture | REST API Express 5 + TypeScript | Pure decoupled API running via tsx |
| Primary Storage Engine | PostgreSQL (node-postgres pg) | Rule 2: PostgreSQL via DATABASE_URL is sole source of truth |
| DATABASE_URL Configured | Checking... | Single authoritative variable: DATABASE_URL |
| Persistence Guarantee | Non-Destructive DDL/DML | Rule 4: Zero re-filling across redeployments |
| Internal Intelligence | SyncZ Autonomous AI Platform | Rule 1: Internal proprietary AI only (no external AI) |
| CORS Header Policy | Enabled (All Origins + Credentials) | Supports cross-origin frontend client apps |
| Table Name | Entity Type | Persistence Mode | Live Row Count | Health State |
|---|---|---|---|---|
| users | Super Admins, Owners, Artists, Clients | PostgreSQL (users table) | 0 | ACTIVE |
| tenants | Multi-Tenant Workspaces | PostgreSQL (tenants table) | 0 | ACTIVE |
| settings | Global Configuration & Modules | PostgreSQL (settings table) | 0 | ACTIVE |
| portfolios | Artist & Studio Portfolios | PostgreSQL (portfolios table) | 0 | ACTIVE |
| orders | Service Orders & Pipelines | PostgreSQL (orders table) | 0 | ACTIVE |
| bookings | Calendar Sessions & Slots | PostgreSQL (bookings table) | 0 | ACTIVE |
| oauth_clients | SSO & API Client Applications | PostgreSQL (oauth_clients table) | 0 | ACTIVE |
| smtp_settings | SMTP Dispatch Config & Credentials | PostgreSQL (smtp_settings table) | 0 | ACTIVE |
| Method | Endpoint Route | Description | Action |
|---|---|---|---|
| GET | /health | Liveness and container health check probe | Test JSON → |
| GET | /api/health/db | PostgreSQL database connection diagnostics and row stats | Test JSON → |
| GET | /api/health/smtp | SMTP email transport verification | Test JSON → |
| GET | /api/config/domains | Domain resolution for multi-tenant routing | Test JSON → |
| GET | /api/config/public | SyncZ Base credentials and tracking configuration | Test JSON → |
| POST | /api/postgres/query | Direct PostgreSQL query executor gateway | POST only |
| POST | /api/auth/login | Email and password user authentication | POST only |
| POST | /api/functions/tenant/check-subdomain | Tenant subdomain availability validator | POST only |
| Value / Setting | Canonical Variable | Status in Environment |
|---|---|---|
| Database URL | DATABASE_URL | Reading... |
| Server Port | PORT | Configured / 3000 |
| Node Environment | NODE_ENV | Reading... |
| Application Domain | APP_DOMAIN | Derived / Configured |
| Super Admin Email | SUPERADMIN_EMAIL | Single variable active |
| Super Admin Password | SUPERADMIN_PASSWORD | ●●●●●●●● (Hashed in DB) |
| Workspace Owner Email | OWNER_EMAIL | Single variable active |
| Workspace Owner Password | OWNER_PASSWORD | ●●●●●●●● (Hashed in DB) |
| SMTP Host | SMTP_HOST | Checking... |
| SMTP Port | SMTP_PORT | 587 |
| SMTP User | SMTP_USER | Checking... |
| SMTP Password / Pass | SMTP_PASS | ●●●●●●●● (Managed in DB) |
| SMTP Sender Email | SMTP_FROM_EMAIL | Derived / Configured |