当前位置:网站首页>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
边栏推荐
- WebView的优化与常见问题解决方案
- Makefile missing separator. Stop.怎么解决「建议收藏」
- ES5和SE6来实现一个Promise效果
- 正则表达式(包含各种括号,echo,正则三剑客以及各种正则工具)
- SenseTime self-developed robotic arm, the first product is an AI chess-playing robot: Guo Jingjing is also invited as an endorsement
- 高数_证明_弧微分公式
- AWS 安全基础知识
- PHP 判断文件是否有内容,没有内容则复制另一个文件写入
- 注意力模型---Attention Model
- 锂电池技术
猜你喜欢
随机推荐
CodeForces - 811A
【219】慕课三千多的那个go工程师的培训课笔记 02 go语言的编程思想
1W字详解线程本地存储 ThreadLocal
A unit test report for CRM One Order Application log
系统架构系列文章三--解决传统企业核心系统的性能问题
WebView的优化与常见问题解决方案
AWS Security Fundamentals
MySQL interview questions
Import other custom namespaces in C#
3DS MAX batch export file script MAXScript with interface
Short read or OOM loading DB. Unrecoverable error, aborting now
SenseTime self-developed robotic arm, the first product is an AI chess-playing robot: Guo Jingjing is also invited as an endorsement
ICML 2022 | 基于随机注意力机制的可解释可泛化图学习
leetcode 739. Daily Temperatures Daily Temperatures (Moderate)
win2012安装Oraclerac失败
awk的简单使用
使用决策树对鸢尾花进行分类
2022年五大云虚拟化趋势
Borg Maze (bfs+最小生成树)
安装mysql报错处理