Free Student Projects

Follow

Online banking Database design

Share

Online banking Database design and ER diagram is uploaded in this article. You can download this project code by following link :  http://studentprojectcode.com/2012/06/22/online-banking-script/

Online banking Database design

Database Name: banking

Table: accounts

Field

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

float

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

Field

Type

Null

Default

acc_num

int(20)

Yes

date

date

Yes

old_bal

float

Yes

interest

float

Yes

tot_bal

float

Yes

Table: loan

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

email

varchar(30)

Yes

requestdate

date

Yes

status

varchar(20)

Yes

Table: loan_accept

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

Table: loan_paid

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

Table: loan_type

Field

Type

Null

Default

loan_type

varchar(100)

Yes

duration

varchar(20)

Yes

loan_amount

varchar(50)

Yes

Table: login

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

Table: rejected_information

Field

Type

Null

Default

cust_id

varchar(20)

Yes

information

varchar(500)

Yes

Table: transactions

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

Share

Related

Latest