okayapi_vhr_hr - MySQ Table Design

MySQL Create Table SQL

Table Structure: okayapi_vhr_hr：/tablelist/okayapi_vhr_hr.html


-- MySQL Table okayapi_vhr_hr
-- From: OkayAPI.com
CREATE TABLE `okayapi_vhr_hr` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `name` varchar(32) NULL COMMENT '姓名',
    `phone` char(11) NULL COMMENT '手机号码',
    `telephone` varchar(16) NULL COMMENT '住宅电话',
    `address` varchar(64) NULL COMMENT '联系地址',
    `enabled` tinyint(1) NULL DEFAULT '1' COMMENT '',
    `username` varchar(255) NULL COMMENT '用户名',
    `password` varchar(255) NULL COMMENT '密码',
    `userface` varchar(255) NULL COMMENT '',
    `remark` varchar(255) NULL COMMENT '',
    KEY `name` (`name`),
    KEY `phone` (`phone`),
    KEY `telephone` (`telephone`),
    KEY `address` (`address`),
    KEY `enabled` (`enabled`),
    KEY `username` (`username`),
    KEY `password` (`password`),
    KEY `userface` (`userface`),
    KEY `remark` (`remark`),
    PRIMARY KEY (`id`)
) ENGINE=InnoDB COMMENT '人力资源-HR';

After replication, you can go to the database to create the database table.

MySQL database table structure design

Displaying 1-9 of 9 results.

Field Name	Field Type	Default	IS NULL	Field Comment	Demo Data
name	varchar(32)		是	姓名
phone	char(11)		是	手机号码
telephone	varchar(16)		是	住宅电话
address	varchar(64)		是	联系地址
enabled	tinyint(1)	1	是		1
username	varchar(255)		是	用户名
password	varchar(255)		是	密码
userface	varchar(255)		是
remark	varchar(255)		是