this is an extension of assignment 5.3.
design and create a set of database tables to contain an address book using the specifications from the assignment and add the information you already used using sql queries.
design and create a set of database tables for a microblogging platform (think mastodon, threads or twitter).
you'll need users with ids, names, multiple emails, hashed passwords, active status, verification codes, verified status and handles along with public/private status.
you'll need posts with ids created by users with date/time stamps and flagged status for policy violations.
posts should be able to be replies of other posts so they'll need parent ids, too.
design and create a set of database tables for a weather forecasting platform.
you'll need administrative users with ids, emails, hashed passwords, active status and ability classes.
you'll need locations with ids, names, regions, countries, latitudes and longitudes and active status.
regions and countries will also need to have names and ids, regions having countries.
forecasts will need ids, dates for weather, dates for last updated, locations and contents. (assume weather forecasts are just strings of text for the moment.)