blog_dev

Tables

Name	Columns	Type
articles	13	BASE TABLE
articles_tags	2	BASE TABLE
tags	3	BASE TABLE
users	6	BASE TABLE
tag_article_counts	4	BASE TABLE
moments	10	BASE TABLE
admin_sessions	8	BASE TABLE

Relations

        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