lic |
compindv
compindv |
Fields |
Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
CID |
int(11) |
(NULL) |
YES |
MUL |
(NULL) |
|
select,insert,update,references |
|
LOID |
int(11) |
(NULL) |
YES |
MUL |
(NULL) |
|
select,insert,update,references |
|
AMTOWED |
double(8,2) |
(NULL) |
YES |
|
0.00 |
|
select,insert,update,references |
|
AMTPAID |
double(8,2) |
(NULL) |
YES |
|
0.00 |
|
select,insert,update,references |
|
DATEPAID |
date |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
CHECKNUM |
varchar(30) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
NoRspFefEnfc |
date |
(NULL) |
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 |
compindv |
1 |
cid |
1 |
CID |
A |
(NULL) |
(NULL) |
(NULL) |
YES |
BTREE |
|
compindv |
1 |
loid |
1 |
LOID |
A |
(NULL) |
(NULL) |
(NULL) |
YES |
BTREE |
|
Back