@startuml
entity accounts {
  *user_id : INTEGER <<generated>>
  --
  *username : TEXT 
  *userpassword : TEXT
}
entity blog {
  *doc_id : INTEGER <<generated>>
  --
  *doc_title : TEXT 
  *doc_text: TEXT
  *doc_created_time : INTEGER
  *user_id : <<Foreign Key>>
}
entity session {
  *session_id : INTEGER <<generated>>
  --
  *session_hashid : TEXT 
  *user_id : <<Foreign Key>>
}

entity image {
  *image_id : INTEGER <<generated>>
  --
  *image_base64 : TEXT 
  *image_mimetype : TEXT
}



entity blog_image {
  *blog_image : INTEGER <<generated>>
  --
  *doc_id : <<Foreign Key>>
  *image_id : <<Foreign Key>>
}

accounts ||..o{ blog
accounts ||..o{ session
blog_image ||--|| image
blog_image ||--|| blog
@enduml