|
lic |
branch
category
company
compcodes
compindv
complain
compnote
compntrs
course
coursetype
crime
dba
educ
enfahnote
enfanrpt
enfapphrng
enfarnote
enfcode
enfdanote
enfdisact
enfindv
examine
examiner
examnote
examtype
gen
holidays
indv
indvnote
invsgtr
legal
lictran
lictype
loadeduc
loadindv
loans
lookup
mailcode
notetype
prefix
provaka
provbranch
provider
rb_field
rb_folder
rb_item
rb_join
rb_table
rectype
reports
reptable
security
states
status
sysdata
testtable
users
usersec
ziptab
| branch |
| Fields |
| Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
|
BRANCHNO |
int(11) |
(NULL) |
NO |
PRI |
(NULL) |
auto_increment |
select,insert,update,references |
|
|
COID |
int(11) |
(NULL) |
YES |
MUL |
(NULL) |
|
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 |
|
|
CITY |
char(24) |
latin1_swedish_ci |
YES |
MUL |
(NULL) |
|
select,insert,update,references |
|
|
CNCLCODE |
char(2) |
latin1_swedish_ci |
YES |
MUL |
(NULL) |
|
select,insert,update,references |
|
|
CNCLDATE |
date |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
CONTNAME |
varchar(34) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
CONTTITLE |
varchar(34) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
|
varchar(50) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
FAX |
varchar(12) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
FIRM |
varchar(40) |
latin1_swedish_ci |
YES |
MUL |
(NULL) |
|
select,insert,update,references |
|
|
LASTCHGDAT |
date |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
ST |
char(2) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
TEL |
char(17) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
USERINIT |
char(3) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
ZIPCODE |
char(10) |
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 |
|
branch |
0 |
PRIMARY |
1 |
BRANCHNO |
A |
8199 |
(NULL) |
(NULL) |
|
BTREE |
|
|
branch |
1 |
coid |
1 |
COID |
A |
(NULL) |
(NULL) |
(NULL) |
YES |
BTREE |
|
|
branch |
1 |
licid |
1 |
LICID |
A |
(NULL) |
(NULL) |
(NULL) |
YES |
BTREE |
|
|
branch |
1 |
CITY |
1 |
CITY |
A |
(NULL) |
(NULL) |
(NULL) |
YES |
BTREE |
|
|
branch |
1 |
FIRM |
1 |
FIRM |
A |
(NULL) |
(NULL) |
(NULL) |
YES |
BTREE |
|
|
branch |
1 |
BRANCHNO |
1 |
BRANCHNO |
A |
(NULL) |
(NULL) |
(NULL) |
|
BTREE |
|
|
branch |
1 |
CNCLCODE |
1 |
CNCLCODE |
A |
(NULL) |
(NULL) |
(NULL) |
YES |
BTREE |
|
Back
| category |
| Fields |
| Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
|
CODE |
varchar(6) |
latin1_swedish_ci |
YES |
MUL |
(NULL) |
|
select,insert,update,references |
|
|
DESCRIP |
varchar(50) |
latin1_swedish_ci |
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 |
|
category |
0 |
PRIMARY |
1 |
TRANNO |
A |
4 |
(NULL) |
(NULL) |
|
BTREE |
|
|
category |
1 |
DESCRIP |
1 |
DESCRIP |
A |
(NULL) |
(NULL) |
(NULL) |
YES |
BTREE |
|
|
category |
1 |
CODE |
1 |
CODE |
A |
(NULL) |
(NULL) |
(NULL) |
YES |
BTREE |
|
|
category |
1 |
TRANNO |
1 |
TRANNO |
A |
(NULL) |
(NULL) |
(NULL) |
|
BTREE |
|
Back
| 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 |
|
|
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 |
59777 |
(NULL) |
(NULL) |
|
BTREE |
|
|
company |
1 |
licid |
1 |
LICID |
A |
(NULL) |
(NULL) |
(NULL) |
YES |
BTREE |
|
|
company |
1 |
COID |
1 |
COID |
A |
(NULL) |
(NULL) |
(NULL) |
|
BTREE |
|
Back
| compcodes |
| Fields |
| Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
|
TRANNO |
int(11) |
(NULL) |
NO |
PRI |
(NULL) |
auto_increment |
select,insert,update,references |
|
|
CODE |
char(4) |
latin1_swedish_ci |
YES |
MUL |
(NULL) |
|
select,insert,update,references |
|
|
CMPTNATURE |
varchar(50) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
PRIORITY |
varchar(10) |
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 |
|
compcodes |
0 |
PRIMARY |
1 |
TRANNO |
A |
18 |
(NULL) |
(NULL) |
|
BTREE |
|
|
compcodes |
1 |
CODE |
1 |
CODE |
A |
(NULL) |
(NULL) |
(NULL) |
YES |
BTREE |
|
Back
| 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
| 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
| compnote |
| Fields |
| Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
|
ID |
int(11) |
(NULL) |
YES |
MUL |
(NULL) |
|
select,insert,update,references |
|
|
DATE |
date |
(NULL) |
YES |
MUL |
(NULL) |
|
select,insert,update,references |
|
|
NOTES |
longtext |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
USERNAME |
char(6) |
latin1_swedish_ci |
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 |
|
compnote |
0 |
PRIMARY |
1 |
TRANNO |
A |
4666 |
(NULL) |
(NULL) |
|
BTREE |
|
|
compnote |
1 |
ID |
1 |
ID |
A |
(NULL) |
(NULL) |
(NULL) |
YES |
BTREE |
|
|
compnote |
1 |
DATE |
1 |
DATE |
A |
(NULL) |
(NULL) |
(NULL) |
YES |
BTREE |
|
|
compnote |
1 |
USERNAME |
1 |
USERNAME |
A |
(NULL) |
(NULL) |
(NULL) |
YES |
BTREE |
|
Back
| compntrs |
| Fields |
| Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
|
ID |
int(11) |
(NULL) |
NO |
PRI |
(NULL) |
auto_increment |
select,insert,update,references |
|
|
RESSTATUS |
varchar(40) |
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 |
|
compntrs |
0 |
PRIMARY |
1 |
ID |
A |
45 |
(NULL) |
(NULL) |
|
BTREE |
|
Back
| course |
| Fields |
| Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
|
PROVIDERNO |
int(11) |
(NULL) |
YES |
MUL |
(NULL) |
|
select,insert,update,references |
|
|
COURSENO |
char(15) |
latin1_swedish_ci |
YES |
MUL |
(NULL) |
|
select,insert,update,references |
|
|
APPROVALDT |
date |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
CATEGORY |
char(6) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
CLASSROOM |
tinyint(1) |
(NULL) |
YES |
MUL |
0 |
|
select,insert,update,references |
|
|
CORRESPOND |
tinyint(1) |
(NULL) |
YES |
MUL |
0 |
|
select,insert,update,references |
|
|
COURSENAME |
varchar(60) |
latin1_swedish_ci |
YES |
MUL |
(NULL) |
|
select,insert,update,references |
|
|
COURSETYPE |
char(6) |
latin1_swedish_ci |
YES |
MUL |
(NULL) |
|
select,insert,update,references |
|
|
CREDITS |
double |
(NULL) |
YES |
|
0 |
|
select,insert,update,references |
|
|
EXPDATE |
date |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
FEDERAL |
tinyint(1) |
(NULL) |
YES |
MUL |
0 |
|
select,insert,update,references |
|
|
LASTCHGDAT |
date |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
NOTES |
longtext |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
ONLINE |
tinyint(1) |
(NULL) |
YES |
MUL |
0 |
|
select,insert,update,references |
|
|
OTHER |
tinyint(1) |
(NULL) |
YES |
MUL |
0 |
|
select,insert,update,references |
|
|
PROCESSING |
tinyint(1) |
(NULL) |
YES |
MUL |
0 |
|
select,insert,update,references |
|
|
PUBTOWEB |
tinyint(1) |
(NULL) |
YES |
MUL |
0 |
|
select,insert,update,references |
|
|
SEMINAR |
tinyint(1) |
(NULL) |
YES |
MUL |
0 |
|
select,insert,update,references |
|
|
SEMINARDTE |
date |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
STATE |
tinyint(1) |
(NULL) |
YES |
MUL |
0 |
|
select,insert,update,references |
|
|
STATUS |
char(1) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
TRANNO |
int(11) |
(NULL) |
NO |
PRI |
(NULL) |
auto_increment |
select,insert,update,references |
|
|
USERINIT |
char(3) |
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 |
|
course |
0 |
PRIMARY |
1 |
TRANNO |
A |
1276 |
(NULL) |
(NULL) |
|
BTREE |
|
|
course |
1 |
TRANNO |
1 |
TRANNO |
A |
(NULL) |
(NULL) |
(NULL) |
|
BTREE |
|
|
course |
1 |
COURSENO |
1 |
COURSENO |
A |
(NULL) |
(NULL) |
(NULL) |
YES |
BTREE |
|
|
course |
1 |
COURSE |
1 |
PROVIDERNO |
A |
(NULL) |
(NULL) |
(NULL) |
YES |
BTREE |
|
|
course |
1 |
PROVIDERNO |
1 |
PROVIDERNO |
A |
(NULL) |
(NULL) |
(NULL) |
YES |
BTREE |
|
|
course |
1 |
COURSENAME |
1 |
COURSENAME |
A |
(NULL) |
(NULL) |
(NULL) |
YES |
BTREE |
|
|
course |
1 |
PUBTOWEB |
1 |
PUBTOWEB |
A |
(NULL) |
(NULL) |
(NULL) |
YES |
BTREE |
|
|
course |
1 |
CLASSROOM |
1 |
CLASSROOM |
A |
(NULL) |
(NULL) |
(NULL) |
YES |
BTREE |
|
|
course |
1 |
COURSETYPE |
1 |
COURSETYPE |
A |
(NULL) |
(NULL) |
(NULL) |
YES |
BTREE |
|
|
course |
1 |
CORRESPOND |
1 |
CORRESPOND |
A |
(NULL) |
(NULL) |
(NULL) |
YES |
BTREE |
|
|
course |
1 |
FEDERAL |
1 |
FEDERAL |
A |
(NULL) |
(NULL) |
(NULL) |
YES |
BTREE |
|
|
course |
1 |
ONLINE |
1 |
ONLINE |
A |
(NULL) |
(NULL) |
(NULL) |
YES |
BTREE |
|
|
course |
1 |
OTHER |
1 |
OTHER |
A |
(NULL) |
(NULL) |
(NULL) |
YES |
BTREE |
|
|
course |
1 |
PROCESSING |
1 |
PROCESSING |
A |
(NULL) |
(NULL) |
(NULL) |
YES |
BTREE |
|
|
course |
1 |
SEMINAR |
1 |
SEMINAR |
A |
(NULL) |
(NULL) |
(NULL) |
YES |
BTREE |
|
|
course |
1 |
STATE |
1 |
STATE |
A |
(NULL) |
(NULL) |
(NULL) |
YES |
BTREE |
|
Back
| coursetype |
| Fields |
| Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
|
CODE |
char(6) |
latin1_swedish_ci |
YES |
MUL |
(NULL) |
|
select,insert,update,references |
|
|
DESCRIP |
varchar(60) |
latin1_swedish_ci |
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 |
|
coursetype |
0 |
PRIMARY |
1 |
TRANNO |
A |
3 |
(NULL) |
(NULL) |
|
BTREE |
|
|
coursetype |
1 |
CODE |
1 |
CODE |
A |
(NULL) |
(NULL) |
(NULL) |
YES |
BTREE |
|
|
coursetype |
1 |
DESCRIP |
1 |
DESCRIP |
A |
(NULL) |
(NULL) |
(NULL) |
YES |
BTREE |
|
|
coursetype |
1 |
TRANNO |
1 |
TRANNO |
A |
(NULL) |
(NULL) |
(NULL) |
|
BTREE |
|
Back
| crime |
| Fields |
| Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
|
ID |
int(11) |
(NULL) |
YES |
MUL |
(NULL) |
|
select,insert,update,references |
|
|
AUTHORITY |
varchar(50) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
CASENO |
varchar(30) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
CRIMEDATE |
date |
(NULL) |
YES |
MUL |
(NULL) |
|
select,insert,update,references |
|
|
CRIMETYPE |
varchar(20) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
OFFENSE |
varchar(50) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
OUTCOME |
longtext |
latin1_swedish_ci |
YES |
|
(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 |
|
crime |
0 |
PRIMARY |
1 |
TRANNO |
A |
8115 |
(NULL) |
(NULL) |
|
BTREE |
|
|
crime |
1 |
ID |
1 |
ID |
A |
(NULL) |
(NULL) |
(NULL) |
YES |
BTREE |
|
|
crime |
1 |
TRANNO |
1 |
TRANNO |
A |
(NULL) |
(NULL) |
(NULL) |
|
BTREE |
|
|
crime |
1 |
CRIMEDATE |
1 |
CRIMEDATE |
A |
(NULL) |
(NULL) |
(NULL) |
YES |
BTREE |
|
Back
| dba |
| Fields |
| Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
|
DBAID |
int(11) |
(NULL) |
NO |
PRI |
(NULL) |
auto_increment |
select,insert,update,references |
|
|
LICID |
int(11) |
(NULL) |
YES |
MUL |
(NULL) |
|
select,insert,update,references |
|
|
FIRM |
varchar(50) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
STATUS |
char(1) |
latin1_swedish_ci |
YES |
|
A |
|
select,insert,update,references |
|
|
DATECANCELED |
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 |
|
dba |
0 |
PRIMARY |
1 |
DBAID |
A |
43 |
(NULL) |
(NULL) |
|
BTREE |
|
|
dba |
1 |
LIDID |
1 |
LICID |
A |
(NULL) |
(NULL) |
(NULL) |
YES |
BTREE |
|
|
dba |
1 |
DBAID |
1 |
DBAID |
A |
(NULL) |
(NULL) |
(NULL) |
|
BTREE |
|
|
dba |
1 |
PK_DBA |
1 |
DBAID |
A |
(NULL) |
(NULL) |
(NULL) |
|
BTREE |
|
Back
| educ |
| Fields |
| Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
|
ID |
int(11) |
(NULL) |
YES |
MUL |
(NULL) |
|
select,insert,update,references |
|
|
COURSEDATE |
date |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
COURSENAME |
varchar(60) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
HOURS |
decimal(8,2) |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
PROVIDER |
varchar(50) |
latin1_swedish_ci |
YES |
MUL |
(NULL) |
|
select,insert,update,references |
|
|
PROVIDERNO |
int(11) |
(NULL) |
YES |
MUL |
(NULL) |
|
select,insert,update,references |
|
|
TCHGDATE |
date |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
TRANNO |
int(11) |
(NULL) |
NO |
PRI |
(NULL) |
auto_increment |
select,insert,update,references |
|
|
COURSENO |
char(15) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
COURSETYPE |
char(6) |
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 |
|
educ |
0 |
PRIMARY |
1 |
TRANNO |
A |
78306 |
(NULL) |
(NULL) |
|
BTREE |
|
|
educ |
1 |
id |
1 |
ID |
A |
(NULL) |
(NULL) |
(NULL) |
YES |
BTREE |
|
|
educ |
1 |
PROVIDER |
1 |
PROVIDER |
A |
(NULL) |
(NULL) |
(NULL) |
YES |
BTREE |
|
|
educ |
1 |
TRANNO |
1 |
TRANNO |
A |
(NULL) |
(NULL) |
(NULL) |
|
BTREE |
|
|
educ |
1 |
EDUC |
1 |
PROVIDERNO |
A |
(NULL) |
(NULL) |
(NULL) |
YES |
BTREE |
|
Back
| enfahnote |
| Fields |
| Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
|
ID |
int(11) |
(NULL) |
YES |
MUL |
(NULL) |
|
select,insert,update,references |
|
|
DATE |
date |
(NULL) |
YES |
MUL |
(NULL) |
|
select,insert,update,references |
|
|
NOTES |
longtext |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
USERNAME |
char(6) |
latin1_swedish_ci |
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 |
|
enfahnote |
0 |
PRIMARY |
1 |
TRANNO |
A |
249 |
(NULL) |
(NULL) |
|
BTREE |
|
|
enfahnote |
1 |
DATE |
1 |
DATE |
A |
(NULL) |
(NULL) |
(NULL) |
YES |
BTREE |
|
|
enfahnote |
1 |
ID |
1 |
ID |
A |
(NULL) |
(NULL) |
(NULL) |
YES |
BTREE |
|
|
enfahnote |
1 |
USERNAME |
1 |
USERNAME |
A |
(NULL) |
(NULL) |
(NULL) |
YES |
BTREE |
|
|
enfahnote |
1 |
TRANNO |
1 |
TRANNO |
A |
(NULL) |
(NULL) |
(NULL) |
|
BTREE |
|
Back
| enfanrpt |
| Fields |
| Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
|
ID |
int(11) |
(NULL) |
NO |
PRI |
(NULL) |
auto_increment |
select,insert,update,references |
|
|
ARID |
char(10) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
CALENDARYR |
char(4) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
FILENUMBER |
varchar(20) |
latin1_swedish_ci |
YES |
MUL |
(NULL) |
|
select,insert,update,references |
|
|
FINALCMR |
varchar(40) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
FINALDUEDT |
date |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
FINALLTRDT |
date |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
FINALRCPDT |
date |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
FIRSTCMR |
varchar(40) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
FIRSTDUEDT |
date |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
FIRSTLTRDT |
date |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
FIRSTRCPDT |
date |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
HEARINGNO |
varchar(50) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
INDVID |
int(11) |
(NULL) |
YES |
MUL |
(NULL) |
|
select,insert,update,references |
|
|
PENALTYAMT |
decimal(8,2) |
(NULL) |
YES |
|
0.00 |
|
select,insert,update,references |
|
|
PENALTYCHK |
varchar(20) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
PENALTYDT |
date |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
PENALTYPD |
decimal(8,2) |
(NULL) |
YES |
|
0.00 |
|
select,insert,update,references |
|
|
RNAGDORDDT |
date |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
RNISSUEDDT |
date |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
RNSIGNEDDT |
date |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
STATUS |
char(1) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
NOTES |
longtext |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
APPLDEADDT |
date |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
APPLFORDDT |
date |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
APPLRCVDT |
date |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
APPLWDDT |
date |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
CLCTAMT |
decimal(8,2) |
(NULL) |
YES |
|
0.00 |
|
select,insert,update,references |
|
|
CLCTATMPDT |
date |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
CONTINUDT |
date |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
COSTASSCMP |
decimal(8,2) |
(NULL) |
YES |
|
0.00 |
|
select,insert,update,references |
|
|
COSTCHKNO |
varchar(16) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
COSTRCVDDT |
date |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
DRAFTPFDDT |
date |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
EXCEPTDLDT |
date |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
EXCEPTFLDT |
date |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
EXCERSPNDT |
date |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
FINALORDDT |
date |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
MOTINDISMD |
date |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
NATOFRES |
varchar(50) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
NOHSENTDT |
date |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
ORGHRNGDT |
date |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
PFD |
date |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
REHEARDT |
date |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
RESOLVEDDT |
date |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
COMPLTRCV |
date |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
COMPLNT |
varchar(50) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
COMPLIANT |
varchar(50) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
RSPFLWPDT |
date |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
FISCALYR |
char(4) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
RECIVEDDT |
date |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
CHECKNO |
varchar(20) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
PAIDAMT |
decimal(8,2) |
(NULL) |
YES |
|
0.00 |
|
select,insert,update,references |
|
|
FIRSTLTTDT |
date |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
FNOTICEDT |
date |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
RSPANSRCVD |
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 |
|
enfanrpt |
0 |
PRIMARY |
1 |
ID |
A |
2973 |
(NULL) |
(NULL) |
|
BTREE |
|
|
enfanrpt |
1 |
INDVID |
1 |
INDVID |
A |
(NULL) |
(NULL) |
(NULL) |
YES |
BTREE |
|
|
enfanrpt |
1 |
FILENUMBER |
1 |
FILENUMBER |
A |
(NULL) |
(NULL) |
(NULL) |
YES |
BTREE |
|
|
enfanrpt |
1 |
ID |
1 |
ID |
A |
(NULL) |
(NULL) |
(NULL) |
|
BTREE |
|
Back
| enfapphrng |
| Fields |
| Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
|
ID |
int(11) |
(NULL) |
NO |
PRI |
(NULL) |
auto_increment |
select,insert,update,references |
|
|
AHID |
char(8) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
APPLDEADDT |
date |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
APPLFORDDT |
date |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
APPLRCVDT |
date |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
APPLWDDT |
date |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
CMPTNAME |
varchar(50) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
CLCTAMT |
decimal(8,2) |
(NULL) |
YES |
|
0.00 |
|
select,insert,update,references |
|
|
CLCTATMPDT |
date |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
CONTINUDT |
date |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
COSTASSCMP |
decimal(8,2) |
(NULL) |
YES |
|
0.00 |
|
select,insert,update,references |
|
|
COSTCHKNO |
varchar(16) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
COSTRCVDDT |
date |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
DRAFTPFDDT |
date |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
EXCEPTDLDT |
date |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
EXCEPTFLDT |
date |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
EXCERSPNDT |
date |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
FILENUMBER |
int(11) |
(NULL) |
YES |
MUL |
(NULL) |
|
select,insert,update,references |
|
|
FINALORDDT |
date |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
FISCALYR |
int(11) |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
HEARINGNO |
varchar(50) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
LEGALASSN |
varchar(50) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
LEGLASSNID |
char(4) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
LEGLASSNDT |
date |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
INDVID |
int(11) |
(NULL) |
YES |
MUL |
(NULL) |
|
select,insert,update,references |
|
|
MOTINDISMD |
date |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
NATOFRES |
varchar(50) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
NOHSENTDT |
date |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
NOTES |
varchar(50) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
ORGHRNGDT |
date |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
PFD |
date |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
REHEARDT |
date |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
RESOLVEDDT |
date |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
STATUS |
char(1) |
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 |
|
enfapphrng |
0 |
PRIMARY |
1 |
ID |
A |
180 |
(NULL) |
(NULL) |
|
BTREE |
|
|
enfapphrng |
1 |
FILENUMBER |
1 |
FILENUMBER |
A |
(NULL) |
(NULL) |
(NULL) |
YES |
BTREE |
|
|
enfapphrng |
1 |
INDVID |
1 |
INDVID |
A |
(NULL) |
(NULL) |
(NULL) |
YES |
BTREE |
|
|
enfapphrng |
1 |
ID |
1 |
ID |
A |
(NULL) |
(NULL) |
(NULL) |
|
BTREE |
|
Back
| enfarnote |
| Fields |
| Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
|
ID |
int(11) |
(NULL) |
YES |
MUL |
(NULL) |
|
select,insert,update,references |
|
|
DATE |
date |
(NULL) |
YES |
MUL |
(NULL) |
|
select,insert,update,references |
|
|
NOTES |
longtext |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
USERNAME |
char(6) |
latin1_swedish_ci |
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 |
|
enfarnote |
0 |
PRIMARY |
1 |
TRANNO |
A |
6267 |
(NULL) |
(NULL) |
|
BTREE |
|
|
enfarnote |
1 |
USERNAME |
1 |
USERNAME |
A |
(NULL) |
(NULL) |
(NULL) |
YES |
BTREE |
|
|
enfarnote |
1 |
ID |
1 |
ID |
A |
(NULL) |
(NULL) |
(NULL) |
YES |
BTREE |
|
|
enfarnote |
1 |
TRANNO |
1 |
TRANNO |
A |
(NULL) |
(NULL) |
(NULL) |
|
BTREE |
|
|
enfarnote |
1 |
DATE |
1 |
DATE |
A |
(NULL) |
(NULL) |
(NULL) |
YES |
BTREE |
|
Back
| enfcode |
| Fields |
| Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
|
ID |
int(11) |
(NULL) |
NO |
PRI |
(NULL) |
auto_increment |
select,insert,update,references |
|
|
RESOLUTION |
varchar(50) |
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 |
|
enfcode |
0 |
PRIMARY |
1 |
ID |
A |
15 |
(NULL) |
(NULL) |
|
BTREE |
|
Back
| enfdanote |
| Fields |
| Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
|
ID |
int(11) |
(NULL) |
YES |
MUL |
(NULL) |
|
select,insert,update,references |
|
|
DATE |
date |
(NULL) |
YES |
MUL |
(NULL) |
|
select,insert,update,references |
|
|
NOTES |
longtext |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
USERNAME |
char(6) |
latin1_swedish_ci |
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 |
|
enfdanote |
0 |
PRIMARY |
1 |
TRANNO |
A |
1064 |
(NULL) |
(NULL) |
|
BTREE |
|
|
enfdanote |
1 |
DATE |
1 |
DATE |
A |
(NULL) |
(NULL) |
(NULL) |
YES |
BTREE |
|
|
enfdanote |
1 |
TRANNO |
1 |
TRANNO |
A |
(NULL) |
(NULL) |
(NULL) |
|
BTREE |
|
|
enfdanote |
1 |
ID |
1 |
ID |
A |
(NULL) |
(NULL) |
(NULL) |
YES |
BTREE |
|
|
enfdanote |
1 |
USERNAME |
1 |
USERNAME |
A |
(NULL) |
(NULL) |
(NULL) |
YES |
BTREE |
|
Back
| enfdisact |
| Fields |
| Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
|
ID |
int(11) |
(NULL) |
NO |
PRI |
(NULL) |
auto_increment |
select,insert,update,references |
|
|
EID |
char(8) |
latin1_swedish_ci |
YES |
MUL |
(NULL) |
|
select,insert,update,references |
|
|
INDVID |
int(11) |
(NULL) |
YES |
MUL |
(NULL) |
|
select,insert,update,references |
|
|
ASSESSEDDT |
date |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
APPEALDLNDT |
date |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
DISACTTYPE |
int(11) |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
ENFTYPE |
varchar(50) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
ENFTYPEID |
int(11) |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
ENFACTION |
int(11) |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
EVENTTYPE |
int(11) |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
FILEDT |
date |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
FILENUMBER |
int(11) |
(NULL) |
YES |
MUL |
(NULL) |
|
select,insert,update,references |
|
|
FISCALYR |
int(11) |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
HEARINGNO |
varchar(20) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
INVESTASSN |
varchar(50) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
INVESTASSNID |
char(3) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
LEGALASSN |
varchar(50) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
LEGALASSNID |
char(3) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
NATOFCMP |
varchar(50) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
NATOFCMPID |
int(11) |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
NOTES |
longtext |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
ORDERDT |
date |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
OTHERACT |
int(11) |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
PENALTYAMT |
decimal(8,2) |
(NULL) |
YES |
|
0.00 |
|
select,insert,update,references |
|
|
PENALTYDUEDT |
date |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
RCVDDT |
date |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
RCVDAMT |
decimal(8,2) |
(NULL) |
YES |
|
0.00 |
|
select,insert,update,references |
|
|
RCVDAMTDT |
date |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
RESTDUEDT |
date |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
RESTPAIDDT |
date |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
RESTPAIDAMT |
decimal(8,2) |
(NULL) |
YES |
|
0.00 |
|
select,insert,update,references |
|
|
RESTORDAMT |
decimal(8,2) |
(NULL) |
YES |
|
0.00 |
|
select,insert,update,references |
|
|
STATUS |
char(1) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
APPLDEADDT |
date |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
APPLFORDDT |
date |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
APPLRCVDT |
date |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
APPLWDDT |
date |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
CLCTAMT |
decimal(8,2) |
(NULL) |
YES |
|
0.00 |
|
select,insert,update,references |
|
|
CLCTATMPDT |
date |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
RESOLVEDDT |
date |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
CONTINUDT |
date |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
COSTASSCMP |
decimal(8,2) |
(NULL) |
YES |
|
0.00 |
|
select,insert,update,references |
|
|
COSTCHKNO |
varchar(16) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
COSTRCVDDT |
date |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
DRAFTPFDDT |
date |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
EXCEPTDLDT |
date |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
EXCEPTFLDT |
date |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
EXCERSPNDT |
date |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
FINALORDDT |
date |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
MOTINDISMD |
date |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
NATOFRES |
varchar(50) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
NOHSENTDT |
date |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
ORGHRNGDT |
date |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
PFD |
date |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
REHEARDT |
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 |
|
enfdisact |
0 |
PRIMARY |
1 |
ID |
A |
608 |
(NULL) |
(NULL) |
|
BTREE |
|
|
enfdisact |
1 |
ID |
1 |
ID |
A |
(NULL) |
(NULL) |
(NULL) |
|
BTREE |
|
|
enfdisact |
1 |
indvid |
1 |
INDVID |
A |
(NULL) |
(NULL) |
(NULL) |
YES |
BTREE |
|
|
enfdisact |
1 |
EID |
1 |
EID |
A |
(NULL) |
(NULL) |
(NULL) |
YES |
BTREE |
|
|
enfdisact |
1 |
FILENUMBER |
1 |
FILENUMBER |
A |
(NULL) |
(NULL) |
(NULL) |
YES |
BTREE |
|
Back
| enfindv |
| Fields |
| Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
|
ID |
int(11) |
(NULL) |
NO |
PRI |
(NULL) |
auto_increment |
select,insert,update,references |
|
|
EID |
char(8) |
latin1_swedish_ci |
YES |
MUL |
(NULL) |
|
select,insert,update,references |
|
|
INDVID |
int(11) |
(NULL) |
YES |
MUL |
(NULL) |
|
select,insert,update,references |
|
|
ASSESSEDDT |
date |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
appealdlndt |
date |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
ENFTYPE |
varchar(50) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
ENFTYPEID |
int(11) |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
ENFACTION |
int(11) |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
EVENTTYPE |
int(11) |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
FILEDT |
date |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
FILENUMBER |
int(11) |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
FISCALYR |
int(11) |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
HEARINGNO |
varchar(20) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
ORDERDT |
date |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
OTHERACT |
int(11) |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
PENALTYAMT |
decimal(8,2) |
(NULL) |
YES |
|
0.00 |
|
select,insert,update,references |
|
|
PENALTYDUEDT |
date |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
RCVDDT |
date |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
RCVDAMT |
decimal(8,2) |
(NULL) |
YES |
|
0.00 |
|
select,insert,update,references |
|
|
RCVDAMTDT |
date |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
RESTDUEDT |
date |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
RESTPAIDDT |
date |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
RESTPAIDAMT |
decimal(8,2) |
(NULL) |
YES |
|
0.00 |
|
select,insert,update,references |
|
|
RESTORDAMT |
decimal(8,2) |
(NULL) |
YES |
|
0.00 |
|
select,insert,update,references |
|
|
APPLDEADDT |
date |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
APPLFORDDT |
date |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
APPLRCVDT |
date |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
APPLWDDT |
date |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
CLCTAMT |
decimal(8,2) |
(NULL) |
YES |
|
0.00 |
|
select,insert,update,references |
|
|
CLCTATMPDT |
date |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
RESOLVEDDT |
date |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
CONTINUDT |
date |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
COSTASSCMP |
decimal(8,2) |
(NULL) |
YES |
|
0.00 |
|
select,insert,update,references |
|
|
COSTCHKNO |
varchar(16) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
COSTRCVDDT |
date |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
DRAFTPFDDT |
date |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
EXCEPTDLDT |
date |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
EXCEPTFLDT |
date |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
EXCERSPNDT |
date |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
FINALORDDT |
date |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
MOTINDISMD |
date |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
NATOFRES |
varchar(50) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
NOHSENTDT |
date |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
ORGHRNGDT |
date |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
PFD |
date |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
REHEARDT |
date |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
RESPONDENT |
varchar(40) |
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 |
|
enfindv |
0 |
PRIMARY |
1 |
ID |
A |
798 |
(NULL) |
(NULL) |
|
BTREE |
|
|
enfindv |
1 |
EID |
1 |
EID |
A |
(NULL) |
(NULL) |
(NULL) |
YES |
BTREE |
|
|
enfindv |
1 |
INDVID |
1 |
INDVID |
A |
(NULL) |
(NULL) |
(NULL) |
YES |
BTREE |
|
|
enfindv |
1 |
ID |
1 |
ID |
A |
(NULL) |
(NULL) |
(NULL) |
|
BTREE |
|
Back
| examine |
| Fields |
| Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
|
ID |
int(11) |
(NULL) |
YES |
MUL |
(NULL) |
|
select,insert,update,references |
|
|
INITIAL |
char(3) |
latin1_swedish_ci |
YES |
MUL |
(NULL) |
|
select,insert,update,references |
|
|
EXAMCOMPLT |
date |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
EXAMREPDFT |
date |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
EXAMREPISS |
date |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
EXAMRRDATE |
date |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
EXAMSCHDD |
date |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
EXAMSCHDT |
char(3) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
NOLOSP |
int(11) |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
RATING |
int(11) |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
REFGCDATE |
date |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
EXAMNO |
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 |
|
examine |
0 |
PRIMARY |
1 |
EXAMNO |
A |
2825 |
(NULL) |
(NULL) |
|
BTREE |
|
|
examine |
1 |
ID |
1 |
ID |
A |
(NULL) |
(NULL) |
(NULL) |
YES |
BTREE |
|
|
examine |
1 |
INITIAL |
1 |
INITIAL |
A |
(NULL) |
(NULL) |
(NULL) |
YES |
BTREE |
|
|
examine |
1 |
EXAMNO |
1 |
EXAMNO |
A |
(NULL) |
(NULL) |
(NULL) |
|
BTREE |
|
Back
| examiner |
| Fields |
| Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
|
INITIALS |
char(3) |
latin1_swedish_ci |
NO |
PRI |
|
|
select,insert,update,references |
|
|
NAME |
varchar(40) |
latin1_swedish_ci |
YES |
MUL |
(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 |
|
examiner |
0 |
PRIMARY |
1 |
INITIALS |
A |
35 |
(NULL) |
(NULL) |
|
BTREE |
|
|
examiner |
1 |
NAME |
1 |
NAME |
A |
(NULL) |
(NULL) |
(NULL) |
YES |
BTREE |
|
Back
| examnote |
| Fields |
| Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
|
ID |
int(11) |
(NULL) |
YES |
MUL |
(NULL) |
|
select,insert,update,references |
|
|
EXAMNO |
int(11) |
(NULL) |
YES |
MUL |
(NULL) |
|
select,insert,update,references |
|
|
DATE |
date |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
NOTES |
longtext |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
NOTETYPE |
char(6) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
USERNAME |
char(6) |
latin1_swedish_ci |
YES |
|
(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 |
|
examnote |
0 |
PRIMARY |
1 |
TRANNO |
A |
5105 |
(NULL) |
(NULL) |
|
BTREE |
|
|
examnote |
1 |
ID |
1 |
ID |
A |
(NULL) |
(NULL) |
(NULL) |
YES |
BTREE |
|
|
examnote |
1 |
EXAMNO |
1 |
EXAMNO |
A |
(NULL) |
(NULL) |
(NULL) |
YES |
BTREE |
|
|
examnote |
1 |
TRANNO |
1 |
TRANNO |
A |
(NULL) |
(NULL) |
(NULL) |
|
BTREE |
|
Back
| examtype |
| Fields |
| Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
|
CODE |
char(6) |
latin1_swedish_ci |
NO |
PRI |
|
|
select,insert,update,references |
|
|
DESCRIP |
varchar(180) |
latin1_swedish_ci |
YES |
MUL |
(NULL) |
|
select,insert,update,references |
|
|
PREFENTRY |
longtext |
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 |
|
examtype |
0 |
PRIMARY |
1 |
CODE |
A |
2 |
(NULL) |
(NULL) |
|
BTREE |
|
|
examtype |
1 |
DESCRIP |
1 |
DESCRIP |
A |
(NULL) |
(NULL) |
(NULL) |
YES |
BTREE |
|
Back
| gen |
| Fields |
| Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
|
ID |
int(11) |
(NULL) |
NO |
PRI |
(NULL) |
auto_increment |
select,insert,update,references |
|
|
ADDR1 |
varchar(32) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
ADDR2 |
varchar(32) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
BILLDATE |
date |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
BKFEE |
decimal(8,2) |
(NULL) |
YES |
|
0.00 |
|
select,insert,update,references |
|
|
CITY |
varchar(20) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
CONTEMAIL |
varchar(50) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
CONVFEE |
decimal(8,2) |
(NULL) |
YES |
|
0.00 |
|
select,insert,update,references |
|
|
DOWNLDTIME |
varchar(11) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
FAX |
varchar(12) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
FBIDPSFEE |
decimal(8,2) |
(NULL) |
YES |
|
0.00 |
|
select,insert,update,references |
|
|
LOFEE |
decimal(8,2) |
(NULL) |
YES |
|
0.00 |
|
select,insert,update,references |
|
|
MBARYEAR |
char(4) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
MBFEE |
decimal(8,2) |
(NULL) |
YES |
|
0.00 |
|
select,insert,update,references |
|
|
NOTES |
longtext |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
ORGCODE |
char(6) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
ORGNAME |
varchar(50) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
RECOVERYFE |
decimal(8,2) |
(NULL) |
YES |
|
0.00 |
|
select,insert,update,references |
|
|
ST |
char(2) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
TEL |
varchar(12) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
SMTPIP |
varchar(22) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
USEAMEX |
tinyint(1) |
(NULL) |
YES |
|
0 |
|
select,insert,update,references |
|
|
USEDISCOV |
tinyint(1) |
(NULL) |
YES |
|
0 |
|
select,insert,update,references |
|
|
USEMC |
tinyint(1) |
(NULL) |
YES |
|
0 |
|
select,insert,update,references |
|
|
USEVISA |
tinyint(1) |
(NULL) |
YES |
|
0 |
|
select,insert,update,references |
|
|
VERSIONNO |
char(10) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
ZIPCODE |
char(10) |
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 |
|
gen |
0 |
PRIMARY |
1 |
ID |
A |
1 |
(NULL) |
(NULL) |
|
BTREE |
|
Back
| holidays |
| Fields |
| Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
|
FSCYR |
int(11) |
(NULL) |
YES |
MUL |
(NULL) |
|
select,insert,update,references |
|
|
DESCRIPTION |
varchar(20) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
DAY |
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 |
|
holidays |
1 |
FSCYR |
1 |
FSCYR |
A |
(NULL) |
(NULL) |
(NULL) |
YES |
BTREE |
|
Back
| 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 |
|
|
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 |
|
|
BKFAX |
varchar(12) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
BKEMAIL |
varchar(50) |
latin1_swedish_ci |
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 |
|
|
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 |
|
|
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 |
|
|
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 |
|
|
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 |
|
|
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(2) |
latin1_swedish_ci |
YES |
MUL |
(NULL) |
|
select,insert,update,references |
|
|
RECVRYFUND |
decimal(8,2) |
(NULL) |
YES |
|
0.00 |
|
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(2) |
latin1_swedish_ci |
YES |
MUL |
(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 |
60232 |
(NULL) |
(NULL) |
|
BTREE |
|
|
indv |
1 |
namelf |
1 |
NAMELF |
A |
(NULL) |
(NULL) |
(NULL) |
YES |
BTREE |
|
|
indv |
1 |
rectype |
1 |
RECTYPE |
A |
(NULL) |
(NULL) |
(NULL) |
YES |
BTREE |
|
|
indv |
1 |
Status |
1 |
STATUS |
A |
(NULL) |
(NULL) |
(NULL) |
YES |
BTREE |
|
|
indv |
1 |
SSNO |
1 |
SSNO |
A |
(NULL) |
(NULL) |
(NULL) |
YES |
BTREE |
|
|
indv |
1 |
EXPDATE |
1 |
EXPDATE |
A |
(NULL) |
(NULL) |
(NULL) |
YES |
BTREE |
|
|
indv |
1 |
FIRM |
1 |
FIRM |
A |
(NULL) |
(NULL) |
(NULL) |
YES |
BTREE |
|
|
indv |
1 |
FNAME |
1 |
FNAME |
A |
(NULL) |
(NULL) |
(NULL) |
YES |
BTREE |
|
|
indv |
1 |
LICDATE |
1 |
LICDATE |
A |
(NULL) |
(NULL) |
(NULL) |
YES |
BTREE |
|
|
indv |
1 |
LNAME |
1 |
LNAME |
A |
(NULL) |
(NULL) |
(NULL) |
YES |
BTREE |
|
|
indv |
1 |
PIN |
1 |
PIN |
A |
(NULL) |
(NULL) |
(NULL) |
YES |
BTREE |
|
|
indv |
1 |
ORIGLICDAT |
1 |
ORIGLICDAT |
A |
(NULL) |
(NULL) |
(NULL) |
YES |
BTREE |
|
|
indv |
1 |
BCITY |
1 |
BCITY |
A |
(NULL) |
(NULL) |
(NULL) |
YES |
BTREE |
|
|
indv |
1 |
ID |
1 |
ID |
A |
(NULL) |
(NULL) |
(NULL) |
|
BTREE |
|
Back
| indvnote |
| Fields |
| Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
|
ID |
int(11) |
(NULL) |
YES |
MUL |
(NULL) |
|
select,insert,update,references |
|
|
DATE |
date |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
NOTES |
longtext |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
NOTETYPE |
char(8) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
USERNAME |
char(6) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
TRANNO |
int(11) |
(NULL) |
YES |
MUL |
(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 |
|
indvnote |
1 |
ID |
1 |
ID |
A |
(NULL) |
(NULL) |
(NULL) |
YES |
BTREE |
|
|
indvnote |
1 |
TRANNO |
1 |
TRANNO |
A |
(NULL) |
(NULL) |
(NULL) |
YES |
BTREE |
|
Back
| invsgtr |
| Fields |
| Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
|
INITIALS |
varchar(3) |
latin1_swedish_ci |
YES |
MUL |
(NULL) |
|
select,insert,update,references |
|
|
NAME |
varchar(40) |
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 |
|
invsgtr |
1 |
INITIALS |
1 |
INITIALS |
A |
(NULL) |
(NULL) |
(NULL) |
YES |
BTREE |
|
Back
| legal |
| Fields |
| Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
|
INITIALS |
varchar(3) |
latin1_swedish_ci |
YES |
MUL |
(NULL) |
|
select,insert,update,references |
|
|
NAME |
varchar(40) |
latin1_swedish_ci |
YES |
MUL |
(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 |
|
legal |
1 |
NAME |
1 |
NAME |
A |
(NULL) |
(NULL) |
(NULL) |
YES |
BTREE |
|
|
legal |
1 |
INITIALS |
1 |
INITIALS |
A |
(NULL) |
(NULL) |
(NULL) |
YES |
BTREE |
|
Back
| 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
| lictype |
| Fields |
| Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
|
CODE |
varchar(4) |
latin1_swedish_ci |
YES |
MUL |
(NULL) |
|
select,insert,update,references |
|
|
DESCRIP |
varchar(30) |
latin1_swedish_ci |
YES |
MUL |
(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 |
|
lictype |
1 |
DESCRIP |
1 |
DESCRIP |
A |
(NULL) |
(NULL) |
(NULL) |
YES |
BTREE |
|
|
lictype |
1 |
CODE |
1 |
CODE |
A |
(NULL) |
(NULL) |
(NULL) |
YES |
BTREE |
|
Back
| loadeduc |
| Fields |
| Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
|
ID |
int(11) |
(NULL) |
YES |
MUL |
(NULL) |
|
select,insert,update,references |
|
|
COURSEDATE |
date |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
COURSENAME |
varchar(40) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
HOURS |
decimal(17,2) |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
PROVIDER |
varchar(40) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
PROVIDERNO |
int(11) |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
TRANNO |
int(11) |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
WEBUPDDATE |
date |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
OKTOUPDATE |
tinyint(1) |
(NULL) |
YES |
|
0 |
|
select,insert,update,references |
|
| Indexes |
| Table | Non unique |
Key name |
Seq in index |
Column name |
Collation | Cardinality | Sub part |
Packed | Null | Index type |
Comment |
|
loadeduc |
1 |
ID |
1 |
ID |
A |
(NULL) |
(NULL) |
(NULL) |
YES |
BTREE |
|
Back
| loadindv |
| Fields |
| Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
|
ID |
int(11) |
(NULL) |
NO |
PRI |
(NULL) |
auto_increment |
select,insert,update,references |
|
|
ACTLICTYPE |
varchar(2) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
ACTLICNO |
varchar(10) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
ACTLICEXP |
date |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
AFFIDAVIT |
tinyint(1) |
(NULL) |
YES |
|
0 |
|
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 |
|
|
BCITY |
varchar(24) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
BFAX |
varchar(12) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
BST |
varchar(2) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
BTEL |
varchar(17) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
BZIPCODE |
varchar(10) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
CRIMEOFF |
varchar(1) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
|
varchar(50) |
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 |
varchar(2) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
HZIPCODE |
varchar(10) |
latin1_swedish_ci |
YES |
|
(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 |
|
|
LOCARCITY |
varchar(20) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
LOCARST |
varchar(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 |
|
|
LOCMRADDR |
varchar(34) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
LOCMRCONT |
varchar(40) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
LOCMRCITY |
varchar(20) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
LOCMRST |
varchar(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 |
|
|
PAID |
decimal(17,2) |
(NULL) |
YES |
|
0.00 |
|
select,insert,update,references |
|
|
PAIDDATE |
date |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
USERINIT |
varchar(3) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
WEBUPDDATE |
date |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
OKTOUPDATE |
tinyint(1) |
(NULL) |
YES |
|
0 |
|
select,insert,update,references |
|
|
AUTHORITY |
varchar(50) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
CASENO |
varchar(30) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
OFFENSE |
varchar(30) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
OUTCOME |
longtext |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
CRIMEDATE |
date |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
TRACKNO |
varchar(14) |
latin1_swedish_ci |
YES |
MUL |
(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 |
|
loadindv |
0 |
PRIMARY |
1 |
ID |
A |
0 |
(NULL) |
(NULL) |
|
BTREE |
|
|
loadindv |
1 |
ID |
1 |
ID |
A |
(NULL) |
(NULL) |
(NULL) |
|
BTREE |
|
|
loadindv |
1 |
TRACKNO |
1 |
TRACKNO |
A |
(NULL) |
(NULL) |
(NULL) |
YES |
BTREE |
|
Back
| loans |
| Fields |
| Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
|
COID |
int(11) |
(NULL) |
YES |
MUL |
(NULL) |
|
select,insert,update,references |
|
|
LICID |
int(11) |
(NULL) |
YES |
MUL |
(NULL) |
|
select,insert,update,references |
|
|
LOANID |
int(11) |
(NULL) |
NO |
PRI |
(NULL) |
auto_increment |
select,insert,update,references |
|
|
AGREESWBRNCH |
tinyint(1) |
(NULL) |
YES |
|
0 |
|
select,insert,update,references |
|
|
AGREESWLO |
tinyint(1) |
(NULL) |
YES |
|
0 |
|
select,insert,update,references |
|
|
LASTCHGDAT |
date |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
REPORTYEAR |
int(11) |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
TOTACTBR |
double |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
TOTCONVCDO |
double |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
TOTCONVCNO |
int(11) |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
TOTCONVNDO |
double |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
TOTCONVNNO |
int(11) |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
TOTDOLVOL |
double |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
TOTFHADOL |
double |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
TOTFHALOAN |
int(11) |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
TOTHCDOL |
double |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
TOTHCLOAN |
int(11) |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
TOTNOLOANS |
int(11) |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
TOTOTHERDO |
double |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
TOTOTHERNO |
int(11) |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
TOTOTHERTY |
varchar(10) |
latin1_swedish_ci |
YES |
MUL |
(NULL) |
|
select,insert,update,references |
|
|
TOTSPONLO |
double |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
TOTVADOL |
double |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
TOTVALOAN |
int(11) |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
USERINIT |
varchar(3) |
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 |
|
loans |
0 |
PRIMARY |
1 |
LOANID |
A |
57170 |
(NULL) |
(NULL) |
|
BTREE |
|
|
loans |
1 |
coid |
1 |
COID |
A |
(NULL) |
(NULL) |
(NULL) |
YES |
BTREE |
|
|
loans |
1 |
loid |
1 |
LICID |
A |
(NULL) |
(NULL) |
(NULL) |
YES |
BTREE |
|
|
loans |
1 |
LICID |
1 |
LICID |
A |
(NULL) |
(NULL) |
(NULL) |
YES |
BTREE |
|
|
loans |
1 |
TOTOTHERTY |
1 |
TOTOTHERTY |
A |
(NULL) |
(NULL) |
(NULL) |
YES |
BTREE |
|
Back
| lookup |
| Fields |
| Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
|
MODULE |
varchar(30) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
LOOKUP |
varchar(30) |
latin1_swedish_ci |
YES |
MUL |
(NULL) |
|
select,insert,update,references |
|
|
TABLENAME |
varchar(11) |
latin1_swedish_ci |
YES |
MUL |
(NULL) |
|
select,insert,update,references |
|
|
SORTFIELD |
varchar(10) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
PRIMEKEY |
varchar(10) |
latin1_swedish_ci |
YES |
MUL |
(NULL) |
|
select,insert,update,references |
|
|
LOOKUPTYPE |
varchar(1) |
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 |
|
lookup |
1 |
LOOKUP |
1 |
LOOKUP |
A |
(NULL) |
(NULL) |
(NULL) |
YES |
BTREE |
|
|
lookup |
1 |
TABLENAME |
1 |
TABLENAME |
A |
(NULL) |
(NULL) |
(NULL) |
YES |
BTREE |
|
|
lookup |
1 |
PRIMEKEY |
1 |
PRIMEKEY |
A |
(NULL) |
(NULL) |
(NULL) |
YES |
BTREE |
|
Back
| mailcode |
| Fields |
| Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
|
MAILCODE |
varchar(2) |
latin1_swedish_ci |
YES |
MUL |
(NULL) |
|
select,insert,update,references |
|
|
DESCRIP |
varchar(20) |
latin1_swedish_ci |
YES |
MUL |
(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 |
|
mailcode |
1 |
DESCRIP |
1 |
DESCRIP |
A |
(NULL) |
(NULL) |
(NULL) |
YES |
BTREE |
|
|
mailcode |
1 |
MAILCODE |
1 |
MAILCODE |
A |
(NULL) |
(NULL) |
(NULL) |
YES |
BTREE |
|
Back
| notetype |
| Fields |
| Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
|
CODE |
varchar(8) |
latin1_swedish_ci |
YES |
MUL |
(NULL) |
|
select,insert,update,references |
|
|
DESCRIP |
varchar(180) |
latin1_swedish_ci |
YES |
MUL |
(NULL) |
|
select,insert,update,references |
|
|
PREFENTRY |
longtext |
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 |
|
notetype |
1 |
DESCRIP |
1 |
DESCRIP |
A |
(NULL) |
(NULL) |
(NULL) |
YES |
BTREE |
|
|
notetype |
1 |
CODE |
1 |
CODE |
A |
(NULL) |
(NULL) |
(NULL) |
YES |
BTREE |
|
Back
| prefix |
| Fields |
| Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
|
PREFIX |
varchar(3) |
latin1_swedish_ci |
YES |
MUL |
(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 |
|
prefix |
1 |
PREFIX |
1 |
PREFIX |
A |
(NULL) |
(NULL) |
(NULL) |
YES |
BTREE |
|
Back
| provaka |
| Fields |
| Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
|
PROVIDERNO |
int(11) |
(NULL) |
YES |
MUL |
(NULL) |
|
select,insert,update,references |
|
|
AKANAME |
varchar(50) |
latin1_swedish_ci |
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 |
|
provaka |
0 |
PRIMARY |
1 |
TRANNO |
A |
23 |
(NULL) |
(NULL) |
|
BTREE |
|
|
provaka |
1 |
AKANAME |
1 |
AKANAME |
A |
(NULL) |
(NULL) |
(NULL) |
YES |
BTREE |
|
|
provaka |
1 |
TRANNO |
1 |
TRANNO |
A |
(NULL) |
(NULL) |
(NULL) |
|
BTREE |
|
|
provaka |
1 |
PROVIDERNO |
1 |
PROVIDERNO |
A |
(NULL) |
(NULL) |
(NULL) |
YES |
BTREE |
|
Back
| provbranch |
| Fields |
| Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
|
PROVIDERNO |
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 |
|
|
CITY |
varchar(20) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
ST |
varchar(2) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
ZIPCODE |
varchar(10) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
TEL |
varchar(12) |
latin1_swedish_ci |
YES |
|
(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 |
|
provbranch |
0 |
PRIMARY |
1 |
TRANNO |
A |
43 |
(NULL) |
(NULL) |
|
BTREE |
|
|
provbranch |
1 |
PROVIDERNO |
1 |
PROVIDERNO |
A |
(NULL) |
(NULL) |
(NULL) |
YES |
BTREE |
|
|
provbranch |
1 |
TRANNO |
1 |
TRANNO |
A |
(NULL) |
(NULL) |
(NULL) |
|
BTREE |
|
Back
| provider |
| Fields |
| Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
|
PROVIDERNO |
int(11) |
(NULL) |
NO |
PRI |
(NULL) |
auto_increment |
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 |
|
|
AKA |
varchar(50) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
APPROVALDT |
date |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
CITY |
varchar(20) |
latin1_swedish_ci |
YES |
MUL |
(NULL) |
|
select,insert,update,references |
|
|
CONTACT |
varchar(34) |
latin1_swedish_ci |
YES |
MUL |
(NULL) |
|
select,insert,update,references |
|
|
|
varchar(50) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
FAX |
varchar(12) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
PROVNAME |
varchar(50) |
latin1_swedish_ci |
YES |
MUL |
(NULL) |
|
select,insert,update,references |
|
|
ST |
varchar(2) |
latin1_swedish_ci |
YES |
MUL |
(NULL) |
|
select,insert,update,references |
|
|
STATUS |
varchar(1) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
TEL1 |
varchar(12) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
TEL2 |
varchar(12) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
WEBSITE |
varchar(50) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
ZIPCODE |
varchar(10) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
FNAME |
varchar(20) |
latin1_swedish_ci |
YES |
MUL |
(NULL) |
|
select,insert,update,references |
|
|
LNAME |
varchar(20) |
latin1_swedish_ci |
YES |
MUL |
(NULL) |
|
select,insert,update,references |
|
|
MI |
varchar(10) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
USERINIT |
varchar(3) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
PUBTOWEB |
tinyint(1) |
(NULL) |
YES |
|
0 |
|
select,insert,update,references |
|
|
LASTCHGDAT |
date |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
NOTES |
longtext |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
MASTERNO |
int(11) |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
TITLE |
varchar(3) |
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 |
|
provider |
0 |
PRIMARY |
1 |
PROVIDERNO |
A |
182 |
(NULL) |
(NULL) |
|
BTREE |
|
|
provider |
1 |
ST |
1 |
ST |
A |
(NULL) |
(NULL) |
(NULL) |
YES |
BTREE |
|
|
provider |
1 |
LNAME |
1 |
LNAME |
A |
(NULL) |
(NULL) |
(NULL) |
YES |
BTREE |
|
|
provider |
1 |
PROVNAME |
1 |
PROVNAME |
A |
(NULL) |
(NULL) |
(NULL) |
YES |
BTREE |
|
|
provider |
1 |
CONTACT |
1 |
CONTACT |
A |
(NULL) |
(NULL) |
(NULL) |
YES |
BTREE |
|
|
provider |
1 |
CITY |
1 |
CITY |
A |
(NULL) |
(NULL) |
(NULL) |
YES |
BTREE |
|
|
provider |
1 |
FNAME |
1 |
FNAME |
A |
(NULL) |
(NULL) |
(NULL) |
YES |
BTREE |
|
Back
| rb_field |
| Fields |
| Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
|
TABLE_NAME |
varchar(60) |
latin1_swedish_ci |
NO |
|
|
|
select,insert,update,references |
|
|
FIELD_NAME |
varchar(60) |
latin1_swedish_ci |
NO |
|
|
|
select,insert,update,references |
|
|
FIELD_ALIAS |
varchar(60) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
DATATYPE |
varchar(60) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
SELECTABLE |
varchar(1) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
SEARCHABLE |
varchar(1) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
SORTABLE |
varchar(1) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
AUTOSEARCH |
varchar(1) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
MANDATORY |
varchar(1) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
| Indexes |
Back
| rb_folder |
| Fields |
| Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
|
FOLDER_ID |
int(11) |
(NULL) |
NO |
PRI |
(NULL) |
auto_increment |
select,insert,update,references |
|
|
FOLDER_NAME |
char(60) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
PARENT_ID |
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 |
|
rb_folder |
0 |
PRIMARY |
1 |
FOLDER_ID |
A |
9 |
(NULL) |
(NULL) |
|
BTREE |
|
Back
| rb_item |
| Fields |
| Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
|
ITEM_ID |
int(11) |
(NULL) |
NO |
PRI |
(NULL) |
auto_increment |
select,insert,update,references |
|
|
FOLDER_ID |
int(11) |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
ITEM_NAME |
char(60) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
ITEM_SIZE |
int(11) |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
ITEM_TYPE |
int(11) |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
MODIFIED |
int(11) |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
DELETED |
int(11) |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
TEMPLATE |
longtext |
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 |
|
rb_item |
0 |
PRIMARY |
1 |
ITEM_ID |
A |
140 |
(NULL) |
(NULL) |
|
BTREE |
|
Back
| rb_join |
| Fields |
| Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
|
TABLE_NAME1 |
varchar(60) |
latin1_swedish_ci |
NO |
MUL |
|
|
select,insert,update,references |
|
|
TABLE_NAME2 |
varchar(60) |
latin1_swedish_ci |
NO |
|
|
|
select,insert,update,references |
|
|
JOIN_TYPE |
varchar(60) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
FIELD_NAMES1 |
varchar(255) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
OPERATORS |
varchar(60) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
FIELD_NAMES2 |
varchar(60) |
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 |
|
rb_join |
1 |
table_name1 |
1 |
TABLE_NAME1 |
A |
(NULL) |
(NULL) |
(NULL) |
|
BTREE |
|
Back
| rb_table |
| Fields |
| Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
|
TABLE_NAME |
varchar(60) |
latin1_swedish_ci |
NO |
PRI |
|
|
select,insert,update,references |
|
|
TABLE_ALIAS |
varchar(60) |
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 |
|
rb_table |
0 |
PRIMARY |
1 |
TABLE_NAME |
A |
47 |
(NULL) |
(NULL) |
|
BTREE |
|
Back
| rectype |
| Fields |
| Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
|
RECTYPE |
varchar(4) |
latin1_swedish_ci |
YES |
MUL |
(NULL) |
|
select,insert,update,references |
|
|
DESCRIP |
varchar(20) |
latin1_swedish_ci |
YES |
MUL |
(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 |
|
rectype |
1 |
RECTYPE |
1 |
RECTYPE |
A |
(NULL) |
(NULL) |
(NULL) |
YES |
BTREE |
|
|
rectype |
1 |
DESCRIP |
1 |
DESCRIP |
A |
(NULL) |
(NULL) |
(NULL) |
YES |
BTREE |
|
Back
| reports |
| Fields |
| Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
|
REPTABLE |
varchar(8) |
latin1_swedish_ci |
YES |
MUL |
(NULL) |
|
select,insert,update,references |
|
|
REPORTNAME |
varchar(8) |
latin1_swedish_ci |
YES |
MUL |
(NULL) |
|
select,insert,update,references |
|
|
REPORTDESC |
varchar(40) |
latin1_swedish_ci |
YES |
MUL |
(NULL) |
|
select,insert,update,references |
|
|
REPORTDATE |
date |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
USERNAME |
varchar(15) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
SEND |
tinyint(1) |
(NULL) |
YES |
|
0 |
|
select,insert,update,references |
|
|
CRW |
tinyint(1) |
(NULL) |
YES |
|
0 |
|
select,insert,update,references |
|
|
TEMPLATE |
longtext |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
TRANNO |
int(11) |
(NULL) |
NO |
PRI |
(NULL) |
auto_increment |
select,insert,update,references |
|
|
REPTYPE |
varchar(1) |
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 |
|
reports |
0 |
PRIMARY |
1 |
TRANNO |
A |
0 |
(NULL) |
(NULL) |
|
BTREE |
|
|
reports |
1 |
REPTABLE |
1 |
REPTABLE |
A |
(NULL) |
(NULL) |
(NULL) |
YES |
BTREE |
|
|
reports |
1 |
REPORTNAME |
1 |
REPORTNAME |
A |
(NULL) |
(NULL) |
(NULL) |
YES |
BTREE |
|
|
reports |
1 |
REPORTDESC |
1 |
REPORTDESC |
A |
(NULL) |
(NULL) |
(NULL) |
YES |
BTREE |
|
|
reports |
1 |
TRANNO |
1 |
TRANNO |
A |
(NULL) |
(NULL) |
(NULL) |
|
BTREE |
|
|
reports |
1 |
RTRN |
1 |
REPTABLE |
A |
(NULL) |
(NULL) |
(NULL) |
YES |
BTREE |
|
|
reports |
1 |
RTRN |
2 |
REPORTNAME |
A |
(NULL) |
(NULL) |
(NULL) |
YES |
BTREE |
|
|
reports |
1 |
USERNAME |
1 |
REPTABLE |
A |
(NULL) |
(NULL) |
(NULL) |
YES |
BTREE |
|
|
reports |
1 |
USERNAME |
2 |
USERNAME |
A |
(NULL) |
(NULL) |
(NULL) |
YES |
BTREE |
|
|
reports |
1 |
RTRD |
1 |
REPORTNAME |
A |
(NULL) |
(NULL) |
(NULL) |
YES |
BTREE |
|
|
reports |
1 |
RTRD |
2 |
REPORTDESC |
A |
(NULL) |
(NULL) |
(NULL) |
YES |
BTREE |
|
Back
| reptable |
| Fields |
| Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
|
REPTABLE |
varchar(8) |
latin1_swedish_ci |
YES |
MUL |
(NULL) |
|
select,insert,update,references |
|
|
TABLEDESC |
varchar(30) |
latin1_swedish_ci |
YES |
MUL |
(NULL) |
|
select,insert,update,references |
|
|
DISPLAYSEQ |
int(11) |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
REPTYPE |
varchar(1) |
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 |
|
reptable |
1 |
TABLEDESC |
1 |
TABLEDESC |
A |
(NULL) |
(NULL) |
(NULL) |
YES |
BTREE |
|
|
reptable |
1 |
REPTABLE |
1 |
REPTABLE |
A |
(NULL) |
(NULL) |
(NULL) |
YES |
BTREE |
|
Back
| security |
| Fields |
| Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
|
TABLEName |
varchar(8) |
latin1_swedish_ci |
YES |
MUL |
(NULL) |
|
select,insert,update,references |
|
|
TYPE |
varchar(1) |
latin1_swedish_ci |
YES |
MUL |
(NULL) |
|
select,insert,update,references |
|
|
MODULE |
varchar(30) |
latin1_swedish_ci |
YES |
MUL |
(NULL) |
|
select,insert,update,references |
|
|
DESCRIP |
varchar(30) |
latin1_swedish_ci |
YES |
|
(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 |
|
security |
0 |
PRIMARY |
1 |
TRANNO |
A |
35 |
(NULL) |
(NULL) |
|
BTREE |
|
|
security |
1 |
TRANNO |
1 |
TRANNO |
A |
(NULL) |
(NULL) |
(NULL) |
|
BTREE |
|
|
security |
1 |
TYPE |
1 |
TYPE |
A |
(NULL) |
(NULL) |
(NULL) |
YES |
BTREE |
|
|
security |
1 |
MODULE |
1 |
MODULE |
A |
(NULL) |
(NULL) |
(NULL) |
YES |
BTREE |
|
|
security |
1 |
Table |
1 |
TABLEName |
A |
(NULL) |
(NULL) |
(NULL) |
YES |
BTREE |
|
Back
| states |
| Fields |
| Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
|
STATE |
varchar(2) |
latin1_swedish_ci |
YES |
MUL |
(NULL) |
|
select,insert,update,references |
|
|
STATENAME |
varchar(20) |
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 |
|
states |
1 |
STATE |
1 |
STATE |
A |
(NULL) |
(NULL) |
(NULL) |
YES |
BTREE |
|
Back
| status |
| Fields |
| Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
|
STATUS |
varchar(2) |
latin1_swedish_ci |
YES |
MUL |
(NULL) |
|
select,insert,update,references |
|
|
DESCRIP |
varchar(20) |
latin1_swedish_ci |
YES |
MUL |
(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 |
|
status |
1 |
STATUS |
1 |
STATUS |
A |
(NULL) |
(NULL) |
(NULL) |
YES |
BTREE |
|
|
status |
1 |
DESCRIP |
1 |
DESCRIP |
A |
(NULL) |
(NULL) |
(NULL) |
YES |
BTREE |
|
Back
| sysdata |
| Fields |
| Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
|
TABLENAME |
varchar(12) |
latin1_swedish_ci |
YES |
MUL |
(NULL) |
|
select,insert,update,references |
|
|
NextID |
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 |
|
sysdata |
1 |
TABLENAME |
1 |
TABLENAME |
A |
(NULL) |
(NULL) |
(NULL) |
YES |
BTREE |
|
Back
| testtable |
| Fields |
| Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
|
id |
int(10) unsigned |
(NULL) |
NO |
PRI |
(NULL) |
auto_increment |
select,insert,update,references |
|
|
name |
varchar(45) |
latin1_swedish_ci |
NO |
|
|
|
select,insert,update,references |
|
| Indexes |
| Table | Non unique |
Key name |
Seq in index |
Column name |
Collation | Cardinality | Sub part |
Packed | Null | Index type |
Comment |
|
testtable |
0 |
PRIMARY |
1 |
id |
A |
0 |
(NULL) |
(NULL) |
|
BTREE |
|
Back
| users |
| Fields |
| Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
|
ID |
int(11) |
(NULL) |
NO |
PRI |
(NULL) |
auto_increment |
select,insert,update,references |
|
|
LANID |
varchar(15) |
latin1_swedish_ci |
YES |
MUL |
(NULL) |
|
select,insert,update,references |
|
|
CRWLOC |
varchar(50) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
CURREXPONO |
int(11) |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
CURRMEETNO |
int(11) |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
|
varchar(50) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
FNAME |
varchar(15) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
INITIALS |
varchar(3) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
PASSWORD |
varchar(8) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
LNAME |
varchar(20) |
latin1_swedish_ci |
YES |
MUL |
(NULL) |
|
select,insert,update,references |
|
|
MI |
varchar(1) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
NOTES |
longtext |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
RIGHTS |
varchar(1) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
TEL |
varchar(12) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
SUPER |
tinyint(1) |
(NULL) |
YES |
|
0 |
|
select,insert,update,references |
|
|
USERGROUP |
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 |
|
users |
0 |
PRIMARY |
1 |
ID |
A |
80 |
(NULL) |
(NULL) |
|
BTREE |
|
|
users |
1 |
LNAME |
1 |
LNAME |
A |
(NULL) |
(NULL) |
(NULL) |
YES |
BTREE |
|
|
users |
1 |
LANID |
1 |
LANID |
A |
(NULL) |
(NULL) |
(NULL) |
YES |
BTREE |
|
Back
| usersec |
| Fields |
| Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
|
LANID |
varchar(15) |
latin1_swedish_ci |
YES |
MUL |
(NULL) |
|
select,insert,update,references |
|
|
TABLEName |
varchar(8) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
RIGHTS |
int(11) |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
c1 |
varchar(20) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
c2 |
varchar(20) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
TYPE |
varchar(1) |
latin1_swedish_ci |
YES |
MUL |
(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 |
|
usersec |
1 |
LANID |
1 |
LANID |
A |
(NULL) |
(NULL) |
(NULL) |
YES |
BTREE |
|
|
usersec |
1 |
TYPE |
1 |
TYPE |
A |
(NULL) |
(NULL) |
(NULL) |
YES |
BTREE |
|
|
usersec |
1 |
lanidtable |
1 |
LANID |
A |
(NULL) |
(NULL) |
(NULL) |
YES |
BTREE |
|
|
usersec |
1 |
lanidtable |
2 |
TABLEName |
A |
(NULL) |
(NULL) |
(NULL) |
YES |
BTREE |
|
Back
| ziptab |
| Fields |
| Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
|
ZIPCODE |
char(5) |
latin1_swedish_ci |
NO |
PRI |
|
|
select,insert,update,references |
|
|
CITY |
varchar(20) |
latin1_swedish_ci |
YES |
MUL |
(NULL) |
|
select,insert,update,references |
|
|
COUNTY |
varchar(40) |
latin1_swedish_ci |
YES |
MUL |
(NULL) |
|
select,insert,update,references |
|
|
TEL |
char(3) |
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 |
|
ziptab |
0 |
PRIMARY |
1 |
ZIPCODE |
A |
2675 |
(NULL) |
(NULL) |
|
BTREE |
|
|
ziptab |
1 |
COUNTY |
1 |
COUNTY |
A |
(NULL) |
(NULL) |
(NULL) |
YES |
BTREE |
|
|
ziptab |
1 |
CITY |
1 |
CITY |
A |
(NULL) |
(NULL) |
(NULL) |
YES |
BTREE |
|
|
ziptab |
1 |
ZIPCODE |
1 |
ZIPCODE |
A |
(NULL) |
(NULL) |
(NULL) |
|
BTREE |
|
Back