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 Name | Field Type | Default | IS NULL | Field Comment | Index | Demo Data |
---|---|---|---|---|---|---|
tea_titlepage | varchar(255) | 是 | 茶封面 | |||
tea_picture1 | varchar(255) | 是 | 茶轮播照片1 | |||
tea_picture2 | varchar(255) | 是 | 茶轮播照片2 | |||
tea_picture3 | varchar(255) | 是 | 茶轮播照片3 | |||
tea_tag | varchar(255) | 是 | 茶的标签(热门,包邮,紧张等) | |||
tea_specification | varchar(255) | 是 | 茶的规格 | |||
tea_presentation_img1 | varchar(255) | 是 | 茶的商品描述图片1 | |||
tea_presentation_img2 | varchar(255) | 是 | 茶的商品描述图片2 | |||
tea_presentation_img3 | varchar(255) | 是 | 茶的商品描述图片3 | |||
tea_presentation_img4 | varchar(255) | 是 | 茶的商品描述图片4 | |||
tea_presentation_img5 | varchar(255) | 是 | 茶的商品描述图片5 | |||
tea_presentation_img6 | varchar(255) | 是 | 茶的商品描述图片6 | |||
tea_presentation_img7 | varchar(255) | 是 | 茶的商品描述图片7 | |||
tea_presentation_img8 | varchar(255) | 是 | 茶的商品描述图片8 | |||
tea_presentation_img9 | varchar(255) | 是 | 茶的商品描述图片9 | |||
tea_name | varchar(255) | 否 | 茶名 | |||
tea_desc | varchar(255) | 是 | 茶描述 | |||
tea_price | varchar(255) | 否 | 茶价格 |