okayapi_f_sample_product - MySQ Table Design

MySQL Create Table SQL

Table Structure: okayapi_f_sample_product：/tablelist/okayapi_f_sample_product.html


-- MySQL Table okayapi_f_sample_product
-- From: OkayAPI.com
CREATE TABLE `okayapi_f_sample_product` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `okayapi_f_sample_product_name` varchar(20) NULL COMMENT '产品名称',
    `description` varchar(500) NULL COMMENT '产品描述',
    `okayapi_f_sample_product_level` varchar(10) NULL COMMENT '产品等级',
    `user_id` bigint(20) NULL COMMENT '创建人',
    `create_time` datetime NULL COMMENT '创建时间',
    KEY `okayapi_f_sample_product_name` (`okayapi_f_sample_product_name`),
    KEY `description` (`description`),
    KEY `okayapi_f_sample_product_level` (`okayapi_f_sample_product_level`),
    KEY `user_id` (`user_id`),
    KEY `create_time` (`create_time`),
    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-5 of 5 results.

Field Name	Field Type	IS NULL	Field Comment	Index
okayapi_f_sample_product_name	varchar(20)	否	产品名称
description	varchar(500)	是	产品描述
okayapi_f_sample_product_level	varchar(10)	否	产品等级
user_id	bigint(20)	否	创建人	Normal Index
create_time	datetime	是	创建时间