okayapi_jeewms_jform_employee_meals_cost - MySQ Table Design

MySQL Create Table SQL

Table Structure: okayapi_jeewms_jform_employee_meals_cost：/tablelist/okayapi_jeewms_jform_employee_meals_cost.html


-- MySQL Table okayapi_jeewms_jform_employee_meals_cost
-- From: OkayAPI.com
CREATE TABLE `okayapi_jeewms_jform_employee_meals_cost` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `fk_id` varchar(36) NULL COMMENT '外键',
    `meals_date` date NULL COMMENT '',
    `meals_cost` decimal(7,2) NULL COMMENT '餐费',
    `meals_addr` varchar(100) NULL COMMENT '吃饭地点',
    `meals_number` int(2) NULL COMMENT '同行人数',
    `comments` varchar(100) NULL COMMENT '备注',
    KEY `fk_id` (`fk_id`),
    KEY `meals_date` (`meals_date`),
    KEY `meals_cost` (`meals_cost`),
    KEY `meals_addr` (`meals_addr`),
    KEY `meals_number` (`meals_number`),
    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)	是	外键
meals_date	date	是
meals_cost	decimal(7,2)	是	餐费
meals_addr	varchar(100)	是	吃饭地点
meals_number	int(2)	是	同行人数
comments	varchar(100)	是	备注