MySQL Create Table SQL
Table Structure: okayapi_mall_ums_member_receive_address:/tablelist/okayapi_mall_ums_member_receive_address.html
-- MySQL Table okayapi_mall_ums_member_receive_address
-- From: OkayAPI.com
CREATE TABLE `okayapi_mall_ums_member_receive_address` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`member_id` bigint(20) NULL COMMENT '',
`okayapi_mall_ums_member_receive_address_name` varchar(100) NULL COMMENT '收货人名称',
`phone_number` varchar(64) NULL COMMENT '',
`default_status` int(1) NULL COMMENT '是否为默认',
`post_code` varchar(100) NULL COMMENT '邮政编码',
`province` varchar(100) NULL COMMENT '省份/直辖市',
`city` varchar(100) NULL COMMENT '城市',
`region` varchar(100) NULL COMMENT '区',
`detail_address` varchar(128) NULL COMMENT '详细地址(街道)',
KEY `member_id` (`member_id`),
KEY `okayapi_mall_ums_member_receive_address_name` (`okayapi_mall_ums_member_receive_address_name`),
KEY `phone_number` (`phone_number`),
KEY `default_status` (`default_status`),
KEY `post_code` (`post_code`),
KEY `province` (`province`),
KEY `city` (`city`),
KEY `region` (`region`),
KEY `detail_address` (`detail_address`),
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-9 of 9 results.
Field Name | Field Type | Default | IS NULL | Field Comment | Index | Demo Data |
---|---|---|---|---|---|---|
member_id | bigint(20) | 是 | ||||
okayapi_mall_ums_member_receive_address_name | varchar(100) | 是 | 收货人名称 | |||
phone_number | varchar(64) | 是 | ||||
default_status | int(1) | 是 | 是否为默认 | |||
post_code | varchar(100) | 是 | 邮政编码 | |||
province | varchar(100) | 是 | 省份/直辖市 | |||
city | varchar(100) | 是 | 城市 | |||
region | varchar(100) | 是 | 区 | |||
detail_address | varchar(128) | 是 | 详细地址(街道) |