+ Use This Table All Design

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 NameField TypeDefaultIS NULLField CommentIndexDemo Data
member_idbigint(20)
okayapi_mall_ums_member_receive_address_namevarchar(100)收货人名称
phone_numbervarchar(64)
default_statusint(1)是否为默认
post_codevarchar(100)邮政编码
provincevarchar(100)省份/直辖市
cityvarchar(100)城市
regionvarchar(100)
detail_addressvarchar(128)详细地址(街道)

Guess You Like

MySQL Table Design okayapi_mall_ums_member_rule_setting

MySQL Table Design okayapi_mall_ums_member_statistics_info

MySQL Table Design okayapi_mall_ums_role_permission_relation

MySQL Table Design okayapi_cloud_image_sync

MySQL Table Design okayapi_hc_act_re_model

MySQL Table Design okayapi_hc_group_buy

TOP ↑