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 Name | Field Type | Default | IS NULL | Field Comment | Index | Demo Data |
---|---|---|---|---|---|---|
user_id | int(11) | 否 | ||||
username | varchar(20) | 否 | ||||
realname | varchar(20) | 否 | ||||
location | varchar(50) | 否 | ||||
tel | varchar(11) | 否 | ||||
zipcode | varchar(6) | 否 | ||||
alipay | varchar(20) | 否 |