Table Wise Setup Details
हर table का status, row count, important data और column details नीचे card-wise दिखेंगे।
SETUP READY
branches
Rows: 1
Branch Details
ID
1
Branch Name
GAJANAND
Mobile
9636515657
Email
jogaramjat@gmail.com
Company Name
GAJANAND
Created At
2026-06-07 19:02:50
Updated At
Columns
id int(11) NOT NULL PRIname varchar(150) NOT NULLmobile varchar(20) NULLemail varchar(150) NULLaddress varchar(255) NULLcompany_name varchar(150) NULLcompany_gst_no varchar(30) NULLbank_name varchar(120) NULLbank_ifsc varchar(20) NULLbank_account_no varchar(40) NULLupi_name varchar(120) NULLupi_vpa varchar(120) NULLqr_code_url varchar(255) NULLlogo_url varchar(255) NULLcreated_at timestamp NULLupdated_at timestamp NULL
users
Rows: 1
Director User Details
ID
1
Branch ID
1
Name
PRITHVIRAJ
Email
jogaramjat@gmail.com
Mobile
9636515657
Role
DIRECTOR
Team Type
none
Enabled
1
Company Branch
my_company
Created At
2026-06-07 19:02:50
Columns
id int(11) NOT NULL PRIbranch_id int(11) NULLname varchar(150) NOT NULLemail varchar(190) NOT NULL UNImobile varchar(20) NULLaddress varchar(255) NULLcompany_other varchar(60) NULLteam_type varchar(20) NOT NULLis_enabled tinyint(1) NOT NULLpassword_hash varchar(255) NULLpassword varchar(255) NULLcompany_branch varchar(30) NULLcreated_at timestamp NULL
control_settings
Rows: 3
Default Control Rows For Branch
| ID | Branch ID | Key | Label | Type | Value | Updated |
|---|---|---|---|---|---|---|
| 1 | 1 | a0001 | YES/NO | toggle | on | 2026-06-07 19:02:50 |
| 2 | 1 | select_ledger001 | Ledger | select-ledger | 2026-06-07 19:02:50 | |
| 3 | 1 | destop_chart_show_id | DESTOP CHART SHOW/HIDE | toggle | on | 2026-06-07 19:02:50 |
Columns
id int(11) NOT NULL PRIbranch_id int(11) NOT NULL MULsetting_key varchar(120) NOT NULL MULsetting_label varchar(200) NOT NULLsetting_type varchar(60) NOT NULLsetting_value text NOT NULLupdated_at datetime NOT NULL
send_mail_control
Rows: 2
SMTP Setup Rows
| ID | Host | SMTP User | SMTP Pass | Port | From | Name | Active | Updated |
|---|---|---|---|---|---|---|---|---|
| 1 | smtp.gmail.com | onlinemap515657@gmail.com | aj************mt | 587 | onlinemap515657@gmail.com | GAJANAND | YES | 2026-04-23 12:15:04 |
| 4 | smtp.hostinger.com | barmeresolution@jogaram.in | 5!******Xp | 465 | barmeresolution@jogaram.in | JOGARAM | NO | 2026-04-23 12:15:10 |
Columns
id int(11) NOT NULL PRIsmtp_host varchar(255) NOT NULLsmtp_user varchar(255) NOT NULLsmtp_pass varchar(255) NOT NULLsmtp_port int(11) NOT NULLsmtp_from varchar(255) NOT NULLsmtp_name varchar(255) NOT NULLis_active enum('YES','NO') NOT NULLcreated_at datetime NOT NULLupdated_at datetime NOT NULL