okayapi_wp_term_taxonomy

MySQL Create Table SQL

Table Structure: okayapi_wp_term_taxonomy：/tablelist/okayapi_wp_term_taxonomy.html


-- MySQL Table okayapi_wp_term_taxonomy
-- From: OkayAPI.com
CREATE TABLE `okayapi_wp_term_taxonomy` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `term_taxonomy_id` bigint(20) NOT NULL COMMENT '',
    `term_id` bigint(20) NOT NULL DEFAULT '0' COMMENT '',
    `taxonomy` varchar(32) NOT NULL COMMENT '',
    `description` longtext NOT NULL COMMENT '',
    `parent` bigint(20) NOT NULL DEFAULT '0' COMMENT '',
    `count` bigint(20) NOT NULL DEFAULT '0' COMMENT '',
    KEY `term_taxonomy_id` (`term_taxonomy_id`),
    KEY `term_id` (`term_id`),
    KEY `taxonomy` (`taxonomy`),
    KEY `description` (`description`),
    KEY `parent` (`parent`),
    KEY `count` (`count`),
    PRIMARY KEY (`id`)
) ENGINE=InnoDB COMMENT 'WordPress-条款分类';

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

MySQL database table structure design

Displaying 1-6 of 6 results.

Field Name	Field Type	Default	IS NULL	Index	Demo Data
term_taxonomy_id	bigint(20)		否
term_id	bigint(20)	0	否	Normal Index	0
taxonomy	varchar(32)		否	Normal Index
description	longtext		否
parent	bigint(20)	0	否		0
count	bigint(20)	0	否		0

Guess You Like

MySQL Table Design okayapi_wp_commentmeta

MySQL Create Table SQL

MySQL database table structure design

Guess You Like

MySQL Table Design okayapi_wp_commentmeta

MySQL Table Design okayapi_wp_comments

MySQL Table Design okayapi_wp_links

MySQL Table Design okayapi_wp_options

MySQL Table Design okayapi_wp_postmeta

MySQL Table Design okayapi_wp_posts

MySQL Table Design okayapi_wp_term_relationships

MySQL Table Design okayapi_wp_termmeta

MySQL Table Design okayapi_wp_terms

MySQL Table Design okayapi_wp_usermeta

MySQL Table Design okayapi_wp_users