Build a MyGram Application

Description

MyGram application is a back end application that aims to store photos, make comments on other people's photos like social media.

Requirements

• This project uses Sequelize ORM with Postgresql database.
• MyGram uses libraries/packages including jsonwebtoken, bcypt, dotenv, express, sequelize, sequelize-cli, and pg.
• Each user can only CRUD (Create, Read, Update, Delete) their own data.
• Endpoints to access data in the table must go through an authentication process first, and the authentication process uses JsonWebToken.
• endpoints to modify ownership data such as update or delete first through an authorization process.
• The following are the tables and fields in this project:

User

id (Primary Key)

full_name (String/varchar)

username (String/varchar)

password (String/varchar)

profile_image_url (String/varchar)

age (Number/integer)

phone_number (Number/integer)

createdAt (Date)

updatedAt (Date)

Photo

id (Primary Key)

title (String/varchar)

caption (Text)

posterr_image_url (Text)

UsedId (Foreign Key of User Table)

createdAt (Date)

updatedAt (Date)

Comment

id (Primary Key)

UsedId (Foreign Key of User Table)

PhotoId (Foreign Key of Photo Table)

comment (Text)

createdAt (Date)

updatedAt (Date)

SocialMedia

id (Primary Key)

name (String/varchar)

social_media_url (String/Text)

UserId (Foreign Key of User Table)