lic |
company |   |
Fields |
Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
COID |
int(11) |
(NULL) |
NO |
PRI |
(NULL) |
auto_increment |
select,insert,update,references |
|
LICID |
int(11) |
(NULL) |
YES |
MUL |
(NULL) |
|
select,insert,update,references |
|
ADDRESS1 |
varchar(34) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
ADDRESS2 |
varchar(34) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
ASSUMNAME |
varchar(40) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
CITY |
varchar(24) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
CONTACT |
varchar(30) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
employerno |
varchar(15) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
entitytype |
char(1) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
FAX |
varchar(12) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
FIRM |
varchar(50) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
FIRMTYPE |
varchar(2) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
LASTCHGDAT |
date |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
SPONBKID |
int(11) |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
ST |
varchar(2) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
TEL |
varchar(17) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
TOLLFREE |
varchar(12) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
USERINIT |
varchar(3) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
ZIPCODE |
varchar(12) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
FHAID |
varchar(12) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
VAID |
varchar(12) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
OTHERID |
varchar(12) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
LOANPROD |
varchar(1) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
REPORTYEAR |
int(11) |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
MBSTATUS |
varchar(2) |
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 |
company |
0 |
PRIMARY |
1 |
COID |
A |
60361 |
(NULL) |
(NULL) |
|
BTREE |
|
company |
1 |
licid |
1 |
LICID |
A |
60361 |
(NULL) |
(NULL) |
YES |
BTREE |
|
company |
1 |
COID |
1 |
COID |
A |
60361 |
(NULL) |
(NULL) |
|
BTREE |
|
Back