> For the complete documentation index, see [llms.txt](https://xwalk.gitbook.io/xwalk-white-book/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://xwalk.gitbook.io/xwalk-white-book/technical-architecture/5.7-database-design-and-data-storage.md).

# 5.7 Database Design and Data Storage

<figure><img src="https://419328827-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FNzy3HAdLeUAtfs6zYBo4%2Fuploads%2FD7ZhhX52cwDtQDb9SuLP%2Fimage.png?alt=media&amp;token=9420e1f2-04f5-43cd-89b5-e03d81d70df5" alt=""><figcaption></figcaption></figure>

### **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.