5.7 Database Design and Data Storage

5.7.1 Database Architecture Design

• 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.

5.7.2 Data Storage Solutions

• PostgreSQL: Stores relational data such as user, booking, and payment information.

• MongoDB: Stores semi-structured data such as travel itineraries and user preferences.