1. In terms of program, there is no need to create another table. If the design of the two tables is the same, the data can be taken out by union all at once 2. In terms of design, I think it is better to add another transaction record table, which has better scalability. Maybe you need to add other types of transactions later, you can put them in this table
![[Web front-end] Node.js quick start](https://img.php.cn/upload/course/000/000/067/662b5d34ba7c0227.png)
1. In terms of program, there is no need to create another table. If the design of the two tables is the same, the data can be taken out by union all at once
2. In terms of design, I think it is better to add another transaction record table, which has better scalability. Maybe you need to add other types of transactions later, you can put them in this table