lic |
complain |
Fields |
Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
ID |
int(11) |
(NULL) |
YES |
MUL |
0 |
|
select,insert,update,references |
|
CID |
char(6) |
latin1_swedish_ci |
YES |
MUL |
(NULL) |
|
select,insert,update,references |
|
ASSNRCVDT |
date |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
BKRNOTREG |
int(11) |
(NULL) |
YES |
|
0 |
|
select,insert,update,references |
|
BKRREGNO |
int(11) |
(NULL) |
YES |
|
0 |
|
select,insert,update,references |
|
BROKERCITY |
varchar(25) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
CHECKNO |
varchar(16) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
CLOSEDDT |
date |
(NULL) |
YES |
MUL |
(NULL) |
|
select,insert,update,references |
|
CMPAMTREC |
decimal(8,2) |
(NULL) |
YES |
|
0.00 |
|
select,insert,update,references |
|
CMPNAMELF |
varchar(50) |
latin1_swedish_ci |
YES |
MUL |
(NULL) |
|
select,insert,update,references |
|
CMPADDRESS |
varchar(50) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
CMPCELL |
varchar(17) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
CMPCITY |
varchar(20) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
CMPCODE |
varchar(8) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
CMPEMAIL |
varchar(50) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
CMPFAX |
varchar(17) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
CMPHOME |
varchar(17) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
CMPLNAME |
varchar(20) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
CMPFNAME |
varchar(15) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
CMPMI |
varchar(10) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
CMPST |
char(2) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
CMPTITLE |
char(3) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
CMPWORK |
varchar(17) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
CMPZIPCODE |
varchar(9) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
CMPTITLE2 |
char(3) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
CMPFNAME2 |
varchar(15) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
CMPMI2 |
varchar(10) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
CMPLNAME2 |
varchar(20) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
COMPANY |
varchar(60) |
latin1_swedish_ci |
YES |
MUL |
(NULL) |
|
select,insert,update,references |
|
DAYSTORSVL |
int(11) |
(NULL) |
YES |
|
0 |
|
select,insert,update,references |
|
EXAMASSN |
varchar(40) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
EXAMASSNID |
char(3) |
latin1_swedish_ci |
YES |
MUL |
(NULL) |
|
select,insert,update,references |
|
EXAMASSNDT |
date |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
EXAMCMPTDT |
date |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
FILENUMBER |
int(11) |
(NULL) |
YES |
MUL |
0 |
|
select,insert,update,references |
|
FinalNoticDt |
date |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
FinalRespDt |
date |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
FRSTLTTRDT |
date |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
FISCALYR |
char(4) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
INVSTASSN |
varchar(40) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
InvstAssnID |
char(3) |
latin1_swedish_ci |
YES |
MUL |
(NULL) |
|
select,insert,update,references |
|
InvstAssnDt |
date |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
InvstCmptDt |
date |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
NATOFRES |
varchar(40) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
NORSPRFREN |
varchar(20) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
OPENDT |
date |
(NULL) |
YES |
MUL |
(NULL) |
|
select,insert,update,references |
|
OPENSTATUS |
char(1) |
latin1_swedish_ci |
YES |
MUL |
O |
|
select,insert,update,references |
|
PAID |
decimal(8,2) |
(NULL) |
YES |
|
0.00 |
|
select,insert,update,references |
|
PAIDDT |
date |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
PERSON |
varchar(40) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
PRIORITY |
varchar(10) |
latin1_swedish_ci |
YES |
MUL |
(NULL) |
|
select,insert,update,references |
|
QTRPT |
decimal(8,2) |
(NULL) |
YES |
|
0.00 |
|
select,insert,update,references |
|
RECIVEDDT |
date |
(NULL) |
YES |
MUL |
(NULL) |
|
select,insert,update,references |
|
RESOLVEDT |
date |
(NULL) |
YES |
MUL |
(NULL) |
|
select,insert,update,references |
|
RESPANSREC |
date |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
respFlwUpDt |
date |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
SUPPRECDT |
date |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
TRANNO |
int(11) |
(NULL) |
NO |
PRI |
(NULL) |
auto_increment |
select,insert,update,references |
|
PERSON1 |
char(4) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
PERSON2 |
char(4) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
PERSON3 |
char(4) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
PERSON4 |
char(4) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
MB1 |
int(11) |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
MB2 |
int(11) |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
MB3 |
int(11) |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
LO1 |
int(11) |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
LO2 |
int(11) |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
BROKERUK |
varchar(4) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
APSNTDT |
date |
(NULL) |
YES |
MUL |
(NULL) |
|
select,insert,update,references |
|
APDUEDT |
date |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
APRCVDT |
date |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
APENAMT |
decimal(8,2) |
(NULL) |
YES |
|
0.00 |
|
select,insert,update,references |
|
NOTES |
longtext |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
NAME |
varchar(50) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
INTEGERONE |
int(11) |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
INTEGER2 |
int(11) |
(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 |
complain |
0 |
PRIMARY |
1 |
TRANNO |
A |
5289 |
(NULL) |
(NULL) |
|
BTREE |
|
complain |
1 |
ID |
1 |
ID |
A |
(NULL) |
(NULL) |
(NULL) |
YES |
BTREE |
|
complain |
1 |
PRIORITY |
1 |
PRIORITY |
A |
(NULL) |
(NULL) |
(NULL) |
YES |
BTREE |
|
complain |
1 |
RECIVEDDT |
1 |
RECIVEDDT |
A |
(NULL) |
(NULL) |
(NULL) |
YES |
BTREE |
|
complain |
1 |
RECEVEDDT |
1 |
APSNTDT |
A |
(NULL) |
(NULL) |
(NULL) |
YES |
BTREE |
|
complain |
1 |
CID |
1 |
CID |
A |
(NULL) |
(NULL) |
(NULL) |
YES |
BTREE |
|
complain |
1 |
RESOLVEDT |
1 |
RESOLVEDT |
A |
(NULL) |
(NULL) |
(NULL) |
YES |
BTREE |
|
complain |
1 |
CLOSEDDT |
1 |
CLOSEDDT |
A |
(NULL) |
(NULL) |
(NULL) |
YES |
BTREE |
|
complain |
1 |
CMPNAMELF |
1 |
CMPNAMELF |
A |
(NULL) |
(NULL) |
(NULL) |
YES |
BTREE |
|
complain |
1 |
OPENSTATUS |
1 |
OPENSTATUS |
A |
(NULL) |
(NULL) |
(NULL) |
YES |
BTREE |
|
complain |
1 |
COMPANY |
1 |
COMPANY |
A |
(NULL) |
(NULL) |
(NULL) |
YES |
BTREE |
|
complain |
1 |
INVSTASSNID |
1 |
InvstAssnID |
A |
(NULL) |
(NULL) |
(NULL) |
YES |
BTREE |
|
complain |
1 |
EXAMASSNID |
1 |
EXAMASSNID |
A |
(NULL) |
(NULL) |
(NULL) |
YES |
BTREE |
|
complain |
1 |
FILENUMBER |
1 |
FILENUMBER |
A |
(NULL) |
(NULL) |
(NULL) |
YES |
BTREE |
|
complain |
1 |
OPENDT |
1 |
OPENDT |
A |
(NULL) |
(NULL) |
(NULL) |
YES |
BTREE |
|
Back