Audit: v201 Dynamic Limits Database Schema Analysis #167

New Issue

kincses · 2026-03-28T15:26:18+01:00

kincses commented

2026-03-28 15:26:18 +01:00

Mérföldkő: v201 Architecture Refinement
Cél: Audit the current database schema for dynamic limits storage capability for incomplete vehicles (no VIN/Catalog ID).

🔗 Függőségek (Dependencies)

Bemenet (Mikre támaszkodik): PostgreSQL database schema, vehicle.assets table, system.system_parameters table
Kimenet (Mik támaszkodnak rá): Backend API endpoints for vehicle management, frontend UI for vehicle registration, business logic for draft vehicle limits

📝 Elemzés

Assets Table Status Column: The table has a column (VARCHAR(20), default: 'active'). Current values in production: 'active' (5 assets), 'draft' (2 assets). This confirms the system already differentiates between completed and draft vehicles.
Dynamic Limits Storage: The table exists with 12 rows, including a parameter for tier-based vehicle limits. This table is the architecturally correct place to store dynamic limits like and .
Proposed Storage Location: Add two new parameters to :
- (category: 'asset_management', scope: 'global', value: {'limit': 10})
- (category: 'asset_management', scope: 'global', value: {'days': 21})
Architectural Compliance: This approach follows the 'NO HARDCODED LIMITS' rule by storing limits in the database, allowing runtime configuration without code changes.

**Mérföldkő:** v201 Architecture Refinement **Cél:** Audit the current database schema for dynamic limits storage capability for incomplete vehicles (no VIN/Catalog ID). ### 🔗 Függőségek (Dependencies) - **Bemenet (Mikre támaszkodik):** PostgreSQL database schema, vehicle.assets table, system.system_parameters table - **Kimenet (Mik támaszkodnak rá):** Backend API endpoints for vehicle management, frontend UI for vehicle registration, business logic for draft vehicle limits ### 📝 Elemzés 1. **Assets Table Status Column:** The table has a column (VARCHAR(20), default: 'active'). Current values in production: 'active' (5 assets), 'draft' (2 assets). This confirms the system already differentiates between completed and draft vehicles. 2. **Dynamic Limits Storage:** The table exists with 12 rows, including a parameter for tier-based vehicle limits. This table is the architecturally correct place to store dynamic limits like and . 3. **Proposed Storage Location:** Add two new parameters to : - (category: 'asset_management', scope: 'global', value: {'limit': 10}) - (category: 'asset_management', scope: 'global', value: {'days': 21}) 4. **Architectural Compliance:** This approach follows the 'NO HARDCODED LIMITS' rule by storing limits in the database, allowing runtime configuration without code changes.

kincses added the Scope: Database Status: In Progress labels 2026-03-28 15:26:46 +01:00

kincses started working 2026-03-28 15:26:46 +01:00

kincses commented

2026-03-28 15:26:46 +01:00

▶️ Munka megkezdve: 2026-03-28 15:26:45

▶️ **Munka megkezdve:** 2026-03-28 15:26:45

kincses added Status: Done and removed Status: In Progress labels 2026-03-28 15:28:18 +01:00

kincses worked for 1 minute

2026-03-28 15:28:19 +01:00

kincses closed this issue

2026-03-28 15:28:19 +01:00

kincses commented

2026-03-28 15:28:19 +01:00

✅ Munka befejezve: 2026-03-28 15:28:18

Technikai Összefoglaló:
Audit completed: Assets table has status column ('active', 'draft'). System parameters table exists with 12 rows including VEHICLE_LIMIT. Recommended adding VEHICLE_DRAFT_MAX_EXPENSES and VEHICLE_DRAFT_MAX_DAYS parameters. Documentation saved to /opt/docker/docs/v201_dynamic_limits_audit_2026-03-28.md

⏱️ A ráfordított időt a Gitea rögzítette.

✅ **Munka befejezve:** 2026-03-28 15:28:18 **Technikai Összefoglaló:** Audit completed: Assets table has status column ('active', 'draft'). System parameters table exists with 12 rows including VEHICLE_LIMIT. Recommended adding VEHICLE_DRAFT_MAX_EXPENSES and VEHICLE_DRAFT_MAX_DAYS parameters. Documentation saved to /opt/docker/docs/v201_dynamic_limits_audit_2026-03-28.md ⏱️ *A ráfordított időt a Gitea rögzítette.*

Sign in to join this conversation.

1 Participants

Notifications

Total Time Spent: 1 minute

kincses

1 minute

Due Date

No due date set.

Dependencies

No dependencies set.

Reference: kincses/service-finder#167