tag_article_counts

Description

Table Definition

CREATE TABLE `tag_article_counts` (
  `user_id` char(36) NOT NULL,
  `type` varchar(20) NOT NULL,
  `tag_id` char(36) NOT NULL,
  `article_count` bigint NOT NULL DEFAULT '0',
  PRIMARY KEY (`user_id`,`type`,`tag_id`) /*T![clustered_index] CLUSTERED */
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin

Columns

Name	Type	Default	Nullable	Children	Parents	Comment
user_id	char(36)		false		users
type	varchar(20)		false
tag_id	char(36)		false		tags
article_count	bigint	0	false

Constraints

Name	Type	Definition
PRIMARY	PRIMARY KEY	PRIMARY KEY (user_id, type, tag_id)

Indexes

Name	Definition
PRIMARY	PRIMARY KEY (user_id, type, tag_id) USING BTREE

Relations

        erDiagram

"tag_article_counts" }o--|| "users" : "Additional Relation"
"tag_article_counts" }o--|| "tags" : "Additional Relation"

"tag_article_counts" {
  char_36_ user_id PK
  varchar_20_ type PK
  char_36_ tag_id PK
}
"users" {
  char_36_ user_id PK
}
"tags" {
  char_36_ tag_id PK
}
    

---

Generated by tbls