Skip to content
Tagged articles

composite key

3 articles · Page 1 of 1
BanTech Think Tank
BanTech Think Tank
Nov 5, 2026 · Backend Development

Real-Time Non-Tax Fund Tracking via Composite Keys & 3D Cross-Reconciliation

China Postal Savings Bank details a composite-key-driven graph system with a six-state machine for end-to-end non-tax revenue fund tracking, enabling real-time monitoring, automated unmatched-fund matching via weighted scoring and LLM assistance, and three-dimensional cross-reconciliation across transaction, fund, and account dimensions.

banking technologycomposite keycross-reconciliation
0 likes · 17 min read
Real-Time Non-Tax Fund Tracking via Composite Keys & 3D Cross-Reconciliation
Aikesheng Open Source Community
Aikesheng Open Source Community
Jan 23, 2024 · Databases

Changing a Primary Key to a Composite Key in TDSQL for MySQL: Dealing with sql_require_primary_key

This article explains why TDSQL for MySQL refuses to drop a primary key when the sql_require_primary_key variable is ON, analyzes the underlying parameter behavior, and provides two practical solutions—temporarily disabling the variable or combining drop and add statements—to safely convert a single‑column primary key into a composite key.

Primary KeyTDSQLcomposite key
0 likes · 7 min read
Changing a Primary Key to a Composite Key in TDSQL for MySQL: Dealing with sql_require_primary_key