Database Name: banking Table: accounts Type Null Default acc_type varchar(50) Yes minbalance varchar(20) Yes Table: complaints Field Type Null Default slno int(250) Yes varchar(20) Yes comp_to varchar(50) Yes comp_from varchar(150) Yes subject varchar(750) Yes complaint comp_date datetime Yes Table: customer Field Type Null Default varchar(200) Yes custid first_name varchar(200) Yes last_name varchar(200) Yes age varchar(3) Yes address varchar(200) Yes country varchar(15) Yes email varchar(200) Yes sex varchar(15) Yes contact_number varchar(200) Yes varchar(200) Yes acc_number balance Yes acc_type varchar(200) Yes opendate date Yes Table: found_tran Field Type Null Default deb_acct_no varchar(50) Yes cre_acct_no int(20) Yes date datetime Yes balance int(50) Yes deb_amount int(20) Yes Table: interest
Database Name: banking Table: accounts Type Null Default acc_type varchar(50) Yes minbalance varchar(20) Yes Table: complaints Field Type Null Default slno int(250) Yes comp_to varchar(20) Yes comp_from varchar(50) Yes subject varchar(150) Yes complaint varchar(750) Yes comp_date datetime Yes Table: customer Field Type Null Default custid varchar(200) Yes first_name varchar(200) Yes last_name varchar(200) Yes age varchar(3) Yes address varchar(200) Yes country varchar(15) Yes email varchar(200) Yes sex varchar(15) Yes contact_number varchar(200) Yes acc_number varchar(200) Yes balance Yes acc_type varchar(200) Yes opendate date Yes Table: found_tran Field Type Null Default deb_acct_no varchar(50) Yes cre_acct_no int(20) Yes date datetime Yes balance int(50) Yes deb_amount int(20) Yes Table: interest