Synopsis
Table structure
|
Field |
Type |
Null |
Default |
Comments |
|
DOCUMENTID |
int(11) |
Yes |
NULL |
|
|
TITLE |
varchar(255) |
Yes |
NULL |
|
|
DOCTYPE |
int(11) |
Yes |
NULL |
|
|
DOCUMENTDATE |
date |
Yes |
NULL |
|
|
FILINGDATE |
date |
Yes |
NULL |
|
|
SERVICEDATE |
date |
Yes |
NULL |
|
|
EFFECTIVEDATE |
date |
Yes |
NULL |
|
|
ANSWERDATE |
date |
Yes |
NULL |
|
|
REPLYDATE |
date |
Yes |
NULL |
|
|
NEXTDUEDATE |
date |
Yes |
NULL |
|
|
NEXTDUEITEM |
varchar(50) |
Yes |
NULL |
|
|
INTEGEROFPAGES |
int(11) |
Yes |
NULL |
|
|
STAFF_ONLY |
char(1) |
Yes |
N |
|
|
FRPUBDATE |
date |
Yes |
NULL |
|
|
IMAGETYPE |
varchar(10) |
Yes |
NULL |
|
|
IMAGEPLATTER |
varchar(8) |
Yes |
NULL |
|
|
STATCITATION |
varchar(255) |
Yes |
NULL |
|
|
FRCITATION |
varchar(255) |
Yes |
NULL |
|
|
SUBMITTER |
text |
Yes |
NULL |
|
|
SUBMITTERSREP |
text |
Yes |
NULL |
|
|
RELATEDDOCKETS |
text |
Yes |
NULL |
|
|
RELATEDDOCS |
text |
Yes |
NULL |
|
|
ABSTRACT |
text |
Yes |
NULL |
|
|
DATA_ENTRY_DATE |
date |
Yes |
NULL |
|
|
IMAGE_FILE_SIZE |
int(11) |
Yes |
NULL |
|
|
RECEIVE_DATE |
date |
Yes |
NULL |
|
|
ACCEPTED_DATE |
date |
Yes |
NULL |
|
|
DOCUMENT_ORIGIN |
varchar(5) |
Yes |
NULL |
|
|
ORIGINAL_FILE_NAME |
varchar(255) |
Yes |
NULL |
|
|
WEBDOC_FILE_SIZE |
int(11) |
Yes |
NULL |
|
|
WEBDOC_PLATTER_NUM |
varchar(8) |
Yes |
NULL |
|
|
WEBDOC_FILE_TYPE |
varchar(10) |
Yes |
NULL |
|
|
DOC_PATH |
varchar(75) |
Yes |
NULL |
|
|
TITLE_NORM |
varchar(255) |
Yes |
NULL |
|
|
STATCITATION_NORM |
varchar(255) |
Yes |
NULL |
|
|
FRCITATION_NORM |
varchar(255) |
Yes |
NULL |
|
|
ABSTRACT_NORM |
text |
Yes |
NULL |
|
|
REASON_CODE |
int(11) |
Yes |
NULL |
|
|
OA |
varchar(5) |
Yes |
NULL |
|
|
DOCKET_TYPE |
char(1) |
Yes |
NULL |
|
|
DOCKET_EXIST |
char(1) |
Yes |
NULL |
|
|
DOCKET_INTEGER |
varchar(30) |
Yes |
NULL |
|
|
CONFIDENTIAL |
char(1) |
Yes |
NULL |
|
|
ES_DOC_PATH |
varchar(75) |
Yes |
NULL |
|
|
DOCUMENT_STATUS |
varchar(12) |
Yes |
NULL |
|
|
ASSIGNED_TO |
int(11) |
Yes |
NULL |
|
|
ORDERNUM |
varchar(20) |
Yes |
NULL |
|
|
FEDERAL_REGULATION |
char(1) |
Yes |
NULL |
|
|
OLDDOCKETINTEGER |
varchar(20) |
Yes |
NULL |
|
|
OLDSUBMITTER |
text |
Yes |
NULL |
|
|
OLDSUBMITTERREP |
text |
Yes |
NULL |
|
|
LAST_UPDATED |
date |
Yes |
NULL |
|
|
BATCH_COUNT |
int(11) |
Yes |
NULL |
|
|
ISBATCH |
int(11) |
Yes |
NULL |
|
|
DOCUMENT_SUBTYPE_ID |
int(11) |
Yes |
NULL |
|
|
CONTENTUPDATE |
int(11) |
Yes |
NULL |
|
|
METADATAUPDATE |
int(11) |
Yes |
NULL |
|
|
TRIGGER_UPD_DATE |
date |
Yes |
NULL |
|
|
SUBMITTER_UPDATED |
int(11) |
Yes |
NULL |
|
|
FDMS_DOCTYPE |
char(2) |
Yes |
NULL |
|
|
FDMS_DOCSUBTYPE |
int(11) |
Yes |
NULL |
|
|
MIGRATED |
int(11) |
Yes |
NULL |
|
|
MIGRATED2 |
int(11) |
Yes |
NULL |
|