Backend Meeting 1.3 - bounswe/bounswe2022group5 GitHub Wiki

Meeting Information

Date 13/11/2022 22:00 - 23:00
Platform Discord
Note Taker - Reviewer Alper Canberk Balcı - Irfan Bozkurt

Participants

  • Alper Canberk Balcı
  • İrfan Bozkurt
  • Mehmet Emre Akbulut
  • Oğuzhan Demirel

Description

Agenda

  • Deciding on the table structure of the database (decided as PostgreSQL)

Discussion

  • Additional entities to the database are: Post, Comment, PostImage, CommentImage.
  • We can add an ER Diagram painted by DBeaver.
New Tables

post:

- id (pk)
- body
- date
- upvote
- downvote
- author (user) (fk)

comment:

- id (pk)
- title
- body
- date
- upvote
- downvote
- author (user) (fk)

post_image:

- id (pk)
- image_url
- post (post) (fk)

comment_image:

- id (pk)
- image_url
- comment (comment) (fk)

Next Meeting Info

Date 15/11/2022 15:00 - 17:00
Platform LAB BM4
⚠️ **GitHub.com Fallback** ⚠️