4GeeksAcademy / pt66-crypto-sense

A Crypto Portfolio Tracker that allows users to manage their cryptocurrency investments and track the value of their holdings in real-time.
MIT License
5 stars 5 forks source link

[BE] Create DB Model for the application. #16

Closed d-chobotar closed 1 month ago

d-chobotar commented 1 month ago

Image

d-chobotar commented 1 month ago

The data model:

User
-----
id PK int FK >- Favorite.user_id
first_name string
last_name string
email string
username string
password string
favorite_coins [string] FK >- Favorite.coin_id

Favorite
-----
id PK int
user_id FK int
coin_id string