Skip to content

Schema Change Log

A daily record of how the CTC schema differs from the previous day, with the T3 Code sessions that were running that day shown as candidates to check. A session next to a change is not proof it made the change — it only means it was open. Confirm against database/migrations and the commit history before drawing a conclusion.

Read this when you find a table or column you did not expect.

Method
Captured 2026-10-21T00:41:13+00:00
Compared against the previous capture
Source information_schema.columns for the business database
Sessions T3 Code threads whose last activity falls on the recorded day
Migration files 147 files under database/migrations

Baseline is stored outside the wiki so a manual edit here cannot distort the comparison.

Changes on this run

No schema change since the previous capture.

Migration files present

The schema is created by these files. If a change here matches one of them, that file is the evidence of intent; if it does not, the change came from somewhere else.

File
2026-06-30_slow_menu_performance_indexes.sql
2026-08-17_new_system_session_cleanup.sql
2026-08-17_new_system_sessions.sql
2026-08-19_ns1_009_uuid_dependency_columns.sql
2026-08-20_ns1_009_company_booking_uuid_finalize.sql
2026-08-20_ns1_009_company_booking_uuid_stage.sql
2026-08-21_ns1_020_booking_uuid_reconciliation.php
2026-08-23_ns2_mk_uuid_writer_guards.sql
2026-08-23_ns2_mk_uuid_writer_guards_rollback.sql
2026-08-25_transload_bol_email_snapshot.sql
2026-08-26_ns2_inbound_receipt_authority.sql
2026-08-26_ns2_inbound_receipt_authority_rollback.sql
2026-08-26_workspace_identity.sql
2026-08-27_loading_planner_domestic_loading_type.sql
2026-08-28_ns3_transload_uuid_unique.sql
2026-08-28_workspace_system_realm.sql
2026-08-29_ns3_billing_master_uuid_and_rate_dates.sql
2026-08-29_ns3_billing_master_uuid_and_rate_dates_rollback.sql
2026-09-02_logisticsworkspace_full_access_baseline.sql
2026-09-02_transload_execution_dependency_revision.sql
2026-09-06_billing_draft_persistence.sql
2026-09-06_billing_draft_persistence_rollback.sql
2026-09-06_billing_setup_history.sql
2026-09-06_billing_setup_history_rollback.sql
2026-09-06_billing_setup_tenant_identity.sql
2026-09-06_billing_setup_tenant_identity_rollback.sql
2026-09-08_trade_billing_reconciliation.sql
2026-09-12_ns3_112_delivery_movement_purpose.sql
2026-09-12_ns3_112_delivery_movement_purpose_rollback.sql
2026-09-12_ns5-009_support_access.sql
2026-09-14_booking_document_companies.sql
2026-09-14_document_reads_tenant_indexes.sql
2026-09-14_document_reads_tenant_indexes_rollback.sql
2026-09-14_ns1_009_uuid_columns.php
2026-09-14_ns1_009_uuid_data.php
2026-09-14_wiki_metadata_nullable.sql
2026-09-15_client2_menu_projection.sql
2026-09-15_ns1_009_audit_tables_backfill.sql
2026-09-15_ns1_009_booking_backfill.sql
2026-09-15_ns1_009_booking_company_constraints.sql
2026-09-15_ns1_009_booking_company_tenant.sql
2026-09-15_ns1_009_bulk_uuid_constraints.sql
2026-09-15_ns1_009_cpo_pk_swap.sql
2026-09-15_ns1_009_cpo_relation_drop.sql
2026-09-15_ns1_009_customer_po_constraints.sql
2026-09-15_ns1_009_customer_po_header_uuid.sql
2026-09-15_ns1_009_customer_po_item_uuid.sql
2026-09-15_ns1_009_invalid_rekey.sql
2026-09-15_ns1_009_null_ops_backfill.sql
2026-09-15_ns1_009_null_small_backfill.sql
2026-09-15_ns1_009_small_uuid_constraints.sql
2026-09-15_ns1_009_tenant_client_constraints.sql
2026-09-16_ns1_009_01_repair_log_company_uuid.sql
2026-09-16_ns1_009_02_bkco_pk_swap.sql
2026-09-16_ns1_009_03_bkco_ar_drop.sql
2026-09-16_ns1_009_04_bkco_repair_drop.sql
2026-09-16_ns1_009_05_eqp_booking_backfill.sql
2026-09-16_remove_transload_execution_dependency_revision.sql
2026-09-16_remove_transload_execution_dependency_revision_rollback.sql
2026-09-17_ns1_009_dotr_booking_uuid.sql
2026-09-17_ns1_009_dotr_fk.sql
2026-09-17_ns1_009_load_booking_uuid.sql
2026-09-17_ns1_009_trload_drop.sql
2026-09-18_ns1_009_allocation_relation_backfill.sql
2026-09-18_ns1_009_allocation_relation_drop.sql
2026-09-18_ns1_009_billing_preset_uuid_rekey.sql
2026-09-18_ns1_009_booking_relation_constraints.sql
2026-09-18_ns1_009_booking_sales_order_backfill.sql
2026-09-18_ns1_009_booking_sales_order_orphan.sql
2026-09-18_ns1_009_booking_shipper_reconcile.sql
2026-09-18_ns1_009_co_uuid.sql
2026-09-18_ns1_009_cobatch_constraints.sql
2026-09-18_ns1_009_codel_constraints.sql
2026-09-18_ns1_009_coload_drop.sql
2026-09-18_ns1_009_cotxn_constraints.sql
2026-09-18_ns1_009_do_drop.sql
2026-09-18_ns1_009_operational_relation_backfill.sql
2026-09-18_ns1_009_orphan_relation_sentinel.sql
2026-09-18_ns1_009_ratepft_uuid.sql
2026-09-18_ns1_009_ta_company_drop.sql
2026-09-18_ns1_009_uuid_defaults.sql
2026-09-18_ns1_009_voice_segment_drop.sql
2026-09-18_ns1_009_warehouse_location_uuid_repair.sql
2026-09-20_ns1_009_booking_inspector_uuid.sql
2026-09-20_ns1_009_delivery_equipment_load_uuid.sql
2026-09-21_ns1_009_equipment_last_location_company_repair.sql
2026-09-21_ns1_009_list_relations.sql
2026-09-21_ns1_009_list_relations_reconcile.sql
2026-09-22_ns1_009_drop_domestic_pickup_pool.sql
2026-09-22_ns1_009_drop_super_admin_log.sql
2026-09-22_ns1_009_drop_warehouse_grid_occupancy.sql
2026-09-22_ns1_009_drop_warehouse_grid_occupancy_columns.sql
2026-09-22_ns1_009_p1_daily_dip_draft.sql
2026-09-22_ns1_009_p1_invoice_number_reservation.sql
2026-09-22_ns1_009_p1_invoice_sequence.sql
2026-09-22_ns1_009_p1_package_tier.sql
2026-09-23_ns1_009_p1_ar_billing_scope_edit_revision.sql
2026-09-23_ns1_009_p1_terminal_appointment.sql
2026-09-23_ns1_009_p1_terminal_appointment_history.sql
2026-09-23_ns1_009_transition_audit_entity_uuid.sql
2026-09-25_ns1_009_billing_draft_audit_uuid.sql
2026-09-26_ns1_009_t065_relation_repair.sql
2026-09-26_ns1_009_t077_relation_repair.sql
2026-09-26_ns1_009_t082_relation_repair.sql
2026-09-26_ns1_009_t084_relation_repair.sql
2026-09-26_ns1_009_t088_relation_repair.sql
2026-09-26_ns1_009_t096_relation_repair.sql
2026-09-26_ns1_009_t105_relation_repair.sql
2026-09-27_ns1_009_t086_relation_repair.sql
2026-09-28_ns1_009_control_tower_deployment_uuid.sql
2026-09-28_ns1_009_row_uuid_schema.php
2026-09-28_ns1_009_tenant_relation_schema.php
2026-09-29_ns1_009_t005_warehouse_grid_location_uuid.sql
2026-10-01_ns1_009_accessorial_rate_forward_schema.php
2026-10-01_ns1_009_t005_warehouse_grid_tenant_backfill.php
2026-10-01_ns1_009_t040_scale_ticket_tenant_backfill.php
2026-10-01_ns1_009_t042_billing_preset_tenant_backfill.php
2026-10-01_ns1_009_t048_billing_rate_tenant_backfill.php
2026-10-01_ns1_009_tenant_shadow_column_precondition.php
2026-10-02_ns1_009_active_user_role_backfill.sql
2026-10-02_ns1_009_platform_super_admin_capability_seed.sql
2026-10-02_ns1_009_user_role_tenant_converge.sql
2026-10-02_ns1_009_user_tenant_backfill.sql
2026-10-03_ns1_009_list_relation_backfill.php
2026-10-03_ns1_009_platform_authority_cutover.php
2026-10-03_ns1_009_relation_shadow_backfill.php
2026-10-03_ns1_009_role_csv_downgrade.php
2026-10-03_ns1_009_tenant_null_backfill.php
2026-10-03_ns1_009_warehouse_uuid_rekey.php
2026-10-04_ns1_009_t050_default_company_repair.sql
2026-10-04_ns1_009_t080_warehouse_tenant_repair.php
2026-10-04_ns1_009_t095_packing_projection_columns.php
2026-10-09_tms_trucking_pickup_company_forward.sql
2026-10-14_ar_invoice_sequence_start_100001.php
2026-10-14_ns1_009_t087_identity_backfill.php
2026-10-14_ns1_009_t093_identity_backfill.php
2026-10-14_ns1_009_t094_identity_backfill.php
2026-10-14_ns1_009_t096_identity_backfill.php
2026-10-14_ns1_009_t097_identity_backfill.php
2026-10-15_ns1_009_t098_identity_backfill.php
2026-10-15_ns1_009_t101_commodity_shadow_repair.php
2026-10-15_ns1_009_t101_identity_backfill.php
2026-10-15_ns1_009_t102_identity_backfill.php
2026-10-15_ns1_009_t103_identity_backfill.php
2026-10-16_ns1_009_t087_transaction_type_catalog.php
2026-10-16_ns1_009_t100_identity_backfill.php
2026-10-17_file_storage_contract.php

How to use this page

  1. Find the object you did not expect in Changes on this run.
  2. Check whether a migration file explains it. If one does, that is the intended change.
  3. If no migration explains it, look at the candidate sessions and check what they ran.
  4. If still unexplained, it is manual work — the sessions are only a starting point.