okayapi_xwx_book - MySQ Table Design

MySQL Create Table SQL

Table Structure: okayapi_xwx_book：/tablelist/okayapi_xwx_book.html


-- MySQL Table okayapi_xwx_book
-- From: OkayAPI.com
CREATE TABLE `okayapi_xwx_book` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `book_name` varchar(100) NULL COMMENT '',
    `create_time` int(11) NULL DEFAULT '0' COMMENT '',
    `last_time` int(11) NULL DEFAULT '0' COMMENT '',
    `category_id` int(10) NULL DEFAULT '0' COMMENT '',
    `tags` varchar(100) NULL COMMENT '',
    `summary` text NULL COMMENT '',
    `okayapi_xwx_book_end` tinyint(4) NULL DEFAULT '-1' COMMENT '',
    `author_id` int(11) NULL COMMENT '',
    `src` varchar(50) NULL COMMENT '',
    KEY `book_name` (`book_name`),
    KEY `create_time` (`create_time`),
    KEY `last_time` (`last_time`),
    KEY `category_id` (`category_id`),
    KEY `tags` (`tags`),
    KEY `summary` (`summary`),
    KEY `okayapi_xwx_book_end` (`okayapi_xwx_book_end`),
    KEY `author_id` (`author_id`),
    KEY `src` (`src`),
    PRIMARY KEY (`id`)
) ENGINE=InnoDB COMMENT 'xiaoshuo小说-小说';

After replication, you can go to the database to create the database table.

MySQL database table structure design

Displaying 1-9 of 9 results.

Field Name	Field Type	Default	IS NULL	Index	Demo Data
book_name	varchar(100)		否
create_time	int(11)	0	是	Normal Index	0
last_time	int(11)	0	是		0
category_id	int(10)	0	是	Normal Index	0
tags	varchar(100)		是	Normal Index
summary	text		是
okayapi_xwx_book_end	tinyint(4)	-1	是		-1
author_id	int(11)		否	Normal Index
src	varchar(50)		是