Database

• User has 1 portfolio website
• Portfolio website has multiple sections, links to sections also in navigation
• Section has 1 heading and 1 layout component (grid/image gallery/video gallery/side-scroller)
• Layout component has multiple items (images, text, columns, rows)

RDS Postgresql database is split into 4 tables:

users table has all of the verified users.

pending_users table has all of the unverified users.

sections table has all of the user created portfolio sections.

components table has all of the components that users have created in their sections.

Best practices on storing large dataobjects in database: https://www.youtube.com/watch?v=OxNxheQkFTc

AWS Amplify tutorial: https://amplify-sns.workshop.aws/en/00_prerequisites.html

Create postgresql database https://aws.amazon.com/getting-started/hands-on/create-connect-postgresql-db/

• Different DB for media items and other stuff RDS Postgres