okayapi_openant_language - MySQ Table Design

MySQL Create Table SQL

Table Structure: okayapi_openant_language：/tablelist/okayapi_openant_language.html


-- MySQL Table okayapi_openant_language
-- From: OkayAPI.com
CREATE TABLE `okayapi_openant_language` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `language_id` int(11) NOT NULL COMMENT '',
    `okayapi_openant_language_name` varchar(32) NOT NULL COMMENT '',
    `okayapi_openant_language_code` varchar(5) NOT NULL COMMENT '',
    `locale` varchar(255) NOT NULL COMMENT '',
    `image` varchar(64) NOT NULL COMMENT '',
    `language_name` varchar(32) NOT NULL COMMENT '',
    `sort_order` int(3) NOT NULL DEFAULT '0' COMMENT '',
    `okayapi_openant_language_status` tinyint(1) NOT NULL COMMENT '',
    KEY `language_id` (`language_id`),
    KEY `okayapi_openant_language_name` (`okayapi_openant_language_name`),
    KEY `okayapi_openant_language_code` (`okayapi_openant_language_code`),
    KEY `locale` (`locale`),
    KEY `image` (`image`),
    KEY `language_name` (`language_name`),
    KEY `sort_order` (`sort_order`),
    KEY `okayapi_openant_language_status` (`okayapi_openant_language_status`),
    PRIMARY KEY (`id`)
) ENGINE=InnoDB COMMENT 'openant电商-语言';

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

MySQL database table structure design

Displaying 1-8 of 8 results.

Field Name	Field Type	Default	IS NULL	Demo Data
language_id	int(11)		否
okayapi_openant_language_name	varchar(32)		否
okayapi_openant_language_code	varchar(5)		否
locale	varchar(255)		否
image	varchar(64)		否
language_name	varchar(32)		否
sort_order	int(3)	0	否	0
okayapi_openant_language_status	tinyint(1)		否