okayapi_jeewms_jform_employee_other_cost - MySQ Table Design

MySQL Create Table SQL

Table Structure: okayapi_jeewms_jform_employee_other_cost：/tablelist/okayapi_jeewms_jform_employee_other_cost.html


-- MySQL Table okayapi_jeewms_jform_employee_other_cost
-- From: OkayAPI.com
CREATE TABLE `okayapi_jeewms_jform_employee_other_cost` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `fk_id` varchar(36) NULL COMMENT '外键',
    `item` varchar(20) NULL COMMENT '事项',
    `cost` decimal(7,2) NULL COMMENT '费用',
    `begin_time` datetime NULL COMMENT '开始时间',
    `end_time` datetime NULL COMMENT '结束时间',
    `comments` varchar(100) NULL COMMENT '备注',
    KEY `fk_id` (`fk_id`),
    KEY `item` (`item`),
    KEY `cost` (`cost`),
    KEY `begin_time` (`begin_time`),
    KEY `end_time` (`end_time`),
    KEY `comments` (`comments`),
    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-6 of 6 results.

Field Name	Field Type	IS NULL	Field Comment
fk_id	varchar(36)	是	外键
item	varchar(20)	是	事项
cost	decimal(7,2)	是	费用
begin_time	datetime	是	开始时间
end_time	datetime	是	结束时间
comments	varchar(100)	是	备注