lic |
loans
loans |
Fields |
Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
COID |
int(11) |
(NULL) |
YES |
MUL |
(NULL) |
|
select,insert,update,references |
|
LICID |
int(11) |
(NULL) |
YES |
MUL |
(NULL) |
|
select,insert,update,references |
|
LOANID |
int(11) |
(NULL) |
NO |
PRI |
(NULL) |
auto_increment |
select,insert,update,references |
|
AGREESWBRNCH |
tinyint(1) |
(NULL) |
YES |
|
0 |
|
select,insert,update,references |
|
AGREESWLO |
tinyint(1) |
(NULL) |
YES |
|
0 |
|
select,insert,update,references |
|
LASTCHGDAT |
date |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
REPORTYEAR |
int(11) |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
TOTACTBR |
double |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
TOTCONVCDO |
double |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
TOTCONVCNO |
int(11) |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
TOTCONVNDO |
double |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
TOTCONVNNO |
int(11) |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
TOTDOLVOL |
double |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
TOTFHADOL |
double |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
TOTFHALOAN |
int(11) |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
TOTHCDOL |
double |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
TOTHCLOAN |
int(11) |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
TOTNOLOANS |
int(11) |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
TOTOTHERDO |
double |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
TOTOTHERNO |
int(11) |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
TOTOTHERTY |
varchar(10) |
latin1_swedish_ci |
YES |
MUL |
(NULL) |
|
select,insert,update,references |
|
TOTSPONLO |
double |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
TOTVADOL |
double |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
TOTVALOAN |
int(11) |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
USERINIT |
varchar(3) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
Indexes |
Table | Non unique |
Key name |
Seq in index |
Column name |
Collation | Cardinality | Sub part |
Packed | Null | Index type |
Comment |
loans |
0 |
PRIMARY |
1 |
LOANID |
A |
57170 |
(NULL) |
(NULL) |
|
BTREE |
|
loans |
1 |
coid |
1 |
COID |
A |
(NULL) |
(NULL) |
(NULL) |
YES |
BTREE |
|
loans |
1 |
loid |
1 |
LICID |
A |
(NULL) |
(NULL) |
(NULL) |
YES |
BTREE |
|
loans |
1 |
LICID |
1 |
LICID |
A |
(NULL) |
(NULL) |
(NULL) |
YES |
BTREE |
|
loans |
1 |
TOTOTHERTY |
1 |
TOTOTHERTY |
A |
(NULL) |
(NULL) |
(NULL) |
YES |
BTREE |
|
Back