todo application
1.11.4
PostgreSQL 13.3
@startuml ERDiagram
title todo-app diagram
entity "users" {
+ id [PK]
==
* uuid:varchar(255)
name:varchar(255)
email:varchar(255)
password:varchar(255)
created_at:timestamp
updated_at:timestamp
deleted_at:timestamp
is_deleted:boolean
}
entity "todos" {
+ id [PK]
==
# user_id [FK(users,id)]
content:text
created_at:timestamp
updated_at:timestamp
is_deleted:boolean(default:false)
deleted_at:timestamp
}
entity "sessions" {
+ id [PK]
==
# user_id [FK(users,id)]
* uuid:varchar(255)
email:varchar(255)
created_at:timestamp
updated_at:timestamp
}
users --o{ todos
users --|{ sessions
@enduml