Database Connection Test

Host: localhost

Database: u396525652_raghu32

User: u396525652_Nath

Success: Connected to the database!

Tables in database:

Table: expenses

• id (varchar(50))
• category (varchar(100))
• loanId (varchar(50))
• title (varchar(255))
• amount (decimal(15,2))
• date (date)
• description (varchar(255))
• createdAt (timestamp)

Table: income

• id (varchar(50))
• projectId (varchar(50))
• projectName (varchar(255))
• amount (decimal(15,2))
• type (varchar(50))
• date (date)
• paymentMode (varchar(50))
• notes (text)
• createdAt (timestamp)

Table: loans

• id (varchar(50))
• name (varchar(255))
• loanType (enum('Personal Loan','Credit Card Loan','Business Loan','Other'))
• totalAmount (decimal(15,2))
• paidAmount (decimal(15,2))
• monthlyEMI (decimal(15,2))
• dueDate (int(11))
• remark (text)
• isImportant (tinyint(1))
• durationMonths (int(11))
• createdAt (timestamp)

Table: projects

• id (varchar(50))
• name (varchar(255))
• clientName (varchar(255))
• clientMobile (varchar(20))
• duration (varchar(100))
• originalCost (decimal(15,2))
• extraAmount (decimal(15,2))
• totalBilling (decimal(15,2))
• totalAmount (decimal(15,2))
• status (enum('active','completed','on-hold'))
• notes (text)
• createdAt (timestamp)

Update Database Schema (Run Init)Seed Demo Data