lic |
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 |
|
agreedOrderBalance |
decimal(8,2) |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
agreedOrderDue |
decimal(8,2) |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
agreedOrderPaid |
decimal(8,2) |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
CALENDARYR |
char(4) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
dismissalReason |
varchar(40) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
draftPFDResult |
varchar(20) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
FileLoc |
char(3) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
FILENUMBER |
varchar(20) |
latin1_swedish_ci |
YES |
MUL |
(NULL) |
|
select,insert,update,references |
|
FileType |
char(6) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
FinalAppRec |
date |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
FINALCMR |
varchar(40) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
FinalDeadline |
date |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
FINALDUEDT |
date |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
FINALLTRDT |
date |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
FinalOrdDisApp |
date |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
finalPFDResult |
varchar(20) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
FINALRCPDT |
date |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
FinalWithdrawn |
date |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
firHrHeldDt |
date |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
firHrSchedDt |
date |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
FIRSTCMR |
varchar(40) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
secCollAttDt |
date |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
firContOrdDt |
date |
(NULL) |
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 |
|
hearCostBalance |
decimal(8,2) |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
HEARINGNO |
varchar(50) |
latin1_swedish_ci |
YES |
MUL |
(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 |
|
recByAttorney |
date |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
RecbyEnfDt |
date |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
resultFOAppeal |
varchar(20) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
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 |
|
secContOrdDt |
date |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
secHrHeldDt |
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 |
|
susDue |
decimal(8,2) |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
susPaid |
decimal(8,2) |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
susBalance |
decimal(8,2) |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
susCheckNo |
varchar(10) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
susCMR |
varchar(40) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
susDatedue |
date |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
susDatePaid |
date |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
susLetterSent |
date |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
susOrdLiftSus |
date |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
susRcptConf |
date |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
susSusOrder |
date |
(NULL) |
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 |
|
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 |
|
LegalAssnId |
char(3) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
ordDismisAppeal |
date |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
exceptfldt |
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 |
2975 |
(NULL) |
(NULL) |
|
BTREE |
|
enfanrpt |
1 |
INDVID |
1 |
INDVID |
A |
2975 |
(NULL) |
(NULL) |
YES |
BTREE |
|
enfanrpt |
1 |
FILENUMBER |
1 |
FILENUMBER |
A |
1487 |
(NULL) |
(NULL) |
YES |
BTREE |
|
enfanrpt |
1 |
ID |
1 |
ID |
A |
2975 |
(NULL) |
(NULL) |
|
BTREE |
|
enfanrpt |
1 |
HEARINGNO |
1 |
HEARINGNO |
A |
156 |
(NULL) |
(NULL) |
YES |
BTREE |
|
Back