当前位置:网站首页>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
边栏推荐
猜你喜欢
【ECCV 2022|Millions of Prizes】PSG Competition: Pursuing the "Most Comprehensive" Scene Understanding
WebView的优化与常见问题解决方案
Short read or OOM loading DB. Unrecoverable error, aborting now
作业8.9 构建TCP协议的服务器
什么?你还不会JVM调优?
【学习笔记】Redis的持久化
系统的安全和应用(不会点安全的东西你怎么睡得着?)
【目标检测】小脚本:提取训练集图片与标签并更新索引
高数_证明_曲率公式
[JS Advanced] Creating sub-objects and replacing this_10 in ES5 standard specification
随机推荐
numpy.meshgrid()理解
X5WebView使用
2012年下半年 系统架构设计师 下午试卷 II
Send a post request at the front desk can't get the data
R语言实战应用案例:论文篇(一)-特殊柱形图绘制
重要通知 | “移动云杯”算力网络应用创新大赛初赛延期!!
leetcode 739. Daily Temperatures 每日温度(中等)
数据产品经理那点事儿 一
vivado闪退或者message无显示
【MinIO】Using tools
Interface Automation Testing Basics
【JS高级】ES5标准规范之创建子对象以及替换this_10
Vivado crashes or the message is not displayed
安装mysql报错处理
【POI 2008, BLO】割点
Error: Rule can only have one resource source (provided resource and test + include + exclude)
汉字检测和关键词检测
sql语句 异常 Err] 1064 – You have an error in your SQL syntax; check the manual that corresponds to your
Error: Rule can only have one resource source (provided resource and test + include + exclude)
作业