# blog_dev

## Tables

| Name                                        | Columns | Comment | Type       |
| ------------------------------------------- | ------- | ------- | ---------- |
| [articles](articles.md)                     | 13      |         | BASE TABLE |
| [articles_tags](articles_tags.md)           | 2       |         | BASE TABLE |
| [tags](tags.md)                             | 3       |         | BASE TABLE |
| [users](users.md)                           | 6       |         | BASE TABLE |
| [tag_article_counts](tag_article_counts.md) | 4       |         | BASE TABLE |
| [moments](moments.md)                       | 10      |         | BASE TABLE |
| [admin_sessions](admin_sessions.md)         | 8       |         | BASE TABLE |

## Relations

```mermaid
erDiagram

"articles" }o--|| "users" : "Additional Relation"
"moments" }o--|| "users" : "Additional Relation"
"articles_tags" }o--|| "articles" : "Additional Relation"
"articles_tags" }o--|| "tags" : "Additional Relation"
"tag_article_counts" }o--|| "users" : "Additional Relation"
"tag_article_counts" }o--|| "tags" : "Additional Relation"

"articles" {
  char_36_ article_id PK
  char_36_ user_id
}
"articles_tags" {
  char_36_ article_id PK
  char_36_ tag_id PK
}
"tags" {
  char_36_ tag_id PK
}
"users" {
  char_36_ user_id PK
}
"tag_article_counts" {
  char_36_ user_id PK
  varchar_20_ type PK
  char_36_ tag_id PK
}
"moments" {
  char_26_ moment_id PK
  char_36_ user_id
}
"admin_sessions" {
  varchar_64_ sid PK
}
```

---

> Generated by [tbls](https://github.com/k1LoW/tbls)