+ Use This Table All Design

MySQL Create Table SQL

Table Structure: okayapi_moment:/tablelist/okayapi_moment.html


-- MySQL Table okayapi_moment
-- From: OkayAPI.com
CREATE TABLE `okayapi_moment` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `moment_nickname` varchar(50) NULL COMMENT '用户名',
    `moment_content` varchar(1024) NULL COMMENT '朋友圈内容',
    `moment_createtime` datetime NULL COMMENT '发布时间,默认为当前时间',
    `moment_access` int(3) NULL COMMENT '观看权限,0公开,1登陆可见,2仅自己可见',
    `moment_url` varchar(1024) NULL COMMENT '跳转连接',
    `moment_like` int(10) NULL DEFAULT '0' COMMENT '朋友圈点赞数',
    `moment_picture1` varchar(255) NULL COMMENT '朋友圈图片1',
    `moment_picture2` varchar(255) NULL COMMENT '朋友圈图片2
',
    `moment_picture3` varchar(255) NULL COMMENT '朋友圈图片3',
    `moment_picture4` varchar(255) NULL COMMENT '朋友圈图片4',
    `moment_picture5` varchar(255) NULL COMMENT '朋友圈图片5',
    `moment_picture6` varchar(255) NULL COMMENT '朋友圈图片6',
    `moment_picture7` varchar(255) NULL COMMENT '朋友圈图片7',
    `moment_picture8` varchar(255) NULL COMMENT '朋友圈图片8',
    `moment_picture9` varchar(255) NULL COMMENT '朋友圈图片9',
    `moment_lat` double NULL COMMENT '纬度',
    `moment_lng` double NULL COMMENT '经度',
    `moment_place` varchar(256) NULL COMMENT '位置描述',
    KEY `moment_nickname` (`moment_nickname`),
    KEY `moment_content` (`moment_content`),
    KEY `moment_createtime` (`moment_createtime`),
    KEY `moment_access` (`moment_access`),
    KEY `moment_url` (`moment_url`),
    KEY `moment_like` (`moment_like`),
    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_picture7` (`moment_picture7`),
    KEY `moment_picture8` (`moment_picture8`),
    KEY `moment_picture9` (`moment_picture9`),
    KEY `moment_lat` (`moment_lat`),
    KEY `moment_lng` (`moment_lng`),
    KEY `moment_place` (`moment_place`),
    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-18 of 18 results.
Field NameField TypeDefaultIS NULLField CommentIndexDemo Data
moment_nicknamevarchar(50)用户名
moment_contentvarchar(1024)朋友圈内容
moment_createtimedatetime发布时间,默认为当前时间
moment_accessint(3)观看权限,0公开,1登陆可见,2仅自己可见
moment_urlvarchar(1024)跳转连接
moment_likeint(10)0朋友圈点赞数0
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_picture7varchar(255)朋友圈图片7
moment_picture8varchar(255)朋友圈图片8
moment_picture9varchar(255)朋友圈图片9
moment_latdouble纬度
moment_lngdouble经度
moment_placevarchar(256)位置描述

Guess You Like

MySQL Table Design okayapi_mobile

MySQL Table Design okayapi_qq

MySQL Table Design okayapi_rank

MySQL Table Design okayapi_user

MySQL Table Design okayapi_friend

MySQL Table Design okayapi_qq_login

MySQL Table Design okayapi_lend_book

MySQL Table Design okayapi_charter_car_info

MySQL Table Design okayapi_charter_car_book

TOP ↑