FreeStudentProjects
FreeStudentProjects
Database Name: banking
Table: accounts
|
Field |
Type | Null | Default |
| acc_type | varchar(50) | Yes | |
| minbalance | varchar(20) | Yes |
|
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 |
|
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 | |
| varchar(200) | Yes | ||
| sex | varchar(15) | Yes | |
| contact_number | varchar(200) | Yes | |
| acc_number | varchar(200) | Yes | |
| balance | float | Yes | |
| acc_type | varchar(200) | Yes | |
| opendate | date | Yes |
|
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 |
|
Field |
Type | Null | Default |
| acc_num | int(20) | Yes | |
| date | date | Yes | |
| old_bal | float | Yes | |
| interest | float | Yes | |
| tot_bal | float | Yes |
|
Field |
Type | Null | Default |
| custid | int(20) | Yes | |
| loan_type | varchar(50) | Yes | |
| loan_amount | int(20) | Yes | |
| duration | int(4) | Yes | |
| name | varchar(25) | Yes | |
| address | varchar(150) | Yes | |
| profession | varchar(20) | Yes | |
| income | int(20) | Yes | |
| tele | int(25) | Yes | |
| varchar(30) | Yes | ||
| requestdate | date | Yes | |
| status | varchar(20) | Yes |
|
Field |
Type | Null | Default |
| cust_id | int(20) | Yes | |
| loan_id | int(20) | Yes | |
| type | varchar(100) | Yes | |
| amount | int(50) | Yes | |
| duration | int(20) | Yes | |
| start_date | date | Yes | |
| monthly_inst | int(20) | Yes |
|
Field |
Type | Null | Default |
| cust_id | int(20) | Yes | |
| loan_id | int(20) | Yes | |
| insta_date | date | Yes | |
| pay_date | date | Yes | |
| due_amount | int(20) | Yes | |
| inst_amount | int(20) | Yes | |
| balance | int(50) | Yes | |
| status | int(11) | Yes |
|
Field |
Type | Null | Default |
| loan_type | varchar(100) | Yes | |
| duration | varchar(20) | Yes | |
| loan_amount | varchar(50) | Yes |
|
Field |
Type | Null | Default |
| user_name | varchar(200) | Yes | 0 |
| user_password | varchar(200) | Yes | 0 |
| user_type | varchar(200) | Yes | 0 |
| question | varchar(200) | Yes | |
| ans | varchar(50) | Yes |
|
Field |
Type | Null | Default |
| cust_id | varchar(20) | Yes | |
| information | varchar(500) | Yes |
|
Field |
Type | Null | Default |
| tranid | varchar(200) | Yes | |
| trantype | varchar(200) | Yes | |
| tranmethod | varchar(200) | Yes | |
| date | timestamp | Yes | CURRENT_TIMESTAMP |
| cheque_num | varchar(25) | Yes | |
| acc_num | varchar(200) | Yes | |
| amount | varchar(200) | Yes | |
| current_balance | float | Yes | |
| remarks | varchar(200) | Yes | |
| custid | varchar(20) | Yes |
Hello,
How can I download this table. I am not very good in SQL? Any help here?
Yes. this table is not in sql format.. just copy this table in mysql foler – > data foler..
Then type localhost/phpmyadmin in browser..
I have error from login.php file
that says invalid identifier from below line
$_SESSION[tp] =$type;
Please help this..
Best Regard
sir plz send the project in java
I’ve some T-SQL trigger code which I’ve failed to convert to Oracle PL/SQL any help?, send yr reply to wndrmiracle@gmail.com
i would like to learn more about oracle how can i do it
Oracle step by step video tutorials:
http://www.youtube.com/watch?v=BVSctBCRPvY
http://www.youtube.com/watch?v=djKHQeSUuD8
http://www.youtube.com/watch?v=GS1ZELDccto
http://www.youtube.com/watch?v=RDxMZcGwrtw
http://www.youtube.com/watch?v=_qBCjLKB_sM
http://www.youtube.com/watch?v=9qNxtHV79u0
http://www.youtube.com/watch?v=R3CknWmJrDA
http://www.youtube.com/watch?v=8kh1mJg-LCg
http://www.youtube.com/watch?v=Ocpg9DyShxU
http://www.youtube.com/watch?v=0DuBuLkgBXE
http://www.youtube.com/watch?v=p8mVOE8i-XY
please you can send the reply on my email
http://www.profree4u.blogspot.in
Download more projects for here freee
i would like you to help me think if a project i can design for a bank
Yes front end is already designed.
please attach er diagram
waw good thanks alot
How you got what you were searching.. Thanks