+--------------------+        +--------------------------+        +--------------------------+
|   User             |        | Chatbot Interface        |        |  Backend Application     |
| (Healthcare Staff) |        |     (Frontend)           |        |         (API)            |
+---------+----------+        +------------+-------------+        +-----------+--------------+
          |                                |                                   |
          | Send question (e.g., patient X)|                                   |
          +------------------------------->|                                   |
                                           |  Send user question               |
                                           +----------------------------+      |
                                                                            v
                                             +-------------------------------+  |
                                             |   Embedding Model (Local)     |  |
                                             +-------------------------------+  |
                                             | Convert to Query Embedding     |
                                             | Return Query Vector            |
                                             +---------------+---------------+  |
                                                             |                  |
                                                             v                  |
                                      +-------------------------------------+   |
                                      |       Vector Database (Local)       |   |
                                      +-------------------------------------+   |
                                      | Search for similar chunks           |   |
                                      | Return relevant chunks (context)    |   |
                                      +-------------------------------------+   |
                                                             |                  |
                                                             v                  |
                                           +-------------------------------+    |
                                           | Local LLM (e.g., Mistral 7B)  |    |
                                           +-------------------------------+    |
                                           | Generate SQL Query using      |    |
                                           | question + retrieved context  |    |
                                           +-------------------------------+    |
                                                             |                  |
                                                             v                  |
                                                +------------------------+      |
                                                | Main Database (Postgre)|<-----+
                                                |      Execute SQL       |
                                                +-----------+------------+
                                                            |
                                                            v
                                           +-------------------------------+
                                           | Return SQL Result             |
                                           +-------------------------------+
                                                             |
                                                             v
+--------------------+        +--------------------------+  |
|   User             |<-------+ Chatbot Interface        |<--+
| (Healthcare Staff) |        |     (Frontend)           |
+--------------------+        +--------------------------+
Create flowchart 
requirement: graph style to easily see blocks.