okayapi_openant_country - MySQ Table Design

MySQL Create Table SQL

Table Structure: okayapi_openant_country：/tablelist/okayapi_openant_country.html


-- MySQL Table okayapi_openant_country
-- From: OkayAPI.com
CREATE TABLE `okayapi_openant_country` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `country_id` int(11) NOT NULL COMMENT '',
    `iso_code_2` varchar(2) NOT NULL COMMENT '',
    `iso_code_3` varchar(3) NOT NULL COMMENT '',
    `address_format` text NOT NULL COMMENT '',
    `postcode_required` tinyint(1) NOT NULL COMMENT '',
    `okayapi_openant_country_status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '',
    KEY `country_id` (`country_id`),
    KEY `iso_code_2` (`iso_code_2`),
    KEY `iso_code_3` (`iso_code_3`),
    KEY `address_format` (`address_format`),
    KEY `postcode_required` (`postcode_required`),
    KEY `okayapi_openant_country_status` (`okayapi_openant_country_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-6 of 6 results.

Field Name	Field Type	Default	IS NULL	Demo Data
country_id	int(11)		否
iso_code_2	varchar(2)		否
iso_code_3	varchar(3)		否
address_format	text		否
postcode_required	tinyint(1)		否
okayapi_openant_country_status	tinyint(1)	1	否	1