Tagged articles
database schema
32 articles · Page 1 of 1
This article details the evolution of a unified login system covering phone-based registration, third-party OAuth integration, a normalized database schema separating user profiles from authentication methods, and carrier-based one-click login that reduces authentication time from 20 seconds to 2 seconds.
SIM verificationcarrier authenticationdatabase schema
0 likes · 17 min read

The article explains why marketing activity tables require a status field (draft, approving, release, cancelled) alongside start_time and end_time, because time fields alone cannot represent manual termination, approval workflows, or operational interventions, and demonstrates SQL queries combining both dimensions.
SQL queriesactivity table designbackend development
0 likes · 4 min read


ZhiKe AIMay 30, 2026 · Information Security
The article explains why enterprise back‑office applications inevitably adopt Role‑Based Access Control (RBAC), describes its core principle of indirect permission mapping, presents the standard five‑table schema, explores extensions such as role inheritance (RBAC1) and separation of duty (RBAC2/3), and provides practical tips, performance trade‑offs, common pitfalls and references to standards and open‑source implementations.
Backend SecurityRBACRole Hierarchy
0 likes · 22 min read

This article walks through the design of a unified multi‑account login system, covering phone‑number registration, password‑optional login, third‑party integration, database schema separation, pros and cons, and a one‑click carrier‑based authentication flow.
BackendMulti-Accountaccount design
0 likes · 15 min read

This article explains why strict permission management is essential for data security, walks through the evolution of access‑control models—from simple user‑permission tables to classic RBAC, RBAC1, RBAC2, role inheritance, constraints, user groups, organizational mapping, and finally presents ideal database schemas for scalable, maintainable permission systems.
Backend SecurityPermission ManagementRBAC
0 likes · 18 min read

This article details the modular design of Flowable's core database tables, dividing them into five categories—Repository, Runtime, History, Identity, and General Data—and explains each table’s fields, types, and inter‑table relationships, including multi‑tenant support and optimistic‑locking mechanisms.
BPMNFlowableProcess History
0 likes · 17 min read

The article details Flowable 6.8's modular, efficient, and extensible table design, explaining the five table categories (RE, RU, HI, ID, GE), naming conventions, key tables for repository, runtime, history, identity, and generic data, their functions, and how they relate to each other in the BPM engine.
BPMFlowableTable Design
0 likes · 8 min read

This article explains how to design and implement a generic asynchronous processing SDK for Java backend services, covering its purpose, advantages, underlying principles, component choices, database schema, configuration, usage patterns, and best‑practice notes, with code examples and diagrams.
Asynchronous ProcessingConfigurationJava backend
0 likes · 9 min read

This article explains a metadata‑driven approach for extending massive tables—using a separate extension table, sharding, and Elasticsearch sync—to add new fields to billion‑row databases without locking the primary table or disrupting online services.
ElasticsearchShardingbig data
0 likes · 6 min read

This article examines why storing 2 billion phone numbers using INT or BIGINT is problematic and argues for using VARCHAR(20) to preserve data integrity, support international formats, simplify queries, and avoid common pitfalls in database design and development.
SQLVARCHAR vs BIGINTdata integrity
0 likes · 8 min read

The article clarifies that the number in MySQL's int(N) definition does not restrict the column's numeric range, demonstrates this with insert tests, and explains that only when combined with ZEROFILL does the display width affect how values are shown.
MySQLSQLZEROFILL
0 likes · 4 min read

This article explains how to migrate sharded Mycat data to ActionDB with ActionOMS, addressing duplicate primary keys by modifying both source and target schemas, configuring migration tools, and completing validation and post‑migration steps.
ActionDBActionOMSMySQL
0 likes · 9 min read

This article explains the design, advantages, and implementation details of a generic asynchronous processing SDK that leverages Spring transactional events, Kafka messaging, XXL‑Job scheduling, and a non‑intrusive architecture to ensure data consistency, fault tolerance, and easy integration across services.
Asynchronous ProcessingKafkaSpring
0 likes · 11 min read

While MySQL 5.7 native DDL methods (copy, inplace rebuild, index build, metadata‑only) vary in speed, space use, lock impact, and binlog output, GH‑OST consistently offers the fastest execution, lowest lock blocking, real‑time replication, albeit at roughly double storage cost, making it ideal for risk‑averse online schema changes.
DDLDatabase MigrationInnoDB
0 likes · 11 min read


IT NiukeApr 21, 2024 · Information Security
This article explains why strict permission management is essential, walks through various RBAC models—including role inheritance and constrained RBAC—covers user groups, organizations, and positions, and presents both standard and ideal database table designs for implementing a scalable access‑control system.
RBACaccess controldatabase schema
0 likes · 17 min read

This article outlines the functional and non‑functional requirements of a booking platform, proposes a micro‑service‑based backend architecture, presents UML component and sequence diagrams, details database schemas, defines RESTful APIs, and provides Go code examples for user registration and booking creation, offering a comprehensive design blueprint.
API DesignBackenddatabase schema
0 likes · 10 min read

This article introduces a free, low‑code tool that lets backend developers automatically generate functional front‑end management pages from database structures or description files, detailing two generation methods, configuration steps, code snippets, and deployment tips.
Toolauto UIdatabase schema
0 likes · 6 min read


LouZaiNov 10, 2023 · Backend Development
This article walks through the full architecture of a modern bus and subway ticketing platform, covering functional and non‑functional requirements, core components, interaction flows, database schema, shortest‑path routing with Dijkstra, QR‑code generation in Go, and high‑concurrency strategies.
QR Codebackend designbus
0 likes · 16 min read

This article explains three relatively new MySQL 8.0 features—hidden (invisible) columns, generated invisible primary keys, and invisible indexes—detailing their purpose, how to create and use them, and practical scenarios where they can help avoid schema‑change issues or test query performance.
Generated Primary KeyInvisible ColumnsMySQL
0 likes · 11 min read

This article outlines a comprehensive approach to building a scalable multi‑account login system that supports phone‑number/password, phone‑number/verification‑code, and various third‑party OAuth providers, detailing workflow steps, database schema, advantages, drawbacks, and a one‑click login integration.
AuthenticationBackendThird-Party Login
0 likes · 15 min read

This article walks through the Mall project's product module—covering its architecture, feature design, database schema, and API implementation—while providing links to source code, video tutorials, and a mind‑map that together serve as a comprehensive guide for building robust e‑commerce systems.
API DesignSpringBootbackend development
0 likes · 10 min read

This article examines the architecture of a Weibo-like feed system, detailing storage design, read‑heavy scenarios, push (write‑diffusion) and pull (read‑diffusion) models, their trade‑offs, and a hybrid approach for handling both small and massive follower counts.
database schemafeed designpull model
0 likes · 10 min read


21CTONov 19, 2022 · Backend Development
This article details the end‑to‑end design of a coupon system for a rental listing platform, covering business flow, MySQL table schemas, activity lifecycle management, state‑machine and observer patterns, high‑concurrency claim handling with Redis and MQ, and future scalability optimizations.
Coupon Systembackend designdatabase schema
0 likes · 20 min read

This article details the design and implementation of a coupon system for a rental platform, covering business flow, database schema, backend services, caching strategies, state management, and future optimization directions to ensure reliable coupon distribution and redemption.
CachingCoupon Systembackend design
0 likes · 20 min read

This guide walks you through structuring a system‑design discussion—from clarifying functional and non‑functional requirements, mapping user flows and API calls, to outlining high‑level architecture, scaling strategies, and drafting a database schema—using a Twitter‑like example to illustrate each step.
API Designdatabase schemarequirements
0 likes · 9 min read

This article explains the end‑to‑end design of a coupon system for e‑commerce, covering promotion types, core workflows, service architecture, database schema, distributed transaction handling, scaling strategies, rate limiting, and consistency mechanisms such as TCC.
Coupon SystemTCCbackend design
0 likes · 15 min read

This article explains the technical design of multi‑account unified login, covering startup‑phase username/password and phone‑number authentication flows, detailed database table structures, and third‑party OAuth2 integration with practical implementation steps and diagrams.
Third-party Integrationauthentication flowdatabase schema
0 likes · 9 min read

This article explains the concepts of data model, data dictionary, database schema, and ER diagram, clarifies their differences, and compares them across stages, purposes, detail levels, authors, users, tools, and forms to help readers grasp database design terminology.
Data ModelingER diagramdata dictionary
0 likes · 6 min read

This article provides a comprehensive walkthrough of the coupon feature's database tables—including definitions for coupons, coupon history, product relations, and category relations—along with screenshots of both admin and mobile interfaces that illustrate how these tables are used in an e‑commerce system.
SQLcoupondatabase schema
0 likes · 6 min read

This article provides a comprehensive walkthrough of the order return and return‑reason database tables, detailing each field, status codes, and the corresponding admin and mobile UI screens that illustrate how the return process works in an e‑commerce system.
SQLdatabase schemae-commerce
0 likes · 7 min read

This article dissects the e‑commerce shopping cart database schema, explains the end‑to‑end order lifecycle—from adding items and calculating promotions to generating confirmation orders, creating orders, and handling cancellations—while highlighting key implementation details and code references for backend developers.
Order ProcessingShopping Cartdatabase schema
0 likes · 7 min read

This article examines two database schema designs for a simple discussion forum, compares their table structures, highlights trade‑offs in query performance and storage, and explains why splitting tables can reduce data reads and improve overall efficiency.
SQLdatabase schemadiscussion forum
0 likes · 5 min read
