def |
atmdb |
account |
accountID |
1 |
NULL
|
NO |
int |
NULL
|
NULL
|
10 |
0 |
NULL
|
NULL
|
NULL
|
int(11) |
PRI |
auto_increment |
select,insert,update,references |
|
|
NULL
|
def |
atmdb |
account |
accountNumber |
2 |
NULL
|
YES |
varchar |
20 |
80 |
NULL
|
NULL
|
NULL
|
utf8mb4 |
utf8mb4_general_ci |
varchar(20) |
UNI |
|
select,insert,update,references |
|
|
NULL
|
def |
atmdb |
account |
userName |
3 |
NULL
|
YES |
varchar |
255 |
1020 |
NULL
|
NULL
|
NULL
|
utf8mb4 |
utf8mb4_general_ci |
varchar(255) |
|
|
select,insert,update,references |
|
|
NULL
|
def |
atmdb |
account |
accountBalance |
4 |
NULL
|
YES |
decimal |
NULL
|
NULL
|
10 |
2 |
NULL
|
NULL
|
NULL
|
decimal(10,2) |
|
|
select,insert,update,references |
|
|
NULL
|
def |
atmdb |
aeskey |
AESkeyID |
1 |
NULL
|
NO |
int |
NULL
|
NULL
|
10 |
0 |
NULL
|
NULL
|
NULL
|
int(11) |
PRI |
auto_increment |
select,insert,update,references |
|
|
NULL
|
def |
atmdb |
aeskey |
clientID |
2 |
NULL
|
YES |
int |
NULL
|
NULL
|
10 |
0 |
NULL
|
NULL
|
NULL
|
int(11) |
MUL |
|
select,insert,update,references |
|
|
NULL
|
def |
atmdb |
aeskey |
keyData |
3 |
NULL
|
YES |
blob |
65535 |
65535 |
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
blob |
|
|
select,insert,update,references |
|
|
NULL
|
def |
atmdb |
card |
cardid |
1 |
NULL
|
NO |
int |
NULL
|
NULL
|
10 |
0 |
NULL
|
NULL
|
NULL
|
int(11) |
PRI |
auto_increment |
select,insert,update,references |
|
|
NULL
|
def |
atmdb |
card |
cardNumber |
2 |
NULL
|
YES |
varchar |
19 |
76 |
NULL
|
NULL
|
NULL
|
utf8mb4 |
utf8mb4_general_ci |
varchar(19) |
|
|
select,insert,update,references |
|
|
NULL
|
def |
atmdb |
card |
accountNumber |
3 |
NULL
|
NO |
varchar |
20 |
80 |
NULL
|
NULL
|
NULL
|
utf8mb4 |
utf8mb4_general_ci |
varchar(20) |
MUL |
|
select,insert,update,references |
|
|
NULL
|
def |
atmdb |
card |
cc |
4 |
NULL
|
YES |
varchar |
3 |
12 |
NULL
|
NULL
|
NULL
|
utf8mb4 |
utf8mb4_general_ci |
varchar(3) |
|
|
select,insert,update,references |
|
|
NULL
|
def |
atmdb |
card |
expiryDate |
5 |
NULL
|
YES |
date |
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
date |
|
|
select,insert,update,references |
|
|
NULL
|
def |
atmdb |
client |
clientID |
1 |
NULL
|
NO |
int |
NULL
|
NULL
|
10 |
0 |
NULL
|
NULL
|
NULL
|
int(11) |
PRI |
auto_increment |
select,insert,update,references |
|
|
NULL
|
def |
atmdb |
transaction |
transactionID |
1 |
NULL
|
NO |
int |
NULL
|
NULL
|
10 |
0 |
NULL
|
NULL
|
NULL
|
int(11) |
PRI |
auto_increment |
select,insert,update,references |
|
|
NULL
|
def |
atmdb |
transaction |
accountNumber |
2 |
NULL
|
NO |
varchar |
20 |
80 |
NULL
|
NULL
|
NULL
|
utf8mb4 |
utf8mb4_general_ci |
varchar(20) |
MUL |
|
select,insert,update,references |
|
|
NULL
|
def |
atmdb |
transaction |
amount |
3 |
NULL
|
YES |
decimal |
NULL
|
NULL
|
10 |
2 |
NULL
|
NULL
|
NULL
|
decimal(10,2) |
|
|
select,insert,update,references |
|
|
NULL
|
def |
atmdb |
transaction |
date_time |
4 |
CURRENT_TIMESTAMP |
NO |
timestamp |
NULL
|
NULL
|
NULL
|
NULL
|
0 |
NULL
|
NULL
|
timestamp |
|
DEFAULT_GENERATED on update CURRENT_TIMESTAMP |
select,insert,update,references |
|
|
NULL
|
def |
atmdb |
transaction |
transaction_type |
5 |
NULL
|
NO |
enum |
13 |
52 |
NULL
|
NULL
|
NULL
|
utf8mb4 |
utf8mb4_general_ci |
enum('DEPOSIT','WITHDRAWAL','BALANCE CHECK') |
|
|
select,insert,update,references |
|
|
NULL
|
def |
atmdb |
users |
userID |
1 |
NULL
|
NO |
int |
NULL
|
NULL
|
10 |
0 |
NULL
|
NULL
|
NULL
|
int(11) |
PRI |
auto_increment |
select,insert,update,references |
|
|
NULL
|
def |
atmdb |
users |
cardNumber |
2 |
NULL
|
YES |
varchar |
19 |
76 |
NULL
|
NULL
|
NULL
|
utf8mb4 |
utf8mb4_general_ci |
varchar(19) |
|
|
select,insert,update,references |
|
|
NULL
|
def |
atmdb |
users |
passcode |
3 |
NULL
|
YES |
varchar |
64 |
256 |
NULL
|
NULL
|
NULL
|
utf8mb4 |
utf8mb4_general_ci |
varchar(64) |
|
|
select,insert,update,references |
|
|
NULL
|
def |
information_schema |
CHARACTER_SETS |
CHARACTER_SET_NAME |
1 |
NULL
|
NO |
varchar |
64 |
192 |
NULL
|
NULL
|
NULL
|
utf8 |
utf8_general_ci |
varchar(64) |
|
|
select |
|
|
NULL
|
def |
information_schema |
CHARACTER_SETS |
DEFAULT_COLLATE_NAME |
2 |
NULL
|
NO |
varchar |
64 |
192 |
NULL
|
NULL
|
NULL
|
utf8 |
utf8_general_ci |
varchar(64) |
|
|
select |
|
|
NULL
|
def |
information_schema |
CHARACTER_SETS |
DESCRIPTION |
3 |
NULL
|
NO |
varchar |
2048 |
6144 |
NULL
|
NULL
|
NULL
|
utf8 |
utf8_general_ci |
varchar(2048) |
|
|
select |
|
|
NULL
|
def |
information_schema |
CHARACTER_SETS |
MAXLEN |
4 |
NULL
|
NO |
int |
NULL
|
NULL
|
10 |
0 |
NULL
|
NULL
|
NULL
|
int(10) unsigned |
|
|
select |
|
|
NULL
|