Schema compare: tenant_bgi vs tenant_bgi_v2

Table presence

TableIn tenant_bgiIn tenant_bgi_v2
accounting_club✔✔
accounting_house✔✔
accounting_journalentry✔✔
accounting_journalline✔✔
accounting_ledgergroup✔✔
accounting_ledgergroup_old✔—
accounting_statemaster✔✔
accounting_subject✔✔
accounting_transportroute✔✔
cash_payment_voucher✔✔
cash_receipt_voucher✔✔
cast_category✔✔
class_fund✔✔
class_info✔✔
customer_receipt✔✔
date_master✔✔
department✔✔
django_migrations✔✔
firm✔✔
firm_gstin✔✔
fund_master✔✔
journel_voucher✔✔
ledger_master✔✔
route_master✔✔
section✔✔
staff_info✔✔
student✔✔
student_left_period✔✔
tenant_admin_log✔✔
transactions✔✔

Column-level differences

accounting_ledgergroup_old — table missing in one DB

Table: class_info

Columntenant_bgitenant_bgi_v2
ledger_id{"Type":"bigint(20)","Null":"YES","Key":"","Default":null,"Extra":""}{"Type":"bigint(20)","Null":"NO","Key":"","Default":null,"Extra":""}
class_not_in_use{"Type":"tinyint(1)","Null":"YES","Key":"","Default":null,"Extra":""}{"Type":"tinyint(1)","Null":"NO","Key":"","Default":null,"Extra":""}

Table: ledger_master

Columntenant_bgitenant_bgi_v2
opening_balance{"Type":"decimal(10,2)","Null":"NO","Key":"","Default":null,"Extra":""}{"Type":"double","Null":"NO","Key":"","Default":null,"Extra":""}
opening_type{"Type":"varchar(10)","Null":"YES","Key":"","Default":null,"Extra":""}missing
created_at{"Type":"timestamp(6)","Null":"NO","Key":"","Default":"0000-00-00 00:00:00.000000","Extra":"on update current_timestamp(6)"}{"Type":"datetime(6)","Null":"NO","Key":"","Default":null,"Extra":""}
current_balance{"Type":"decimal(10,2)","Null":"NO","Key":"","Default":"0.00","Extra":""}missing
current_balance_type{"Type":"varchar(10)","Null":"YES","Key":"","Default":null,"Extra":""}missing
closing_balance{"Type":"decimal(10,2)","Null":"NO","Key":"","Default":"0.00","Extra":""}{"Type":"double","Null":"NO","Key":"","Default":null,"Extra":""}
closing_type{"Type":"varchar(10)","Null":"YES","Key":"","Default":null,"Extra":""}missing
credit_limit{"Type":"decimal(10,2)","Null":"NO","Key":"","Default":null,"Extra":""}{"Type":"double","Null":"NO","Key":"","Default":null,"Extra":""}
date_id{"Type":"int(11)","Null":"NO","Key":"MUL","Default":"0","Extra":""}{"Type":"int(11)","Null":"NO","Key":"MUL","Default":null,"Extra":""}

Table: route_master

Columntenant_bgitenant_bgi_v2
amount{"Type":"decimal(10,2)","Null":"YES","Key":"","Default":null,"Extra":""}{"Type":"decimal(10,2)","Null":"NO","Key":"","Default":null,"Extra":""}

Table: student

Columntenant_bgitenant_bgi_v2
ledger_id{"Type":"bigint(20)","Null":"NO","Key":"MUL","Default":null,"Extra":""}{"Type":"bigint(20)","Null":"NO","Key":"","Default":null,"Extra":""}
roll_no{"Type":"varchar(50)","Null":"NO","Key":"MUL","Default":null,"Extra":""}{"Type":"varchar(50)","Null":"NO","Key":"UNI","Default":null,"Extra":""}
dob{"Type":"date","Null":"YES","Key":"","Default":null,"Extra":""}{"Type":"date","Null":"NO","Key":"","Default":null,"Extra":""}
age_years{"Type":"int(11)","Null":"YES","Key":"","Default":null,"Extra":""}missing
age_months{"Type":"int(11)","Null":"YES","Key":"","Default":null,"Extra":""}missing
age_days{"Type":"int(11)","Null":"YES","Key":"","Default":null,"Extra":""}missing
bus_charge{"Type":"decimal(10,2)","Null":"YES","Key":"","Default":null,"Extra":""}missing
created_at{"Type":"datetime","Null":"NO","Key":"","Default":"current_timestamp()","Extra":""}{"Type":"datetime(6)","Null":"NO","Key":"","Default":null,"Extra":""}
club_id{"Type":"bigint(20)","Null":"NO","Key":"MUL","Default":null,"Extra":""}missing
house_id{"Type":"bigint(20)","Null":"NO","Key":"MUL","Default":null,"Extra":""}missing