+ Use This Table All Design

MySQL Create Table SQL

Table Structure: okayapi_provinces_log:/tablelist/okayapi_provinces_log.html


-- MySQL Table okayapi_provinces_log
-- From: OkayAPI.com
CREATE TABLE `okayapi_provinces_log` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `title` varchar(50) NOT NULL COMMENT '栏目名',
    `pid` int(10) NOT NULL DEFAULT '0' COMMENT '父栏目',
    `short_title` varchar(50) NOT NULL COMMENT '缩写',
    `areacode` int(6) NOT NULL DEFAULT '0' COMMENT '区域编码',
    `zipcode` int(10) NOT NULL DEFAULT '0' COMMENT '邮政编码',
    `pinyin` varchar(100) NOT NULL COMMENT '拼音',
    `lng` varchar(20) NOT NULL COMMENT '经度',
    `lat` varchar(20) NOT NULL COMMENT '纬度',
    `level` tinyint(4) NOT NULL DEFAULT '1' COMMENT '级别',
    `position` varchar(200) NOT NULL COMMENT '具体位置',
    `sort` tinyint(3) NOT NULL DEFAULT '0' COMMENT '排序',
    KEY `title` (`title`),
    KEY `pid` (`pid`),
    KEY `short_title` (`short_title`),
    KEY `areacode` (`areacode`),
    KEY `zipcode` (`zipcode`),
    KEY `pinyin` (`pinyin`),
    KEY `lng` (`lng`),
    KEY `lat` (`lat`),
    KEY `level` (`level`),
    KEY `position` (`position`),
    KEY `sort` (`sort`),
    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-11 of 11 results.
Field NameField TypeDefaultIS NULLField CommentIndexDemo Data
titlevarchar(50)栏目名
pidint(10)0父栏目Normal Index0
short_titlevarchar(50)缩写
areacodeint(6)0区域编码0
zipcodeint(10)0邮政编码0
pinyinvarchar(100)拼音
lngvarchar(20)经度
latvarchar(20)纬度
leveltinyint(4)1级别1
positionvarchar(200)具体位置
sorttinyint(3)0排序0

Guess You Like

MySQL Table Design okayapi_file_uploads

MySQL Table Design okayapi_framework_log

MySQL Table Design okayapi_sms_log

MySQL Table Design okayapi_member_datas_log

MySQL Table Design okayapi_member_vip

MySQL Table Design okayapi_sys_message

MySQL Table Design okayapi_sys_notice_manage

MySQL Table Design okayapi_sys_menu_manage

MySQL Table Design okayapi_sys_config_manage

MySQL Table Design okayapi_sys_addon_manage

MySQL Table Design okayapi_server_manage

TOP ↑