5.7 Database Design and Data Storage
Last updated
Last updated
Users: Stores user details such as ID, name, email, and membership level.
Bookings: Manages travel bookings including ID, user ID, booking details, and status.
Payments: Records payment transactions including ID, booking ID, amount, currency, and status.
Proposals: Handles proposals and their voting results.
Votes: Manages voting data.
PostgreSQL: Stores relational data such as user, booking, and payment information.
MongoDB: Stores semi-structured data such as travel itineraries and user preferences.