Database ER - Githubissues

behzadshomali / Image-Describe-Pipe

This app outputs the name, coordinations, sentiment of each extracted face, and besides a brief description of the scene's context for each input image.

2 stars 0 forks source link

Database ER #4

Closed behroozomidvar closed 3 years ago

behroozomidvar commented 3 years ago

After #3 is done.

[x] Determine the concepts / tables.
[x] Determine the attributes and their types.
[x] Determine the relations / keys (primary and foreign).
[x] Draw ER.
[ ] Determine necessary indexes.

behzadshomali commented 3 years ago

@behroozomidvar here is the early version of the ER diagram:

we will certainly add further needed features over time.

behzadshomali commented 3 years ago

@behroozomidvar the tables and their corresponding attributes are as follows:

users

* full_name (VARCHAR) * email (VARCHAR) PRIMARY KEY * age (INTEGER) * lastLogin (DATE) * password (VARCHAR)

images

* image_id (SERIAL) PRIMARY KEY * user_email (VARCHAR) FOREIGN KEY REFERENCES users(email) * image_url (VARCHAR)

logs

* log_id (VARCHAR) PRIMARY KEY * user_email (VARCHAR) FOREIGN KEY REFERENCES users(email) * action (VARCHAR) * date (DATE)

what do you think about the aformentioned tables? what can we add to our database?

behzadshomali commented 3 years ago

@behroozomidvar I just created a basic database using PostgreSQL. I just doubt if I should upload it on GitHub. What I should I do?

behroozomidvar commented 3 years ago

The ER and the schema look great. Great work. 🚀🚀

Usually, the DB stays local, until we buy a host for testing and release. For future local tests, you'll send a SQL dump to me via Google Drive or Dropbox and I build the DB on my local.