====== Introduction: ======


The Modules table is used to store information about different modules available in the system. Each entry represents a module, including its unique identifier, associated client, hierarchy, appearance, and status. This table plays a crucial role in organizing and managing modules in the system, ensuring that they are displayed and function correctly in both the backend and front-end application.


^**Sr. No.** ^ **Name**                 ^ **Type**            ^ **Comments **                                                                                        ^
|1| **id**                   | Primary         | ID of the module (auto-incremented).                                                             |
|2| **clientid**            | Index           | ID of the client associated with the module.                                                    |
|3| **modulename**           | varchar(50)     | Name of the module.                                                                               |
|4| **parentmoduleid**       | int             | ID of the parent module, if this module is a submodule of another module.                       |
|5| **defaultmodule**        | int             | Indicates if this is the default module. 1=default, 0=not default.                              |
|6| **dependentmodules**     | varchar(200)    | Comma-separated list of module IDs that are dependent on this module to form the overall module. |
|7| **ord**                  | int             | The order in which the module should appear, typically used for sorting modules.                 |
|8| **modulelogo**           | blob            | Stores the logo of the module, in binary format (image).                                         |
|9| **appiconname**          | varchar(250)    | Stores the image name used to display the module's icon on the app's module screen.              |
|10| **status**               | int             | Indicates the module's status. 1=active, 0=inactive.                                            |