+ Use This Table All Design

MySQL Create Table SQL

Table Structure: okayapi_tea:/tablelist/okayapi_tea.html


-- MySQL Table okayapi_tea
-- From: OkayAPI.com
CREATE TABLE `okayapi_tea` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `tea_titlepage` varchar(255) NOT NULL COMMENT '茶封面',
    `tea_picture1` varchar(255) NOT NULL COMMENT '茶轮播照片1',
    `tea_picture2` varchar(255) NOT NULL COMMENT '茶轮播照片2',
    `tea_picture3` varchar(255) NOT NULL COMMENT '茶轮播照片3',
    `tea_tag` varchar(255) NOT NULL COMMENT '茶的标签(热门,包邮,紧张等)',
    `tea_specification` varchar(255) NOT NULL COMMENT '茶的规格	',
    `tea_presentation_img1` varchar(255) NOT NULL COMMENT '茶的商品描述图片1	',
    `tea_presentation_img2` varchar(255) NOT NULL COMMENT '茶的商品描述图片2	',
    `tea_presentation_img3` varchar(255) NOT NULL COMMENT '茶的商品描述图片3	',
    `tea_presentation_img4` varchar(255) NOT NULL COMMENT '茶的商品描述图片4	',
    `tea_presentation_img5` varchar(255) NOT NULL COMMENT '茶的商品描述图片5	',
    `tea_presentation_img6` varchar(255) NOT NULL COMMENT '茶的商品描述图片6	',
    `tea_presentation_img7` varchar(255) NOT NULL COMMENT '茶的商品描述图片7	',
    `tea_presentation_img8` varchar(255) NOT NULL COMMENT '茶的商品描述图片8	',
    `tea_presentation_img9` varchar(255) NOT NULL COMMENT '茶的商品描述图片9	',
    `tea_name` varchar(255) NOT NULL COMMENT '茶名',
    `tea_desc` varchar(255) NOT NULL COMMENT '茶描述',
    `tea_price` varchar(255) NOT NULL COMMENT '茶价格',
    KEY `tea_titlepage` (`tea_titlepage`),
    KEY `tea_picture1` (`tea_picture1`),
    KEY `tea_picture2` (`tea_picture2`),
    KEY `tea_picture3` (`tea_picture3`),
    KEY `tea_tag` (`tea_tag`),
    KEY `tea_specification` (`tea_specification`),
    KEY `tea_presentation_img1` (`tea_presentation_img1`),
    KEY `tea_presentation_img2` (`tea_presentation_img2`),
    KEY `tea_presentation_img3` (`tea_presentation_img3`),
    KEY `tea_presentation_img4` (`tea_presentation_img4`),
    KEY `tea_presentation_img5` (`tea_presentation_img5`),
    KEY `tea_presentation_img6` (`tea_presentation_img6`),
    KEY `tea_presentation_img7` (`tea_presentation_img7`),
    KEY `tea_presentation_img8` (`tea_presentation_img8`),
    KEY `tea_presentation_img9` (`tea_presentation_img9`),
    KEY `tea_name` (`tea_name`),
    KEY `tea_desc` (`tea_desc`),
    KEY `tea_price` (`tea_price`),
    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
tea_titlepagevarchar(255)茶封面
tea_picture1varchar(255)茶轮播照片1
tea_picture2varchar(255)茶轮播照片2
tea_picture3varchar(255)茶轮播照片3
tea_tagvarchar(255)茶的标签(热门,包邮,紧张等)
tea_specificationvarchar(255)茶的规格
tea_presentation_img1varchar(255)茶的商品描述图片1
tea_presentation_img2varchar(255)茶的商品描述图片2
tea_presentation_img3varchar(255)茶的商品描述图片3
tea_presentation_img4varchar(255)茶的商品描述图片4
tea_presentation_img5varchar(255)茶的商品描述图片5
tea_presentation_img6varchar(255)茶的商品描述图片6
tea_presentation_img7varchar(255)茶的商品描述图片7
tea_presentation_img8varchar(255)茶的商品描述图片8
tea_presentation_img9varchar(255)茶的商品描述图片9
tea_namevarchar(255)茶名
tea_descvarchar(255)茶描述
tea_pricevarchar(255)茶价格

Guess You Like

MySQL Table Design okayapi_logs

MySQL Table Design okayapi_app_version

MySQL Table Design okayapi_tea_swiper

MySQL Table Design okayapi_tea_moment

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 ↑