+ Use This Table All Design

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 NameField TypeDefaultIS NULLField CommentIndexDemo Data
basicSalaryint(11)基本工资
bonusint(11)奖金
lunchSalaryint(11)午餐补助
trafficSalaryint(11)交通补助
allSalaryint(11)应发工资
pensionBaseint(11)养老金基数
pensionPerfloat养老金比率
createDatetimestamp启用时间
medicalBaseint(11)医疗基数
medicalPerfloat医疗保险比率
accumulationFundBaseint(11)公积金基数
accumulationFundPerfloat公积金比率
namevarchar(32)

Guess You Like

MySQL Table Design okayapi_vhr_adjustsalary

MySQL Table Design okayapi_vhr_appraise

MySQL Table Design okayapi_vhr_department

MySQL Table Design okayapi_vhr_employee

MySQL Table Design okayapi_vhr_employeeec

MySQL Table Design okayapi_vhr_employeeremove

MySQL Table Design okayapi_vhr_employeetrain

MySQL Table Design okayapi_vhr_empsalary

MySQL Table Design okayapi_vhr_hr

MySQL Table Design okayapi_vhr_hr_role

MySQL Table Design okayapi_vhr_joblevel

MySQL Table Design okayapi_vhr_menu

MySQL Table Design okayapi_vhr_menu_role

MySQL Table Design okayapi_vhr_msgcontent

MySQL Table Design okayapi_vhr_nation

MySQL Table Design okayapi_vhr_oplog

MySQL Table Design okayapi_vhr_politicsstatus

MySQL Table Design okayapi_vhr_position

MySQL Table Design okayapi_vhr_role

MySQL Table Design okayapi_vhr_sysmsg

TOP ↑