Table
This document was uploaded by user and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this DMCA report form. Report DMCA
Overview
Download & View Table as PDF for free.
More details
- Words: 486
- Pages: 6
S. no
Name
Type
Size
Constrains
Description
1
accno
Text
6
Primary key
2
doacc
Text
7
3
acctype
Text
6
4
acchold
Text
7
5
age
Text
2
6
dob
Text
10
Account Number Date Of Account Account Type Name Of Account Holder Age Of Account Holder Date Of Birth
7
occ
Text
15
Occupation
8
quail
Text
10
Qualification
9
address
Text
19
Address
10
phno
Text
10
11
pan/pas
Text
19
Phone Number Passport
12
nation
Text
20
Nation
13
annuminco
Number
19
14
cheque
Text
12
Cheque
15
noname
Text
20
Name
16
noage
Text
2
Age
17
norelat
Text
13
Relations
18
witname
Text
19
19
witaccno
Text
18
Withdrawl Name Withdrawl Account Number
TABLE: DEPOSIT
S. no
Name
Type
Size
Constrains
Description
1
accno
Text
12
Account number Date
2
date
Text
11
3
mopay
Text
12
4
amt
Text
14
5
chqno
Text
13
6
chqdate
Text
10
Cheque number Cheque date
7
bname
Text
8
Bank name
8
locat
Text
15
Location
Method of payment Amount
S. no
Name
Type
Size
1
Transaction ID Date Of Creation Amount
Text
12
Text
12
Date of creation
Text
11
Amount
Interest Rate Number Of Due Due Amount Creditor Name Remarks
Text
13
Interest Rate
Text
14
Number Of Dues
Text
10
Due Amount
Text
11
Creditor Name
Text
16
Remarks
Name Of The Person Occupation
Text
19
Text
18
Name Of The Person Occupation
Text
16
Account Number
12
Account Number Age
Text
10
Age
13
Address
Text
12
Address
14
Document Issued Types
Text
11
Document Issued
Text
12
Types
Text
13
Partner’s Name
Text
14
Name Of The Concern
Text
15
Partner’s Account
Text
23
Partner’s Address
20
Partner’s Name Name Of The Concern Partner’s Account Partner’s Address Phone No
Text
14
Phone Number
21
City
Text
14
City
2 3 4 5 6 7 8 9 10 11
15 16 17 18 19
Constrains Primary Key
Description Transaction Id
22
Country
Text
17
Country
23
Voter Name
Text
14
Voter Name
24
Pass No
Text
12
Pass Number
25
Pan No
Text
11
Pan Number
26
License No
Text
13
License Number
27
Text
15
Bank Account Number
28
Bank Account No IT NO
Text
19
IT Number
29
CST No
Text
20
CST Number
30
VAT No
Text
10
VAT Number
S no 1
Name
Type
Size
Constrains
Text
12
Text
11
Text
14
4
Transaction ID Number Of Due Date Of Receipt Due Amount
Text
10
5
Amount
Text
15
2 3
Description Transaction ID Number Of Due Date Of Receipt Due Amount Deposit Amount
S no
Name
Type
Size
Constrains
Description
1
accno
Text
12
Account number Name of Account holder Method of withdrawal Amount
2
acchold
Text
11
3
mow
Text
19
4
amt
Text
17
5
chqno
Text
15
6
chqdate
Text
13
Cheque number Cheque date
7
pay
Text
10
Pay
Name
Type
Size
Constrains
Description
1
accno
Text
6
Primary key
2
doacc
Text
7
3
acctype
Text
6
4
acchold
Text
7
5
age
Text
2
6
dob
Text
10
Account Number Date Of Account Account Type Name Of Account Holder Age Of Account Holder Date Of Birth
7
occ
Text
15
Occupation
8
quail
Text
10
Qualification
9
address
Text
19
Address
10
phno
Text
10
11
pan/pas
Text
19
Phone Number Passport
12
nation
Text
20
Nation
13
annuminco
Number
19
14
cheque
Text
12
Cheque
15
noname
Text
20
Name
16
noage
Text
2
Age
17
norelat
Text
13
Relations
18
witname
Text
19
19
witaccno
Text
18
Withdrawl Name Withdrawl Account Number
TABLE: DEPOSIT
S. no
Name
Type
Size
Constrains
Description
1
accno
Text
12
Account number Date
2
date
Text
11
3
mopay
Text
12
4
amt
Text
14
5
chqno
Text
13
6
chqdate
Text
10
Cheque number Cheque date
7
bname
Text
8
Bank name
8
locat
Text
15
Location
Method of payment Amount
S. no
Name
Type
Size
1
Transaction ID Date Of Creation Amount
Text
12
Text
12
Date of creation
Text
11
Amount
Interest Rate Number Of Due Due Amount Creditor Name Remarks
Text
13
Interest Rate
Text
14
Number Of Dues
Text
10
Due Amount
Text
11
Creditor Name
Text
16
Remarks
Name Of The Person Occupation
Text
19
Text
18
Name Of The Person Occupation
Text
16
Account Number
12
Account Number Age
Text
10
Age
13
Address
Text
12
Address
14
Document Issued Types
Text
11
Document Issued
Text
12
Types
Text
13
Partner’s Name
Text
14
Name Of The Concern
Text
15
Partner’s Account
Text
23
Partner’s Address
20
Partner’s Name Name Of The Concern Partner’s Account Partner’s Address Phone No
Text
14
Phone Number
21
City
Text
14
City
2 3 4 5 6 7 8 9 10 11
15 16 17 18 19
Constrains Primary Key
Description Transaction Id
22
Country
Text
17
Country
23
Voter Name
Text
14
Voter Name
24
Pass No
Text
12
Pass Number
25
Pan No
Text
11
Pan Number
26
License No
Text
13
License Number
27
Text
15
Bank Account Number
28
Bank Account No IT NO
Text
19
IT Number
29
CST No
Text
20
CST Number
30
VAT No
Text
10
VAT Number
S no 1
Name
Type
Size
Constrains
Text
12
Text
11
Text
14
4
Transaction ID Number Of Due Date Of Receipt Due Amount
Text
10
5
Amount
Text
15
2 3
Description Transaction ID Number Of Due Date Of Receipt Due Amount Deposit Amount
S no
Name
Type
Size
Constrains
Description
1
accno
Text
12
Account number Name of Account holder Method of withdrawal Amount
2
acchold
Text
11
3
mow
Text
19
4
amt
Text
17
5
chqno
Text
15
6
chqdate
Text
13
Cheque number Cheque date
7
pay
Text
10
Pay
