search

nathanielfernandes / cps630-project

4 stars 0 forks source link

database schema #5

Closed nathanielfernandes closed 4 months ago

nathanielfernandes commented 5 months ago

we need to layout how our database will look

Task:

maxpiorischin commented 4 months ago

Schema is designed and can be viewed in the "Schema visualizer" tab in the database.

Overview:

Tables

Main "posts" table containing all the existing posts.

Three child tables to the posts table: items wanted, items for sale, academic services. This was created since these three typings will share many similar fields, but may also have unique fields related to their specific type of post.

Images table, storing an image linking to the post.

These tables use foreign keys to all be linked to each other, while maintaining individuality by having dedicated fields (no transitive dependencies yay) (bcnf :3)

Image

Other

Functions: Created functions to streamline creating data in the database, making it easy to insert rows.