+ Use This Table All Design

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 NameField TypeDefaultIS NULLField CommentIndexDemo Data
addr_idvarchar(50)地址ID
user_idvarchar(50)用户ID
receiver_namevarchar(20)收货人全名
receiver_phonevarchar(20)固定电话
receiver_mobilevarchar(30)移动电话
receiver_statevarchar(10)省份
receiver_cityvarchar(10)城市
receiver_districtvarchar(20)区/县
receiver_addressvarchar(200)收货地址,如:xx路xx号
receiver_zipvarchar(6)邮政编码,如:110000
createddatetime
updateddatetime

Guess You Like

MySQL Table Design okayapi_xbinstore_tb_category

MySQL Table Design okayapi_xbinstore_tb_category_image

MySQL Table Design okayapi_xbinstore_tb_category_secondary

MySQL Table Design okayapi_xbinstore_tb_hot_words

MySQL Table Design okayapi_xbinstore_tb_index_slide_ad

MySQL Table Design okayapi_xbinstore_tb_item

MySQL Table Design okayapi_xbinstore_tb_item_desc

MySQL Table Design okayapi_xbinstore_tb_item_param

MySQL Table Design okayapi_xbinstore_tb_item_param_item

MySQL Table Design okayapi_xbinstore_tb_manage_user

MySQL Table Design okayapi_xbinstore_tb_order

MySQL Table Design okayapi_xbinstore_tb_order_item

MySQL Table Design okayapi_xbinstore_tb_transaction_message

MySQL Table Design okayapi_xbinstore_tb_user

TOP ↑