okayapi_landi_staff - MySQ Table Design

MySQL Create Table SQL

Table Structure: okayapi_landi_staff：/tablelist/okayapi_landi_staff.html


-- MySQL Table okayapi_landi_staff
-- From: OkayAPI.com
CREATE TABLE `okayapi_landi_staff` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `okayapi_landi_staff_name` varchar(64) NULL COMMENT '考虑职员名称的唯一性约束问题！',
    `duty` varchar(64) NULL COMMENT '职务',
    `depart` varchar(64) NULL COMMENT '部门',
    `join_date` date NULL COMMENT '加入日期',
    `state` tinyint(3) NULL COMMENT '1 在职 0 已解雇',
    KEY `okayapi_landi_staff_name` (`okayapi_landi_staff_name`),
    KEY `duty` (`duty`),
    KEY `depart` (`depart`),
    KEY `join_date` (`join_date`),
    KEY `state` (`state`),
    PRIMARY KEY (`id`)
) ENGINE=InnoDB COMMENT 'LD酒店租房管理-员工';

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

MySQL database table structure design

Displaying 1-5 of 5 results.

Field Name	Field Type	IS NULL	Field Comment
okayapi_landi_staff_name	varchar(64)	是	考虑职员名称的唯一性约束问题！
duty	varchar(64)	是	职务
depart	varchar(64)	是	部门
join_date	date	是	加入日期
state	tinyint(3)	是	1 在职 0 已解雇