当前位置:网站首页>How is the monthly salary table stored in the database?Ask for a design idea

How is the monthly salary table stored in the database?Ask for a design idea

2022-08-10 14:05:00 CSDN Q&A

I encountered a problem with the storage of the salary table when developing a salary inquiry system.There are employee information and department information tables in the current database, and the salary table is imported through the EXCEL report sent by HR (the report contains salary number, name, and department).

The function implemented by the system is very simple: employees can query their own wages, and HR can calculate the wages of the whole company or each department.
During the development process, there is a problem that has been bothering me for a long time. I would like to ask you: How is the monthly salary table stored?Is there a separate Table for each month's salary form in the database?
Each Tabel is named in the format of: year_month?Isn't this design too rude.

Development environment: python + mysql, I don't know if you have any good ideas, welcome everyoneComments
原网站

版权声明
本文为[CSDN Q&A]所创,转载请带上原文链接,感谢
https://yzsam.com/2022/222/202208032229226757.html