MySQL Create Table SQL
Table Structure: okayapi_xbinstore_tb_user_addr:/tablelist/okayapi_xbinstore_tb_user_addr.html
-- MySQL Table okayapi_xbinstore_tb_user_addr
-- From: OkayAPI.com
CREATE TABLE `okayapi_xbinstore_tb_user_addr` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`addr_id` varchar(50) NULL COMMENT '地址ID',
`user_id` varchar(50) NULL COMMENT '用户ID',
`receiver_name` varchar(20) NULL COMMENT '收货人全名',
`receiver_phone` varchar(20) NULL COMMENT '固定电话',
`receiver_mobile` varchar(30) NULL COMMENT '移动电话',
`receiver_state` varchar(10) NULL COMMENT '省份',
`receiver_city` varchar(10) NULL COMMENT '城市',
`receiver_district` varchar(20) NULL COMMENT '区/县',
`receiver_address` varchar(200) NULL COMMENT '收货地址,如:xx路xx号',
`receiver_zip` varchar(6) NULL COMMENT '邮政编码,如:110000',
`created` datetime NULL COMMENT '',
`updated` datetime NULL COMMENT '',
KEY `addr_id` (`addr_id`),
KEY `user_id` (`user_id`),
KEY `receiver_name` (`receiver_name`),
KEY `receiver_phone` (`receiver_phone`),
KEY `receiver_mobile` (`receiver_mobile`),
KEY `receiver_state` (`receiver_state`),
KEY `receiver_city` (`receiver_city`),
KEY `receiver_district` (`receiver_district`),
KEY `receiver_address` (`receiver_address`),
KEY `receiver_zip` (`receiver_zip`),
KEY `created` (`created`),
KEY `updated` (`updated`),
PRIMARY KEY (`id`)
) ENGINE=InnoDB COMMENT 'B2C商城-用户地址';
After replication, you can go to the database to create the database table.
MySQL database table structure design
Displaying 1-12 of 12 results.
Field Name | Field Type | Default | IS NULL | Field Comment | Index | Demo Data |
---|---|---|---|---|---|---|
addr_id | varchar(50) | 否 | 地址ID | |||
user_id | varchar(50) | 否 | 用户ID | |||
receiver_name | varchar(20) | 是 | 收货人全名 | |||
receiver_phone | varchar(20) | 是 | 固定电话 | |||
receiver_mobile | varchar(30) | 是 | 移动电话 | |||
receiver_state | varchar(10) | 是 | 省份 | |||
receiver_city | varchar(10) | 是 | 城市 | |||
receiver_district | varchar(20) | 是 | 区/县 | |||
receiver_address | varchar(200) | 是 | 收货地址,如:xx路xx号 | |||
receiver_zip | varchar(6) | 是 | 邮政编码,如:110000 | |||
created | datetime | 是 | ||||
updated | datetime | 是 |