Mfund documentation
  • Introduction
  • Setup Guidelines
    • Mfund Flutter App
    • Mfund Backend
  • Technology Used
  • Architecture
  • Database Structure
  • App Flow
    • Dashboard App Flow
    • User App Flow
  • Backend Flow
  • API Documentation
    • Dashboard APIs
    • App APIs
  • Screens
    • App Screens
      • Login Screen
      • Signup Screen
      • KYC Screen
      • Home Screen
      • Investment Screen
      • Profile Screen
      • Withdraw Screen
    • Dashboard Screens
      • Login Screen
      • Home Screen
      • Investment Plan Screen
      • Investors Screen
      • Balances Screen
      • Transaction Details Screen
      • Settings Screen
      • App Bar
Powered by GitBook
On this page

Was this helpful?

Database Structure

PreviousArchitectureNextApp Flow

Last updated 4 years ago

Was this helpful?

PostgreSQL is a powerful, open source object-relational database system with over 30 years of active development that has earned it a strong reputation for reliability, feature robustness, and performance.

PostgreSQL has earned a strong reputation for its proven architecture, reliability, data integrity, robust feature set, extensibility, and the dedication of the open source community behind the software to consistently deliver performant and innovative solutions. PostgreSQL runs on , has been -compliant since 2001.

PostgreSQL comes with aimed to help developers build applications, administrators to protect data integrity and build fault-tolerant environments, and help you manage your data no matter how big or small the dataset. In addition to being , PostgreSQL is highly extensible.

Tables

  • users Table - This table keeps track of all the signed up user. Data in usersupdates as the user complete his/her KYC.

``

  • bank_details Table - This table has one-to-one relation with users table and keep bank details of a particular user.

``

  • driving_license Table - This table store Driving license data of the user for KYC purpose.

``

  • organisations Table - This table container data of Investment Firms/ Organisations and their SIP rates and NAV values. It also container previous NAV values for each firms to show as a chart in flutter app.

``

  • investments Table - This **table contains data related to investments made by users in different firms.

``

  • withdraws Table - This table contains data of all the withdraw request made by the users.

all major operating systems
ACID
many features
free and open source
User Table Structure
Bank Details Table Structure
Driving License Table Structure
Organisations / Firms Table Structure
Investment Table Structure
Withdraw Table Structure