okayapi_openant_address - MySQ Table Design

MySQL Create Table SQL

Table Structure: okayapi_openant_address：/tablelist/okayapi_openant_address.html


-- MySQL Table okayapi_openant_address
-- From: OkayAPI.com
CREATE TABLE `okayapi_openant_address` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `address_id` int(11) NOT NULL COMMENT '',
    `user_id` int(11) NOT NULL COMMENT '',
    `firstname` varchar(32) NOT NULL COMMENT '',
    `lastname` varchar(32) NOT NULL COMMENT '',
    `address` varchar(128) NOT NULL COMMENT '',
    `city` varchar(128) NOT NULL COMMENT '',
    `postcode` varchar(10) NOT NULL COMMENT '',
    `country_id` int(11) NOT NULL DEFAULT '0' COMMENT '',
    `zone_id` int(11) NOT NULL DEFAULT '0' COMMENT '',
    KEY `address_id` (`address_id`),
    KEY `user_id` (`user_id`),
    KEY `firstname` (`firstname`),
    KEY `lastname` (`lastname`),
    KEY `address` (`address`),
    KEY `city` (`city`),
    KEY `postcode` (`postcode`),
    KEY `country_id` (`country_id`),
    KEY `zone_id` (`zone_id`),
    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-9 of 9 results.

Field Name	Field Type	Default	IS NULL	Demo Data
address_id	int(11)		否
user_id	int(11)		否
firstname	varchar(32)		否
lastname	varchar(32)		否
address	varchar(128)		否
city	varchar(128)		否
postcode	varchar(10)		否
country_id	int(11)	0	否	0
zone_id	int(11)	0	否	0