lic |
| 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 |
|
CLOSEDDATE |
date |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
DISACTTYPE |
int(11) |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
DismissalReason |
varchar(20) |
latin1_swedish_ci |
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 |
|
FileLoc |
char(3) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
FILENUMBER |
int(11) |
(NULL) |
YES |
MUL |
(NULL) |
|
select,insert,update,references |
|
FileType |
char(6) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
FISCALYR |
int(11) |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
HEARINGNO |
varchar(20) |
latin1_swedish_ci |
YES |
MUL |
(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 |
|
RecByLegal |
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 |
|
sechrscheddt |
date |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
thirdhrscheddt |
date |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
firhrhelddt |
date |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
seccontorddt |
date |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
sechrhelddt |
date |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
dismissal |
varchar(16) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
draftpfdrslt |
varchar(50) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
finalpfdrslt |
varchar(50) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
hearCostBal |
decimal(8,2) |
(NULL) |
YES |
|
0.00 |
|
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 |
610 |
(NULL) |
(NULL) |
|
BTREE |
|
enfdisact |
1 |
ID |
1 |
ID |
A |
610 |
(NULL) |
(NULL) |
|
BTREE |
|
enfdisact |
1 |
indvid |
1 |
INDVID |
A |
610 |
(NULL) |
(NULL) |
YES |
BTREE |
|
enfdisact |
1 |
EID |
1 |
EID |
A |
610 |
(NULL) |
(NULL) |
YES |
BTREE |
|
enfdisact |
1 |
FILENUMBER |
1 |
FILENUMBER |
A |
610 |
(NULL) |
(NULL) |
YES |
BTREE |
|
enfdisact |
1 |
HEARINGNO |
1 |
HEARINGNO |
A |
87 |
(NULL) |
(NULL) |
YES |
BTREE |
|
Back