Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| application_number | varchar | 14 | √ | null |
|
|
||
| filing_date | varchar | 2147483647 | √ | null |
|
|
||
| invention_subject_matter | varchar | 2147483647 | √ | null |
|
|
||
| application_type | varchar | 2147483647 | √ | null |
|
|
||
| examiner_name_last | varchar | 2147483647 | √ | null |
|
|
||
| examiner_name_first | varchar | 2147483647 | √ | null |
|
|
||
| examiner_name_middle | varchar | 2147483647 | √ | null |
|
|
||
| examiner_id | varchar | 2147483647 | √ | null |
|
|
||
| examiner_art_unit | varchar | 2147483647 | √ | null |
|
|
||
| uspc_class | varchar | 2147483647 | √ | null |
|
|
||
| uspc_subclass | varchar | 2147483647 | √ | null |
|
|
||
| confirm_number | varchar | 2147483647 | √ | null |
|
|
||
| customer_number | varchar | 2147483647 | √ | null |
|
|
||
| atty_docket_number | varchar | 2147483647 | √ | null |
|
|
||
| appl_status_code | varchar | 2147483647 | √ | null |
|
|
||
| appl_status_date | varchar | 2147483647 | √ | null |
|
|
||
| file_location | varchar | 2147483647 | √ | null |
|
|
||
| file_location_date | varchar | 2147483647 | √ | null |
|
|
||
| earliest_pgpub_number | varchar | 2147483647 | √ | null |
|
|
||
| earliest_pgpub_date | varchar | 2147483647 | √ | null |
|
|
||
| wipo_pub_number | varchar | 2147483647 | √ | null |
|
|
||
| wipo_pub_date | varchar | 2147483647 | √ | null |
|
|
||
| patent_number | varchar | 2147483647 | √ | null |
|
|
||
| patent_issue_date | varchar | 2147483647 | √ | null |
|
|
||
| abandon_date | varchar | 2147483647 | √ | null |
|
|
||
| disposal_type | varchar | 2147483647 | √ | null |
|
|
||
| invention_title | varchar | 2147483647 | √ | null |
|
|
||
| small_entity_indicator | varchar | 2147483647 | √ | null |
|
|
||
| aia_first_to_file | varchar | 2147483647 | √ | null |
|
|
Table contained 11125755 rows