+ Use This Table All Design

MySQL Create Table SQL

Table Structure: okayapi_tea_moment:/tablelist/okayapi_tea_moment.html


-- MySQL Table okayapi_tea_moment
-- From: OkayAPI.com
CREATE TABLE `okayapi_tea_moment` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `moment_headimg` varchar(255) NOT NULL COMMENT '用户头像',
    `moment_place` varchar(255) NOT NULL COMMENT '位置描述',
    `moment_lng` varchar(255) NOT NULL COMMENT '经度',
    `moment_lat` varchar(255) NOT NULL COMMENT '纬度',
    `moment_picture1` varchar(255) NOT NULL COMMENT '朋友圈图片1',
    `moment_picture2` varchar(255) NOT NULL COMMENT '朋友圈图片2',
    `moment_picture3` varchar(255) NOT NULL COMMENT '朋友圈图片3',
    `moment_picture4` varchar(255) NOT NULL COMMENT '朋友圈图片4',
    `moment_picture5` varchar(255) NOT NULL COMMENT '朋友圈图片5',
    `moment_picture6` varchar(255) NOT NULL COMMENT '朋友圈图片6',
    `moment_like` int(10) NOT NULL COMMENT '朋友圈点赞数	',
    `moment_createtime` varchar(255) NOT NULL COMMENT '发布时间,默认为当前时间	',
    `moment_content` varchar(1024) NOT NULL COMMENT '朋友圈内容	',
    `moment_nickname` varchar(50) NOT NULL COMMENT '	用户名',
    KEY `moment_headimg` (`moment_headimg`),
    KEY `moment_place` (`moment_place`),
    KEY `moment_lng` (`moment_lng`),
    KEY `moment_lat` (`moment_lat`),
    KEY `moment_picture1` (`moment_picture1`),
    KEY `moment_picture2` (`moment_picture2`),
    KEY `moment_picture3` (`moment_picture3`),
    KEY `moment_picture4` (`moment_picture4`),
    KEY `moment_picture5` (`moment_picture5`),
    KEY `moment_picture6` (`moment_picture6`),
    KEY `moment_like` (`moment_like`),
    KEY `moment_createtime` (`moment_createtime`),
    KEY `moment_content` (`moment_content`),
    KEY `moment_nickname` (`moment_nickname`),
    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-14 of 14 results.
Field NameField TypeDefaultIS NULLField CommentIndexDemo Data
moment_headimgvarchar(255)用户头像
moment_placevarchar(255)位置描述
moment_lngvarchar(255)经度
moment_latvarchar(255)纬度
moment_picture1varchar(255)朋友圈图片1
moment_picture2varchar(255)朋友圈图片2
moment_picture3varchar(255)朋友圈图片3
moment_picture4varchar(255)朋友圈图片4
moment_picture5varchar(255)朋友圈图片5
moment_picture6varchar(255)朋友圈图片6
moment_likeint(10)朋友圈点赞数
moment_createtimevarchar(255)发布时间,默认为当前时间
moment_contentvarchar(1024)朋友圈内容
moment_nicknamevarchar(50) 用户名

Guess You Like

MySQL Table Design okayapi_logs

MySQL Table Design okayapi_app_version

MySQL Table Design okayapi_tea

MySQL Table Design okayapi_tea_swiper

MySQL Table Design okayapi_tea_order

MySQL Table Design okayapi_tea_user

MySQL Table Design okayapi_tea_shopcar

MySQL Table Design okayapi_zheng_cms_article

MySQL Table Design okayapi_zheng_cms_article_category

MySQL Table Design okayapi_zheng_cms_article_tag

MySQL Table Design okayapi_zheng_cms_category

MySQL Table Design okayapi_zheng_cms_comment

MySQL Table Design okayapi_zheng_cms_page

MySQL Table Design okayapi_zheng_cms_setting

MySQL Table Design okayapi_zheng_cms_system

MySQL Table Design okayapi_zheng_cms_tag

MySQL Table Design okayapi_zheng_cms_topic

MySQL Table Design okayapi_zheng_pay_in_order

MySQL Table Design okayapi_zheng_pay_in_order_detail

MySQL Table Design okayapi_zheng_pay_mch

TOP ↑