Everything that changes when d_* becomes standard · 2026-09-26 00:12 UTC · Data model diff → · Docs index
main and live on mapp-instance after a clean fresh install (2026-09-30): alembic head 016, schema fully standardized (0 d_* tables in dori). This page is the historical record of the change.dori_db". A rename done only in this repo diverges from dori_db; to stay consistent the rename should originate there and be re-ported here.smartvision_va (fe-icd-react). Only Playwright tests live here — any API field-name change (columns are serialized to JSON by attribute name) must be mirrored in smartvision_va too.d_inference_detectobject.*. Renaming that schema breaks live inference until the MLC is updated.d_* identifier| Area | Files | Hits | |
|---|---|---|---|
alembic | 18 | 899 | |
services/config_app | 19 | 375 | |
common/dori_model | 3 | 164 | |
services/job_app | 5 | 120 | |
unit_tests | 2 | 100 | |
services/warehouse_app | 6 | 60 | |
common/dori_utils | 4 | 32 | |
services/analytics_app | 2 | 26 | |
services/cim | 5 | 21 | |
services/dmf | 1 | 21 | |
fe_tests | 3 | 15 | |
system_test | 3 | 13 | |
scripts | 1 | 13 | |
services/dim | 2 | 4 | |
services/monitor | 2 | 3 | |
services/edge_simulator | 1 | 2 | |
| Total | 77 | 1,868 |
| File | Hits |
|---|---|
| alembic/sql/create_dori_schema.sql | 181 |
| alembic/versions/013_drop_more_unused_tables.py | 149 |
| common/dori_model/dModel.py | 146 |
| alembic/sql/populate_data.sql | 116 |
| alembic/versions/011_drop_unused_tables.py | 105 |
| services/job_app/src/web/jobs.py | 82 |
| alembic/versions/007_drop_region_hierarchy.py | 67 |
| unit_tests/test_job_app.py | 61 |
| services/config_app/src/web/infra.py | 56 |
| alembic/sql/init_d_inference_detectobject.sql | 54 |
| alembic/versions/003_merge_d_monitor.py | 47 |
| services/config_app/src/model/pModel.py | 45 |
| services/config_app/src/web/compat.py | 43 |
| unit_tests/test_config_app.py | 39 |
| alembic/versions/005_mlc_config_junction.py | 35 |
| alembic/versions/010_rename_auth_aws_to_cloud_store.py | 32 |
| services/config_app/src/web/ops.py | 30 |
| services/config_app/src/service/mlc_config_service.py | 30 |
| services/job_app/src/service/mlc_dispatch.py | 29 |
| common/dori_utils/seed.py | 27 |
| services/config_app/src/service/company_service.py | 26 |
| services/config_app/src/service/mlc_service.py | 25 |
| alembic/versions/002_warehouse_scan_event.py | 23 |
| services/config_app/src/service/users.py | 22 |
| services/config_app/src/service/bundle_service.py | 22 |
| # | Step | Where |
|---|---|---|
| 1 | Rename tables/columns/schema (data-preserving ALTER … RENAME) | new alembic migration (model on 010_rename_auth_aws_to_cloud_store.py) |
| 2 | Update canonical DDL + seed | alembic/sql/create_dori_schema.sql, init_d_inference_detectobject.sql, populate_data.sql |
| 3 | Rename ORM __tablename__, column attributes, FK string targets, SCHEMA | common/dori_model/dModel.py, dIdoModel.py |
| 4 | Update raw SQL + ORM attribute access in services | services/* (config_app, job_app hottest) |
| 5 | Update tests | unit_tests/, fe_tests/, system_test/ |
| 6 | Regenerate this data model doc | /docs/database-data-model.html |
| 7 | Mirror API field renames in the FE repo | smartvision_va (external) |
| 8 | Coordinate MLC image update, then deploy inference schema rename | MLC / dori_db (external) |