ERD

Jump to bottom

chaeeun037 edited this page Jul 28, 2021 · 6 revisions

user
-
id int PK
access_token varchar
email varchar unique
name varchar
avatar_url varchar


category
-
id int PK
user_id int FK >- user.id
name varchar
color varchar

payment
-
id int PK
user_id int FK >- user.id
name varchar

cash_history
-
id int PK
category_id int FK >- category.id
user_id int FK >- user.id
payment_id int FK >- payment.id
price int
type enum
created_at datetime