|
lic |
| lictran |
| Fields |
| Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
|
ID |
int(11) |
(NULL) |
YES |
MUL |
(NULL) |
|
select,insert,update,references |
|
|
ADDRCHGAMT |
decimal(17,2) |
(NULL) |
YES |
|
0.00 |
|
select,insert,update,references |
|
|
BRANCHAMT |
decimal(17,2) |
(NULL) |
YES |
|
0.00 |
|
select,insert,update,references |
|
|
CHECKNO |
varchar(20) |
latin1_swedish_ci |
YES |
MUL |
(NULL) |
|
select,insert,update,references |
|
|
EXPDATE |
varchar(5) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
FBIDPSAMT |
decimal(17,2) |
(NULL) |
YES |
|
0.00 |
|
select,insert,update,references |
|
|
LICAMT |
decimal(17,2) |
(NULL) |
YES |
|
0.00 |
|
select,insert,update,references |
|
|
REACTAMT |
decimal(17,2) |
(NULL) |
YES |
|
0.00 |
|
select,insert,update,references |
|
|
RECOVERAMT |
decimal(17,2) |
(NULL) |
YES |
|
0.00 |
|
select,insert,update,references |
|
|
TRANDATE |
date |
(NULL) |
YES |
MUL |
(NULL) |
|
select,insert,update,references |
|
|
TRANNO |
int(11) |
(NULL) |
NO |
PRI |
(NULL) |
auto_increment |
select,insert,update,references |
|
| Indexes |
| Table | Non unique |
Key name |
Seq in index |
Column name |
Collation | Cardinality | Sub part |
Packed | Null | Index type |
Comment |
|
lictran |
0 |
PRIMARY |
1 |
TRANNO |
A |
143676 |
(NULL) |
(NULL) |
|
BTREE |
|
|
lictran |
1 |
TRANDATE |
1 |
TRANDATE |
A |
(NULL) |
(NULL) |
(NULL) |
YES |
BTREE |
|
|
lictran |
1 |
CHECKNO |
1 |
CHECKNO |
A |
(NULL) |
(NULL) |
(NULL) |
YES |
BTREE |
|
|
lictran |
1 |
ID |
1 |
ID |
A |
(NULL) |
(NULL) |
(NULL) |
YES |
BTREE |
|
|
lictran |
1 |
TRANNO |
1 |
TRANNO |
A |
(NULL) |
(NULL) |
(NULL) |
|
BTREE |
|
Back