+ Use This Table All Design

MySQL Create Table SQL

Table Structure: okayapi_srcms_info:/tablelist/okayapi_srcms_info.html


-- MySQL Table okayapi_srcms_info
-- From: OkayAPI.com
CREATE TABLE `okayapi_srcms_info` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `user_id` int(11) NOT NULL COMMENT '',
    `username` varchar(20) NOT NULL COMMENT '',
    `realname` varchar(20) NOT NULL COMMENT '',
    `location` varchar(50) NOT NULL COMMENT '',
    `tel` varchar(11) NOT NULL COMMENT '',
    `zipcode` varchar(6) NOT NULL COMMENT '',
    `alipay` varchar(20) NOT NULL COMMENT '',
    KEY `user_id` (`user_id`),
    KEY `username` (`username`),
    KEY `realname` (`realname`),
    KEY `location` (`location`),
    KEY `tel` (`tel`),
    KEY `zipcode` (`zipcode`),
    KEY `alipay` (`alipay`),
    PRIMARY KEY (`id`)
) ENGINE=InnoDB COMMENT 'SRCMS-信息';

After replication, you can go to the database to create the database table.


MySQL database table structure design

Displaying 1-7 of 7 results.
Field NameField TypeDefaultIS NULLField CommentIndexDemo Data
user_idint(11)
usernamevarchar(20)
realnamevarchar(20)
locationvarchar(50)
telvarchar(11)
zipcodevarchar(6)
alipayvarchar(20)

Guess You Like

MySQL Table Design okayapi_srcms_blog

MySQL Table Design okayapi_srcms_category

MySQL Table Design okayapi_srcms_comment

MySQL Table Design okayapi_srcms_hall

MySQL Table Design okayapi_srcms_links

MySQL Table Design okayapi_srcms_manager

MySQL Table Design okayapi_srcms_member

MySQL Table Design okayapi_srcms_notes

MySQL Table Design okayapi_srcms_order

MySQL Table Design okayapi_srcms_page

MySQL Table Design okayapi_srcms_post

MySQL Table Design okayapi_srcms_record

MySQL Table Design okayapi_srcms_setting

TOP ↑