Proposed rename of dori_dash to the standard convention (drop d_ prefix, snake_case, FK x_id, schema d_inference_detectobject→inference) · 2026-09-26 00:12 UTC · Current data model → · 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.d_user cannot become user — user is a Postgres reserved keyword and would need quoting everywhere. It is renamed to app_user to stay unquoted and keep the singular convention.dori_db source. Renaming them breaks live inference until the MLC image is updated in lockstep — deploy that part only after MLC coordination.| Current | Proposed | Note | |
|---|---|---|---|
dori | → | unchanged | already standard |
| d_inference_detectobject | → | inference | MLC contract |
public | → | unchanged | already standard |
dori → dori| Current table | Proposed table | Column renames | |
|---|---|---|---|
dori.d_client | → | dori.client | no column renames |
dori.d_client_user | → | dori.client_user | d_client_id→client_id d_user_id→user_id |
dori.d_cloud_store_config | → | dori.cloud_store_config | d_company_id→company_id |
dori.d_company | → | dori.company | no column renames |
dori.d_company_config | → | dori.company_config | d_company_id→company_id |
dori.d_device | → | dori.device | d_location_id→location_id d_mlc_id→mlc_id d_service_bundle_id→service_bundle_id d_vms_id→vms_id |
dori.d_dynamic_kit | → | dori.dynamic_kit | d_company_id→company_id |
dori.d_dynamic_kit_part | → | dori.dynamic_kit_part | d_dynamic_kit_id→dynamic_kit_id d_part_id→part_id |
dori.d_event_note | → | dori.event_note | d_inference_event_id→inference_event_id |
dori.d_event_type | → | dori.event_type | d_service_bundle_id→service_bundle_id |
dori.d_image | → | dori.image | no column renames |
dori.d_job | → | dori.job | d_device_id→device_id d_user_id→user_id d_project_id→project_id d_model_id→model_id d_mlc_id→mlc_id d_dataset_id→dataset_id d_service_bundle_id→service_bundle_id |
dori.d_kit | → | dori.kit | d_company_id→company_id |
dori.d_kit_image | → | dori.kit_image | d_kit_id→kit_id d_image_id→image_id |
dori.d_kit_part | → | dori.kit_part | d_kit_id→kit_id d_part_id→part_id |
dori.d_location | → | dori.location | d_company_id→company_id |
dori.d_message_log | → | dori.message_log | d_subscriber_id→subscriber_id d_inference_event_id→inference_event_id d_company_id→company_id d_location_id→location_id d_device_id→device_id |
dori.d_mlc | → | dori.mlc | d_service_bundle_id→service_bundle_id |
dori.d_mlc_config | → | dori.mlc_config | d_mlc_id→mlc_id |
dori.d_mlc_config_company | → | dori.mlc_config_company | d_mlc_config_id→mlc_config_id d_company_id→company_id |
dori.d_pallet_result | → | dori.pallet_result | d_company_id→company_id d_location_id→location_id d_device_id→device_id |
dori.d_part | → | dori.part | d_company_id→company_id |
dori.d_part_image | → | dori.part_image | d_part_id→part_id d_image_id→image_id |
dori.d_prediction_comment | → | dori.prediction_comment | no column renames |
dori.d_service_bundle | → | dori.service_bundle | no column renames |
dori.d_service_bundle_company | → | dori.service_bundle_company | d_company_id→company_id d_service_bundle_id→service_bundle_id |
dori.d_subscriber | → | dori.subscriber | d_company_id→company_id |
dori.d_subscriber_event | → | dori.subscriber_event | d_subscriber_id→subscriber_id d_company_id→company_id d_location_id→location_id d_device_id→device_id |
dori.d_sys_config | → | dori.sys_config | no column renames |
dori.d_user reserved→app_user | → | dori.app_user | d_company_id→company_id d_location_id→location_id |
dori.d_user_log | → | dori.user_log | d_user_id→user_id |
dori.d_vw_events | → | dori.vw_events | d_device_id→device_id d_service_bundle_id→service_bundle_id d_mlc_id→mlc_id d_company_id→company_id |
d_inference_detectobject → inference| Current table | Proposed table | Column renames | |
|---|---|---|---|
d_inference_detectobject.d_avi_file_tracker | → | inference.avi_file_tracker | no column renames |
d_inference_detectobject.d_deployment | → | inference.deployment | no column renames |
d_inference_detectobject.d_inference_alerts | → | inference.inference_alerts | no column renames |
d_inference_detectobject.d_inference_detectobject_predicted | → | inference.inference_detectobject_predicted | d_request_model_mapping_id→request_model_mapping_id d_model_id→model_id |
d_inference_detectobject.d_inference_detectobject_request | → | inference.inference_detectobject_request | no column renames |
d_inference_detectobject.d_inference_detectobject_request_status | → | inference.inference_detectobject_request_status | no column renames |
d_inference_detectobject.d_inference_distance_violations_info | → | inference.inference_distance_violations_info | no column renames |
d_inference_detectobject.d_inference_event | → | inference.inference_event | no column renames |
d_inference_detectobject.d_inference_event_image | → | inference.inference_event_image | no column renames |
d_inference_detectobject.d_inference_runtimestat | → | inference.inference_runtimestat | no column renames |
d_inference_detectobject.d_inference_unattended_objects | → | inference.inference_unattended_objects | no column renames |
public → public| Current table | Proposed table | Column renames | |
|---|---|---|---|
public.alembic_version | → | public.— | no column renames |