lic |
| indv | |
| Fields |
| Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
ID |
int(11) |
(NULL) |
NO |
PRI |
(NULL) |
auto_increment |
select,insert,update,references |
|
ACTLICTYPE |
char(2) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
ACTLICNO |
char(10) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
ACTLICEXP |
date |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
ADDRCHGFEE |
decimal(8,2) |
(NULL) |
YES |
|
0.00 |
|
select,insert,update,references |
|
AFFIDAVIT |
char(1) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
APPQUALDATEREC |
date |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
APPQUALDOCREC |
tinyint(1) |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
APPQUALNONE |
tinyint(1) |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
APPQUALHUD |
tinyint(1) |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
APPQUALFMFM |
tinyint(1) |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
APPQUALGM |
tinyint(1) |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
APPQUALSTAPPDT |
date |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
BADDRESS1 |
varchar(34) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
BADDRESS2 |
varchar(34) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
BAL |
decimal(8,2) |
(NULL) |
YES |
|
0.00 |
|
select,insert,update,references |
|
BEGINBAL |
decimal(8,2) |
(NULL) |
YES |
|
0.00 |
|
select,insert,update,references |
|
BCITY |
varchar(24) |
latin1_swedish_ci |
YES |
MUL |
(NULL) |
|
select,insert,update,references |
|
BFAX |
varchar(12) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
BGCHKREC |
date |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
BGCHKRFBI |
date |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
BGCHKSENT |
date |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
BILLDATE |
date |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
BKTEL |
varchar(12) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
BKDOCSRD |
char(1) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
BKDOCSDT |
date |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
BKFAX |
varchar(12) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
BKEMAIL |
varchar(50) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
BKQUALDATEREQ |
date |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
BKQUALFM |
char(1) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
BKQUALGM |
char(1) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
BKQUALHUD |
char(1) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
BRANCHFEE |
decimal(8,2) |
(NULL) |
YES |
|
0.00 |
|
select,insert,update,references |
|
BST |
char(2) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
BTEL |
varchar(17) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
BusPlanAprvdDate |
date |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
BusPlanRcvdDate |
date |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
BZIPCODE |
varchar(10) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
CEUHOURS |
int(11) |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
CHILDSUPP |
char(1) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
CITIZEN |
char(1) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
COMPDATE |
date |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
CRCKRCVD |
date |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
CRCKSENT |
date |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
CRIMEOFF |
char(1) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
CRWBZIPCODE |
char(5) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
DOB |
date |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
DOMeetFinReq |
char(1) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
DRIVERLIC |
varchar(15) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
DRIVERLST |
char(2) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
varchar(50) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
EXPDATE |
date |
(NULL) |
YES |
MUL |
(NULL) |
|
select,insert,update,references |
|
FBIDPSFEE |
decimal(8,2) |
(NULL) |
YES |
|
0.00 |
|
select,insert,update,references |
|
FINGERPRNT |
char(1) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
FINREQ |
varchar(10) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
FIRM |
varchar(50) |
latin1_swedish_ci |
YES |
MUL |
(NULL) |
|
select,insert,update,references |
|
FNAME |
varchar(15) |
latin1_swedish_ci |
YES |
MUL |
(NULL) |
|
select,insert,update,references |
|
FSADoc |
longtext |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
FSAReported |
decimal(8,0) |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
FSCRegNo |
decimal(8,0) |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
GREENCARD |
char(1) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
HADDRESS1 |
varchar(34) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
HADDRESS2 |
varchar(34) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
HCITY |
varchar(24) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
HISTORY |
longtext |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
HST |
char(2) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
HZIPCODE |
varchar(10) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
LASTCHGDAT |
date |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
LICDATE |
date |
(NULL) |
YES |
MUL |
(NULL) |
|
select,insert,update,references |
|
LICFEE |
decimal(8,2) |
(NULL) |
YES |
|
0.00 |
|
select,insert,update,references |
|
LICNO |
varchar(20) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
LICSPON |
char(1) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
LICTYPE |
int(1) |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
LNAME |
varchar(20) |
latin1_swedish_ci |
YES |
MUL |
(NULL) |
|
select,insert,update,references |
|
LOCARADDR |
varchar(34) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
LOCARCONT |
varchar(40) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
LOCARCSZ |
varchar(34) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
LOCARCITY |
varchar(20) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
LOCARST |
char(2) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
LOCARZIP |
varchar(10) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
LOCARTEL |
varchar(12) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
LOCATEGORY |
char(1) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
LOCMRADDR |
varchar(34) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
LOCMRCONT |
varchar(40) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
LOCMRCSZ |
varchar(34) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
LOCMRCITY |
varchar(20) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
LOCMRST |
char(2) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
LOCMRZIP |
varchar(10) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
LOCMRTEL |
varchar(12) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
MBCATEGORY |
char(1) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
mblicno |
int(11) |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
MI |
varchar(15) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
NAMELF |
char(34) |
latin1_swedish_ci |
YES |
MUL |
(NULL) |
|
select,insert,update,references |
|
ORIGLICDAT |
date |
(NULL) |
YES |
MUL |
(NULL) |
|
select,insert,update,references |
|
PAID |
decimal(8,2) |
(NULL) |
YES |
|
0.00 |
|
select,insert,update,references |
|
PAIDDATE |
date |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
PIN |
char(6) |
latin1_swedish_ci |
YES |
MUL |
(NULL) |
|
select,insert,update,references |
|
RCVDDATE |
date |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
REACTFEE |
decimal(8,2) |
(NULL) |
YES |
|
0.00 |
|
select,insert,update,references |
|
rectype |
char(3) |
latin1_swedish_ci |
YES |
MUL |
(NULL) |
|
select,insert,update,references |
|
RECVRYFUND |
decimal(8,2) |
(NULL) |
YES |
|
0.00 |
|
select,insert,update,references |
|
relationship |
char(3) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
REQHOURS |
int(11) |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
RES5YEARS |
char(1) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
SSNO |
varchar(11) |
latin1_swedish_ci |
YES |
MUL |
(NULL) |
|
select,insert,update,references |
|
STATUS |
char(3) |
latin1_swedish_ci |
YES |
MUL |
(NULL) |
|
select,insert,update,references |
|
SuretyBondDate |
date |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
SUFFIX |
char(3) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
TITLE |
char(3) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
USERINIT |
char(3) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
WEBUPDDATE |
date |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
BONDREQ |
char(1) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
BONDRECD |
char(1) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
BONDNO |
char(15) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
SENTENCEIMP |
char(1) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
CHARGESPENDNG |
char(1) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
CIVILLAWSUITS |
char(1) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
EXISTINGLIC |
char(1) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
REGULATORYBAN |
char(1) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
FASTPASS |
char(1) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
CRCKAPPRVDATE |
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 |
indv |
0 |
PRIMARY |
1 |
ID |
A |
60226 |
(NULL) |
(NULL) |
|
BTREE |
|
indv |
1 |
namelf |
1 |
NAMELF |
A |
60226 |
(NULL) |
(NULL) |
YES |
BTREE |
|
indv |
1 |
rectype |
1 |
rectype |
A |
1 |
(NULL) |
(NULL) |
YES |
BTREE |
|
indv |
1 |
Status |
1 |
STATUS |
A |
133 |
(NULL) |
(NULL) |
YES |
BTREE |
|
indv |
1 |
SSNO |
1 |
SSNO |
A |
1 |
(NULL) |
(NULL) |
YES |
BTREE |
|
indv |
1 |
EXPDATE |
1 |
EXPDATE |
A |
3764 |
(NULL) |
(NULL) |
YES |
BTREE |
|
indv |
1 |
FIRM |
1 |
FIRM |
A |
60226 |
(NULL) |
(NULL) |
YES |
BTREE |
|
indv |
1 |
FNAME |
1 |
FNAME |
A |
15056 |
(NULL) |
(NULL) |
YES |
BTREE |
|
indv |
1 |
LICDATE |
1 |
LICDATE |
A |
2867 |
(NULL) |
(NULL) |
YES |
BTREE |
|
indv |
1 |
LNAME |
1 |
LNAME |
A |
60226 |
(NULL) |
(NULL) |
YES |
BTREE |
|
indv |
1 |
PIN |
1 |
PIN |
A |
60226 |
(NULL) |
(NULL) |
YES |
BTREE |
|
indv |
1 |
ORIGLICDAT |
1 |
ORIGLICDAT |
A |
2867 |
(NULL) |
(NULL) |
YES |
BTREE |
|
indv |
1 |
BCITY |
1 |
BCITY |
A |
2409 |
(NULL) |
(NULL) |
YES |
BTREE |
|
indv |
1 |
ID |
1 |
ID |
A |
60226 |
(NULL) |
(NULL) |
|
BTREE |
|
Back