MySQL Create Table SQL
Table Structure: okayapi_vhr_salary:/tablelist/okayapi_vhr_salary.html
-- MySQL Table okayapi_vhr_salary
-- From: OkayAPI.com
CREATE TABLE `okayapi_vhr_salary` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`basicSalary` int(11) NULL COMMENT '基本工资',
`bonus` int(11) NULL COMMENT '奖金',
`lunchSalary` int(11) NULL COMMENT '午餐补助',
`trafficSalary` int(11) NULL COMMENT '交通补助',
`allSalary` int(11) NULL COMMENT '应发工资',
`pensionBase` int(11) NULL COMMENT '养老金基数',
`pensionPer` float NULL COMMENT '养老金比率',
`createDate` timestamp NULL COMMENT '启用时间',
`medicalBase` int(11) NULL COMMENT '医疗基数',
`medicalPer` float NULL COMMENT '医疗保险比率',
`accumulationFundBase` int(11) NULL COMMENT '公积金基数',
`accumulationFundPer` float NULL COMMENT '公积金比率',
`name` varchar(32) NULL COMMENT '',
KEY `basicSalary` (`basicSalary`),
KEY `bonus` (`bonus`),
KEY `lunchSalary` (`lunchSalary`),
KEY `trafficSalary` (`trafficSalary`),
KEY `allSalary` (`allSalary`),
KEY `pensionBase` (`pensionBase`),
KEY `pensionPer` (`pensionPer`),
KEY `createDate` (`createDate`),
KEY `medicalBase` (`medicalBase`),
KEY `medicalPer` (`medicalPer`),
KEY `accumulationFundBase` (`accumulationFundBase`),
KEY `accumulationFundPer` (`accumulationFundPer`),
KEY `name` (`name`),
PRIMARY KEY (`id`)
) ENGINE=InnoDB COMMENT '人力资源-工资待遇';
After replication, you can go to the database to create the database table.
MySQL database table structure design
Displaying 1-13 of 13 results.
Field Name | Field Type | Default | IS NULL | Field Comment | Index | Demo Data |
---|---|---|---|---|---|---|
basicSalary | int(11) | 是 | 基本工资 | |||
bonus | int(11) | 是 | 奖金 | |||
lunchSalary | int(11) | 是 | 午餐补助 | |||
trafficSalary | int(11) | 是 | 交通补助 | |||
allSalary | int(11) | 是 | 应发工资 | |||
pensionBase | int(11) | 是 | 养老金基数 | |||
pensionPer | float | 是 | 养老金比率 | |||
createDate | timestamp | 是 | 启用时间 | |||
medicalBase | int(11) | 是 | 医疗基数 | |||
medicalPer | float | 是 | 医疗保险比率 | |||
accumulationFundBase | int(11) | 是 | 公积金基数 | |||
accumulationFundPer | float | 是 | 公积金比率 | |||
name | varchar(32) | 是 |