+ Use This Table All Design

MySQL Create Table SQL

Table Structure: okayapi_openant_user:/tablelist/okayapi_openant_user.html


-- MySQL Table okayapi_openant_user
-- From: OkayAPI.com
CREATE TABLE `okayapi_openant_user` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `user_id` int(11) NOT NULL COMMENT '',
    `user_group_id` int(11) NOT NULL COMMENT '',
    `user_class_id` int(11) NOT NULL COMMENT '',
    `sale_class_id` int(11) NOT NULL COMMENT '',
    `store_id` int(11) NOT NULL DEFAULT '0' COMMENT '',
    `firstname` varchar(32) NOT NULL COMMENT '',
    `lastname` varchar(32) NOT NULL COMMENT '',
    `nickname` varchar(28) NOT NULL COMMENT '',
    `gender` varchar(28) NOT NULL COMMENT '',
    `email` varchar(96) NOT NULL COMMENT '',
    `telephone` varchar(32) NOT NULL COMMENT '',
    `okayapi_openant_user_password` varchar(40) NOT NULL COMMENT '',
    `image` varchar(255) NOT NULL COMMENT '',
    `description` varchar(255) NOT NULL COMMENT '',
    `newsletter` tinyint(1) NOT NULL DEFAULT '0' COMMENT '',
    `address_id` int(11) NOT NULL DEFAULT '0' COMMENT '',
    `user_field` text NOT NULL COMMENT '',
    `ip` varchar(40) NOT NULL COMMENT '',
    `okayapi_openant_user_status` tinyint(1) NOT NULL COMMENT '',
    `safe` tinyint(1) NOT NULL COMMENT '',
    `token` text NOT NULL COMMENT '',
    `date_added` datetime NOT NULL COMMENT '',
    KEY `user_id` (`user_id`),
    KEY `user_group_id` (`user_group_id`),
    KEY `user_class_id` (`user_class_id`),
    KEY `sale_class_id` (`sale_class_id`),
    KEY `store_id` (`store_id`),
    KEY `firstname` (`firstname`),
    KEY `lastname` (`lastname`),
    KEY `nickname` (`nickname`),
    KEY `gender` (`gender`),
    KEY `email` (`email`),
    KEY `telephone` (`telephone`),
    KEY `okayapi_openant_user_password` (`okayapi_openant_user_password`),
    KEY `image` (`image`),
    KEY `description` (`description`),
    KEY `newsletter` (`newsletter`),
    KEY `address_id` (`address_id`),
    KEY `user_field` (`user_field`),
    KEY `ip` (`ip`),
    KEY `okayapi_openant_user_status` (`okayapi_openant_user_status`),
    KEY `safe` (`safe`),
    KEY `token` (`token`),
    KEY `date_added` (`date_added`),
    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-22 of 22 results.
Field NameField TypeDefaultIS NULLField CommentIndexDemo Data
user_idint(11)
user_group_idint(11)
user_class_idint(11)
sale_class_idint(11)
store_idint(11)00
firstnamevarchar(32)
lastnamevarchar(32)
nicknamevarchar(28)
gendervarchar(28)
emailvarchar(96)
telephonevarchar(32)
okayapi_openant_user_passwordvarchar(40)
imagevarchar(255)
descriptionvarchar(255)
newslettertinyint(1)00
address_idint(11)00
user_fieldtext
ipvarchar(40)
okayapi_openant_user_statustinyint(1)
safetinyint(1)
tokentext
date_addeddatetime

Guess You Like

MySQL Table Design okayapi_goods

MySQL Table Design okayapi_goods_comment

MySQL Table Design okayapi_shopxo_s_admin

MySQL Table Design okayapi_shopxo_s_answer

MySQL Table Design okayapi_shopxo_s_app_center_nav

MySQL Table Design okayapi_shopxo_s_app_home_nav

MySQL Table Design okayapi_shopxo_s_article

MySQL Table Design okayapi_shopxo_s_article_category

MySQL Table Design okayapi_shopxo_s_attachment

MySQL Table Design okayapi_shopxo_s_brand

MySQL Table Design okayapi_shopxo_s_brand_category

MySQL Table Design okayapi_shopxo_s_cart

MySQL Table Design okayapi_shopxo_s_config

MySQL Table Design okayapi_shopxo_s_custom_view

MySQL Table Design okayapi_shopxo_s_express

MySQL Table Design okayapi_shopxo_s_goods

MySQL Table Design okayapi_shopxo_s_goods_browse

MySQL Table Design okayapi_shopxo_s_goods_category

MySQL Table Design okayapi_shopxo_s_goods_category_join

MySQL Table Design okayapi_shopxo_s_goods_comments

TOP ↑