okayapi_article_map - MySQ Table Design - OkayAPI.com

+ Use This Table All Design

MySQL Create Table SQL

Table Structure: okayapi_article_map：/tablelist/okayapi_article_map.html


-- MySQL Table okayapi_article_map
-- From: OkayAPI.com
CREATE TABLE `okayapi_article_map` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `tag_id` int(10) NOT NULL DEFAULT '0' COMMENT '标签id',
    `article_id` int(10) NOT NULL DEFAULT '0' COMMENT '文章id',
    KEY `tag_id` (`tag_id`),
    KEY `article_id` (`article_id`),
    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-2 of 2 results.

Field Name	Field Type	Default	IS NULL	Field Comment	Index	Demo Data
tag_id	int(10)	0	否	标签id	Normal Index	0
article_id	int(10)	0	否	文章id	Normal Index	0

Guess You Like

MySQL Table Design okayapi_seo_article

MySQL Table Design okayapi_article_ad

MySQL Table Design okayapi_article_cate

MySQL Table Design okayapi_article_tag

MySQL Table Design okayapi_access

MySQL Table Design okayapi_comment

MySQL Table Design okayapi_document

MySQL Table Design okayapi_function

MySQL Table Design okayapi_login

MySQL Table Design okayapi_moment

MySQL Table Design okayapi_praise

MySQL Table Design okayapi_request

MySQL Table Design okayapi_response

MySQL Table Design okayapi_test_record

MySQL Table Design okayapi_verify

MySQL Table Design okayapi_apijson_privacy

MySQL Table Design okayapi_apijson_user