uspto Database

Columns

Table	Type	Column	Type	Size	Nulls	Default
priority_claim	Table	country	varchar	2147483647	√	null
continuation_in_part	Table	international_filing_date	varchar	2147483647	√	null
us_maths	Table	img_he	varchar	2147483647	√	null
pubref	Table	doc_id_country	varchar	2147483647	√	null
us_continuing_reissue	Table	doc_num	varchar	2147483647		null
pubref	Table	doc_id_kind	varchar	2147483647	√	null
continuation_in_part	Table	parent_grant_date	varchar	2147483647	√	null
class_cpc_further	Table	cpc_version_date	varchar	2147483647	√	null
class_cpc_main	Table	action_date	varchar	2147483647	√	null
us_nplcit	Table	us_nplcit_id_ctr	int4	10	√	null
perd_pta_summary	Table	application_number	varchar	14	√	null
perd_pat_term_adj	Table	application_number	varchar	14	√	null
us_related_doc_reexam	Table	parent_kind	varchar	2147483647	√	null
ref_cited	Table	patcit_num	varchar	2147483647	√	null
us_chem	Table	us_id_ctr	int4	10	√	null
agents	Table	seq	varchar	2147483647	√	null
pad_documentid	Table	rf_id	varchar	2147483647	√	null
perd_pta_summary	Table	nonoverlap_pto_delay	varchar	2147483647	√	null
agents	Table	doc_num	varchar	2147483647		null
us_deceased	Table	seq	varchar	2147483647	√	null
perd_correspondence_address	Table	correspondence_street_line_2	varchar	2147483647	√	null
class_ipcr	Table	class_ipcr_position	varchar	2147483647	√	null
reissue	Table	country	varchar	2147483647	√	null
perd_all_inventors	Table	inventor_rank	varchar	2147483647	√	null
sequence_list_p	Table	seq_list_id_ctr	int4	10	√	null
perd_continuity_parents	Table	application_number	varchar	14	√	null
class_cpc_comb_rank	Table	gen_office_country	varchar	2147483647	√	null
pad_assignor	Table	rf_id	varchar	2147483647	√	null
perd_application_data	Table	wipo_pub_date	varchar	2147483647	√	null
pad_documentid	Table	appno_date	varchar	2147483647	√	null
perd_application_data	Table	invention_title	varchar	2147483647	√	null
class_ipcr	Table	class_ipcr_main_group	varchar	2147483647	√	null
us_botanic	Table	doc_num	varchar	2147483647		null
description_heading	Table	head_text	varchar	2147483647	√	null
perd_correspondence_address	Table	correspondence_country_name	varchar	2147483647	√	null
draw_fig	Table	fig_id	varchar	2147483647	√	null
continuation_in_part	Table	cont_in_part_id_ctr	int4	10	√	null
us_ref_cited_class	Table	us_ref_cit_id_ctr	int4	10	√	null
pad_assignee	Table	ee_address_1	varchar	2147483647	√	null
applicant	Table	orgname	varchar	2147483647	√	null
reissue	Table	parent_pct_doc_number	varchar	2147483647	√	null
applicant	Table	us_app_id_ctr	int4	10	√	null
class_cpc_main	Table	gen_office_country	varchar	2147483647	√	null
pad_assignment	Table	frame_no	varchar	2147483647	√	null
class_cpc_main	Table	subgroup	varchar	2147483647	√	null
us_applicant	Table	addr_book_last_name	varchar	2147483647	√	null
perd_application_data	Table	examiner_name_middle	varchar	2147483647	√	null
pct_regional_fil	Table	us371c124_date	varchar	2147483647	√	null
class_cpc_comb_set	Table	doc_num	varchar	2147483647		null
continuation	Table	child_kind	varchar	2147483647	√	null
us_ref_cited	Table	patcit_num	varchar	2147483647	√	null
pubref	Table	ident	varchar	2147483647	√	null
dod_head	Table	heading_id	varchar	2147483647	√	null
pubref	Table	lang	varchar	2147483647	√	null
class_cpc_comb_rank	Table	class_status	varchar	2147483647	√	null
claim	Table	num	varchar	2147483647	√	null
related_pub	Table	date	varchar	2147483647	√	null
us_sequence_list	Table	doc_num	varchar	2147483647		null
us_prov_app	Table	doc_num	varchar	2147483647		null
reissue	Table	parent_pct_country	varchar	2147483647	√	null
description	Table	description_id_ctr	int4	10	√	null
perd_all_inventors	Table	application_number	varchar	14	√	null
class_cpc_further	Table	doc_num	varchar	2147483647		null
pubref	Table	doc_num	varchar	2147483647		null
related_doc	Table	parent_pct_country	varchar	2147483647	√	null
perd_correspondence_address	Table	correspondence_name_line_1	varchar	2147483647	√	null
priority_claim	Table	priority_claim_id_ctr	int4	10	√	null
pad_documentid_admin	Table	grant_doc_num	varchar	2147483647	√	null
class_cpc_main	Table	class_value	varchar	2147483647	√	null
agents	Table	firstname	varchar	2147483647	√	null
sequence_list	Table	seq_list_id_ctr	int4	10	√	null
pad_documentid	Table	appno_doc_num	varchar	2147483647	√	null
applicant	Table	mailcode	varchar	2147483647	√	null
class_cpc_main	Table	symbol_postition	varchar	2147483647	√	null
drawings	Table	id	varchar	2147483647	√	null
perd_pat_term_adj	Table	pta_sequence_number	varchar	2147483647	√	null
us_ref_cited	Table	patcit_doc_num	varchar	2147483647	√	null
us_sequence_list_p	Table	text	varchar	2147483647	√	null
class_cpc_comb_rank	Table	rank	varchar	2147483647	√	null
pad_documentid_admin	Table	admin_appl_id_for_grant	varchar	2147483647	√	null
substitution	Table	kind	varchar	2147483647	√	null
perd_correspondence_address	Table	correspondence_postal_code	varchar	2147483647	√	null
continuation	Table	kind	varchar	2147483647	√	null
appref	Table	date	varchar	2147483647	√	null
pubref	Table	us_term_extension	varchar	2147483647	√	null
continuation_in_part	Table	child_doc_date	varchar	2147483647	√	null
class_ipcr	Table	class_ipcr_date	varchar	2147483647	√	null
substitution	Table	doc_num	varchar	2147483647		null
continuation	Table	parent_pct_country	varchar	2147483647	√	null
related_doc	Table	parent_kind	varchar	2147483647	√	null
figures	Table	figures_id_ctr	int4	10	√	null
reissue	Table	parent_doc_number	varchar	2147483647	√	null
us_related_doc_reexam	Table	parent_grant_doc_num	varchar	2147483647	√	null
sequence_list	Table	carriers	varchar	2147483647	√	null
continuation_in_part	Table	parent_grant_country	varchar	2147483647	√	null
us_chem	Table	idref	varchar	2147483647	√	null
continuation	Table	parent_pct_doc_num	varchar	2147483647	√	null
us_exemplary_claim	Table	us_exemplary_claim_id_ctr	int4	10	√	null
inventor	Table	seq	varchar	2147483647	√	null
class_national	Table	country	varchar	2147483647	√	null
field_of_search_ipc	Table	class_ipc_edition	varchar	2147483647	√	null
class_cpc_comb_rank	Table	class_cpc_comb_rank_id_ctr	int4	10	√	null
description_p	Table	figref_text_p	varchar	2147483647	√	null
perd_application_data	Table	aia_first_to_file	varchar	2147483647	√	null
description	Table	id	varchar	2147483647	√	null
us_botanic	Table	variety	varchar	2147483647	√	null
description_p	Table	description_p_id_ctr	int4	10	√	null
us_sequence_list	Table	doc_id	varchar	2147483647	√	null
pubref	Table	class_ipc_edition	varchar	2147483647	√	null
us_ref_cited_class	Table	main_class	varchar	2147483647	√	null
perd_status_codes	Table	appl_status_code	varchar	2147483647	√	null
us_related_doc_reexam	Table	parent_grant_country	varchar	2147483647	√	null
perd_correspondence_address	Table	correspondence_region_code	varchar	2147483647	√	null
pubref	Table	us_microform_quantity	varchar	2147483647	√	null
us_sequence_list_p	Table	doc_num	varchar	2147483647		null
dod_head	Table	heading	varchar	2147483647	√	null
pad_documentid	Table	pgpub_doc_num	varchar	2147483647	√	null
related_doc	Table	doc_num	varchar	2147483647		null
class_cpc_comb_set	Table	class_cpc_comb_set_id_ctr	int4	10	√	null
applicant	Table	country_nationality	varchar	2147483647	√	null
perd_continuity_children	Table	child_application_number	varchar	2147483647	√	null
us_ref_cited_class	Table	doc_num	varchar	2147483647		null
us_maths	Table	img_alt	varchar	2147483647	√	null
class_ipcr	Table	class_ipcr_sub_group	varchar	2147483647	√	null
class_cpc_comb_rank	Table	doc_num	varchar	2147483647		null
us_deceased	Table	street	varchar	2147483647	√	null
dod_p	Table	description_id_ctr	int4	10	√	null
perd_application_data	Table	uspc_subclass	varchar	2147483647	√	null
us_related_doc_reexam	Table	parent_doc_num	varchar	2147483647	√	null
us_ref_cited	Table	patcit_name	varchar	2147483647	√	null
assignee	Table	assignee_id_ctr	int4	10	√	null
dod_p	Table	p_num	varchar	2147483647	√	null
pubref	Table	pub_date	varchar	2147483647	√	null
assist_examiner	Table	assist_exam_id_ctr	int4	10	√	null
us_applicant	Table	addr_first_name	varchar	2147483647	√	null
sequence_list_p	Table	seq_list_p_id_ctr	int4	10	√	null
perd_application_data	Table	application_number	varchar	14	√	null
assignee	Table	addr_book_addr_state	varchar	2147483647	√	null
class_cpc_main	Table	schema_orig_code	varchar	2147483647	√	null
reissue	Table	parent_kind	varchar	2147483647	√	null
class_ipc_further_class	Table	class_ipc_further_class	varchar	2147483647	√	null
pad_assignment	Table	last_update_dt	varchar	2147483647	√	null
perd_application_data	Table	file_location_date	varchar	2147483647	√	null
perd_transactions	Table	sequence_number	varchar	2147483647	√	null
continuation_in_part	Table	parent_grant_doc_num	varchar	2147483647	√	null
us_chem	Table	doc_num	varchar	2147483647		null
pad_assignor	Table	exec_dt	varchar	2147483647	√	null
pad_assignment	Table	caddress_1	varchar	2147483647	√	null
assignee	Table	doc_num	varchar	2147483647		null
class_cpc_comb_rank	Table	main_group	varchar	2147483647	√	null
pubref	Table	produced_date	varchar	2147483647	√	null
reissue	Table	parent_date	varchar	2147483647	√	null
assignee	Table	addr_book_first_name	varchar	2147483647	√	null
class_ipcr	Table	class_ipcr_country	varchar	2147483647	√	null
ref_cited	Table	patcit_country	varchar	2147483647	√	null
field_of_search_national	Table	doc_num	varchar	2147483647		null
pad_assignment	Table	purge_in	varchar	2147483647	√	null
us_ref_cited	Table	patcit_country	varchar	2147483647	√	null
ref_cited	Table	class_ipc_main_class	varchar	2147483647	√	null
dod_p	Table	dod_p_id_ctr	int4	10	√	null
inventor	Table	country	varchar	2147483647	√	null
us_deceased	Table	city	varchar	2147483647	√	null
us_field_of_class_search_ipcr	Table	doc_num	varchar	2147483647		null
pad_documentid	Table	appno_country	varchar	2147483647	√	null
us_applicant	Table	addr_state	varchar	2147483647	√	null
field_of_search_national	Table	field_of_search_national_id_ctr	int4	10	√	null
class_ipcr	Table	class_ipcr_class_level	varchar	2147483647	√	null
continuation	Table	date	varchar	2147483647	√	null
us_exemplary_claim	Table	doc_num	varchar	2147483647		null
us_sequence_list_p	Table	seq_list_id_ctr	int4	10	√	null
us_inventor	Table	first_name	varchar	2147483647	√	null
class_cpc_main	Table	doc_num	varchar	2147483647		null
draw_fig	Table	fig_num	varchar	2147483647	√	null
examiner	Table	doc_num	varchar	2147483647		null
us_applicant	Table	orgname	varchar	2147483647	√	null
pad_assignment_conveyance	Table	convey_ty	varchar	2147483647	√	null
perd_correspondence_address	Table	correspondence_name_line_2	varchar	2147483647	√	null
us_maths	Table	img_format	varchar	2147483647	√	null
description_p	Table	description_id_ctr	int4	10	√	null
perd_transactions	Table	event_code	varchar	2147483647	√	null
perd_correspondence_address	Table	application_number	varchar	14	√	null
deceased	Table	first_name	varchar	2147483647	√	null
us_ref_cited_class	Table	country	varchar	2147483647	√	null
us_chem	Table	mol_file	varchar	2147483647	√	null
class_ipcr	Table	class_ipcr_section	varchar	2147483647	√	null
pct_regional_fil	Table	pct_reg_fil_id_ctr	int4	10	√	null
us_prov_app	Table	date	varchar	2147483647	√	null
perd_application_data	Table	examiner_name_first	varchar	2147483647	√	null
assignee	Table	addr_book_addr_country	varchar	2147483647	√	null
us_nplcit	Table	othercit	varchar	2147483647	√	null
us_agents	Table	reg_type	varchar	2147483647	√	null
class_cpc_further	Table	class_status	varchar	2147483647	√	null
perd_event_codes	Table	event_description	varchar	2147483647	√	null
examiner	Table	department	varchar	2147483647	√	null
class_cpc_comb_set	Table	group_num	varchar	2147483647	√	null
abstract_p	Table	text	varchar	2147483647	√	null
continuation	Table	parent_kind	varchar	2147483647	√	null
us_applicant	Table	country_residence	varchar	2147483647	√	null
class_ipcr	Table	class_ipcr_status	varchar	2147483647	√	null
pubref	Table	status	varchar	2147483647	√	null
drawings	Table	doc_num	varchar	2147483647		null
perd_pta_summary	Table	applicant_delay	varchar	2147483647	√	null
continuation	Table	parent_country	varchar	2147483647	√	null
us_applicant	Table	addr_book_state	varchar	2147483647	√	null
figures	Table	doc_num	varchar	2147483647		null
inventor	Table	last_name	varchar	2147483647	√	null
perd_application_data	Table	appl_status_date	varchar	2147483647	√	null
related_pub	Table	country	varchar	2147483647	√	null
us_continuing_reissue	Table	child_doc_country	varchar	2147483647	√	null
pubref	Table	length_grant	varchar	2147483647	√	null
related_doc	Table	child_doc_date	varchar	2147483647	√	null
assignee	Table	orgname	varchar	2147483647	√	null
reissue	Table	child_doc_number	varchar	2147483647	√	null
pct_regional_pub	Table	doc_num	varchar	2147483647		null
perd_all_inventors	Table	inventor_region_code	varchar	2147483647	√	null
sequence_list_p	Table	num	varchar	2147483647	√	null
us_field_of_class_search_cpc_comb	Table	class_cpc_comb_text	varchar	2147483647	√	null
us_ref_cited	Table	class_cpc_text	varchar	2147483647	√	null
abstract_p	Table	doc_num	varchar	2147483647		null
pct_regional_pub	Table	date	varchar	2147483647	√	null
class_cpc_further	Table	gen_office_country	varchar	2147483647	√	null
us_inventor	Table	country	varchar	2147483647	√	null
us_ref_cited	Table	us_ref_cit_id_ctr	int4	10	√	null
pubref	Table	qq	varchar	2147483647	√	null
perd_foreign_priority	Table	foreign_parent_id	varchar	2147483647	√	null
class_national	Table	main_class	varchar	2147483647	√	null
pct_regional_pub	Table	pct_region_pub_id_ctr	int4	10	√	null
ref_cited	Table	class_ipc_edition	varchar	2147483647	√	null
pad_assignment	Table	caddress_3	varchar	2147483647	√	null
us_maths	Table	idrefs	varchar	2147483647	√	null
pubref	Table	claim_statement	varchar	2147483647	√	null
us_agents	Table	addr_city	varchar	2147483647	√	null
assignee	Table	addr_book_orgname	varchar	2147483647	√	null
class_cpc_further	Table	class_value	varchar	2147483647	√	null
related_doc	Table	parent_pct_date	varchar	2147483647	√	null
ref_cited	Table	category	varchar	2147483647	√	null
perd_application_data	Table	patent_number	varchar	2147483647	√	null
perd_application_data	Table	application_type	varchar	2147483647	√	null
sequence_list	Table	file_type	varchar	2147483647	√	null
applicant	Table	street	varchar	2147483647	√	null
priority_claim	Table	seq	varchar	2147483647	√	null
us_sequence_list	Table	seq_list_id_ctr	int4	10	√	null
pad_documentid	Table	pgpub_date	varchar	2147483647	√	null
nplcit	Table	doc_num	varchar	2147483647		null
us_agents	Table	country	varchar	2147483647	√	null
agents	Table	lastname	varchar	2147483647	√	null
us_inventor	Table	designation	varchar	2147483647	√	null
related_pub	Table	doc_number	varchar	2147483647	√	null
related_doc	Table	child_doc_number	varchar	2147483647	√	null
dod_p	Table	p_text	varchar	2147483647	√	null
description_heading	Table	head_id	varchar	2147483647	√	null
us_agents	Table	doc_num	varchar	2147483647		null
perd_application_data	Table	file_location	varchar	2147483647	√	null
class_cpc_further	Table	main_group	varchar	2147483647	√	null
perd_application_data	Table	uspc_class	varchar	2147483647	√	null
class_ipcr	Table	class_ipcr_subclass	varchar	2147483647	√	null
dod_head	Table	level	varchar	2147483647	√	null
perd_correspondence_address	Table	correspondence_city	varchar	2147483647	√	null
reissue	Table	child_country	varchar	2147483647	√	null
pubref	Table	main_class	varchar	2147483647	√	null
pubref	Table	no_of_claims	varchar	2147483647	√	null
us_continuing_reissue	Table	doc_id_date	varchar	2147483647	√	null
us_continuing_reissue	Table	child_doc_doc_num	varchar	2147483647	√	null
sequence_list	Table	file	varchar	2147483647	√	null
claim	Table	id	varchar	2147483647	√	null
perd_continuity_children	Table	child_filing_date	varchar	2147483647	√	null
examiner	Table	last_name	varchar	2147483647	√	null
continuation	Table	continuation_id_ctr	int4	10	√	null
us_agents	Table	us_agents_id_ctr	int4	10	√	null
perd_continuity_parents	Table	parent_filing_date	varchar	2147483647	√	null
continuation	Table	doc_num	varchar	2147483647		null
continuation	Table	parent_doc_num	varchar	2147483647	√	null
applicant	Table	state	varchar	2147483647	√	null
perd_application_data	Table	appl_status_code	varchar	2147483647	√	null
perd_application_data	Table	patent_issue_date	varchar	2147483647	√	null
perd_continuity_children	Table	application_number	varchar	14	√	null
us_prov_app	Table	us_prove_app_id_ctr	int4	10	√	null
description_heading	Table	description_heading_id_ctr	int4	10	√	null
us_field_of_class_search_cpc	Table	class_cpc_text_id_ctr	int4	10	√	null
ref_cited_further	Table	doc_num	varchar	2147483647		null
us_continuing_reissue	Table	doc_id_country	varchar	2147483647	√	null
related_pub	Table	kind	varchar	2147483647	√	null
claim	Table	claims_id_ctr	int4	10	√	null
perd_pat_term_adj	Table	responsible_party	varchar	2147483647	√	null
us_sequence_list	Table	file	varchar	2147483647	√	null
substitution	Table	country	varchar	2147483647	√	null
nplcit	Table	ref_id_ctr	int4	10	√	null
us_inventor	Table	last_name	varchar	2147483647	√	null
pad_documentid	Table	title	varchar	2147483647	√	null
perd_transactions	Table	recorded_date	varchar	2147483647	√	null
perd_continuity_children	Table	continuation_type	varchar	2147483647	√	null
perd_application_data	Table	earliest_pgpub_number	varchar	2147483647	√	null
us_ref_cited	Table	category	varchar	2147483647	√	null
perd_event_codes	Table	event_code	varchar	2147483647	√	null
pad_assignee	Table	ee_name	varchar	2147483647	√	null
perd_pat_term_adj	Table	term_extension_indicator	varchar	2147483647	√	null
us_field_of_class_search_cpc_comb	Table	class_cpc_comb_id_ctr	int4	10	√	null
hague_agreement	Table	reg_pub_date	varchar	2147483647	√	null
pct_regional_fil	Table	doc_num	varchar	2147483647		null
pubref	Table	class_locarno	varchar	2147483647	√	null
related_doc	Table	par_grant_country	varchar	2147483647	√	null
us_deceased	Table	first_name	varchar	2147483647	√	null
continuation_in_part	Table	kind	varchar	2147483647	√	null
us_maths	Table	img_id	varchar	2147483647	√	null
us_sequence_list_p	Table	num	varchar	2147483647	√	null
pad_documentid_admin	Table	admin_pat_no_for_appno	varchar	2147483647	√	null
pad_assignor	Table	ack_dt	varchar	2147483647	√	null
continuation	Table	country	varchar	2147483647	√	null
field_of_search_ipc	Table	field_of_search_ipc_id_ctr	int4	10	√	null
pad_assignment	Table	rf_id	varchar	2147483647	√	null
continuation_in_part	Table	parent_grant_kind	varchar	2147483647	√	null
pad_documentid	Table	grant_doc_num	varchar	2147483647	√	null
pad_documentid_admin	Table	rf_id	varchar	2147483647	√	null
related_pub	Table	doc_num	varchar	2147483647		null
pad_documentid	Table	lang	varchar	2147483647	√	null
perd_pat_term_adj	Table	pta_event_code	varchar	2147483647	√	null
us_field_of_class_search_cpc	Table	doc_num	varchar	2147483647		null
description_heading	Table	level	varchar	2147483647	√	null
perd_all_inventors	Table	inventor_name_middle	varchar	2147483647	√	null
ref_cited_further	Table	us_ref_class_cited_id_ctr	int4	10	√	null
class_cpc_comb_rank	Table	class_value	varchar	2147483647	√	null
us_deceased	Table	doc_num	varchar	2147483647		null
perd_transactions	Table	status_code	varchar	2147483647	√	null
us_applicant	Table	us_appl_id_ctr	int4	10	√	null
class_cpc_comb_rank	Table	version_indicator_date	varchar	2147483647	√	null
continuation	Table	parent_status	varchar	2147483647	√	null
continuation	Table	child_last_name	varchar	2147483647	√	null
class_cpc_comb_rank	Table	schema_orig_code	varchar	2147483647	√	null
pad_documentid	Table	pgpub_country	varchar	2147483647	√	null
assist_examiner	Table	doc_num	varchar	2147483647		null
us_applicant	Table	addr_book_city	varchar	2147483647	√	null
us_applicant	Table	addr_last_name	varchar	2147483647	√	null
us_inventor	Table	doc_num	varchar	2147483647		null
ref_cited	Table	patcit_kind	varchar	2147483647	√	null
continuation_in_part	Table	doc_num	varchar	2147483647		null
pad_assignment_conveyance	Table	employer_assign	varchar	2147483647	√	null
ref_cited	Table	patcit_name	varchar	2147483647	√	null
assignee	Table	first_name	varchar	2147483647	√	null
assignee	Table	last_name	varchar	2147483647	√	null
us_applicant	Table	addr_book_street	varchar	2147483647	√	null
perd_transactions	Table	application_number	varchar	14	√	null
pubref_abs	Table	doc_num	varchar	2147483647		null
us_continuing_reissue	Table	parent_grant_country	varchar	2147483647	√	null
related_doc	Table	par_grant_kind	varchar	2147483647	√	null
pubref	Table	prior_disclosure_affidavit_filed	varchar	2147483647	√	null
applicant	Table	doc_num	varchar	2147483647		null
class_ipcr	Table	class_ipcr_id_ctr	int4	10	√	null
us_applicant	Table	doc_num	varchar	2147483647		null
pct_regional_pub	Table	kind	varchar	2147483647	√	null
us_field_of_class_search_ipcr	Table	us_class_ipcr	int4	10	√	null
hague_agreement	Table	reg_num	varchar	2147483647	√	null
perd_application_data	Table	atty_docket_number	varchar	2147483647	√	null
us_maths	Table	img_content	varchar	2147483647	√	null
pubref	Table	doc_id_date	varchar	2147483647	√	null
perd_application_data	Table	invention_subject_matter	varchar	2147483647	√	null
perd_application_data	Table	examiner_art_unit	varchar	2147483647	√	null
class_cpc_further	Table	subgroup	varchar	2147483647	√	null
related_pub	Table	related_pub_id_ctr	int4	10	√	null
pubref	Table	invention_title	varchar	2147483647	√	null
continuation	Table	child_date	varchar	2147483647	√	null
related_doc	Table	child_doc_kind	varchar	2147483647	√	null
perd_all_inventors	Table	inventor_name_last	varchar	2147483647	√	null
reissue	Table	kind	varchar	2147483647	√	null
pad_documentid	Table	grant_country	varchar	2147483647	√	null
us_agents	Table	addr_first_name	varchar	2147483647	√	null
substitution	Table	child_doc_num	varchar	2147483647	√	null
priority_claim	Table	doc_num	varchar	2147483647		null
assist_examiner	Table	last_name	varchar	2147483647	√	null
applicant	Table	seq	varchar	2147483647	√	null
class_cpc_further	Table	schema_orig_code	varchar	2147483647	√	null
draw_fig	Table	draw_fig_id_ctr	int4	10	√	null
us_agents	Table	addr_state	varchar	2147483647	√	null
continuation	Table	child_first_name	varchar	2147483647	√	null
reissue	Table	parent_pct_kind	varchar	2147483647	√	null
class_cpc_further	Table	symbol_position	varchar	2147483647	√	null
us_nplcit	Table	us_ref_cit_id_ctr	int4	10	√	null
applicant	Table	firstname	varchar	2147483647	√	null
us_agents	Table	addr_last_name	varchar	2147483647	√	null
dod_p	Table	p_id	varchar	2147483647	√	null
reissue	Table	reissue_id_ctr	int4	10	√	null
perd_application_data	Table	small_entity_indicator	varchar	2147483647	√	null
us_applicant	Table	app_auth_cat	varchar	2147483647	√	null
perd_continuity_parents	Table	parent_application_number	varchar	2147483647	√	null
sequence_list_p	Table	id	varchar	2147483647	√	null
us_prov_app	Table	status	varchar	2147483647	√	null
sequence_list	Table	doc_id	varchar	2147483647	√	null
pubref	Table	classification	varchar	2147483647	√	null
pad_assignment	Table	reel_no	varchar	2147483647	√	null
continuation_in_part	Table	parent_pct_kind	varchar	2147483647	√	null
continuation	Table	parent_pct_date	varchar	2147483647	√	null
us_continuing_reissue	Table	parent_grant_date	varchar	2147483647	√	null
draw_fig	Table	doc_num	varchar	2147483647		null
pubref_abs	Table	abstract_id	varchar	2147483647	√	null
sequence_list_p	Table	text	varchar	2147483647	√	null
ref_cited_further	Table	further_classification	varchar	2147483647	√	null
us_inventor	Table	seq	varchar	2147483647	√	null
further_class	Table	doc_num	varchar	2147483647		null
hague_agreement	Table	doc_num	varchar	2147483647		null
perd_pta_summary	Table	pto_manual_adjustment	varchar	2147483647	√	null
us_field_of_class_search_cpc_comb	Table	doc_num	varchar	2147483647		null
deceased	Table	seq	varchar	2147483647	√	null
us_nplcit	Table	num	varchar	2147483647	√	null
class_ipc_further_class	Table	futher_class_id_ctr	int4	10	√	null
applicant	Table	lastname	varchar	2147483647	√	null
priority_claim	Table	date	varchar	2147483647	√	null
class_cpc_further	Table	subclass	varchar	2147483647	√	null
further_class	Table	further_class_id_ctr	int4	10	√	null
ref_cited_class	Table	doc_num	varchar	2147483647		null
related_doc	Table	child_country	varchar	2147483647	√	null
us_maths	Table	nb_file	varchar	2147483647	√	null
pad_assignee	Table	ee_address_2	varchar	2147483647	√	null
appref	Table	type	varchar	2147483647	√	null
class_cpc_main	Table	class_source	varchar	2147483647	√	null
us_applicant	Table	addr_city	varchar	2147483647	√	null
deceased	Table	doc_num	varchar	2147483647		null
us_maths	Table	img_wi	varchar	2147483647	√	null
continuation_in_part	Table	child_country	varchar	2147483647	√	null
reissue	Table	parent_pct_date	varchar	2147483647	√	null
us_prov_app	Table	kind	varchar	2147483647	√	null
reissue	Table	parent_status	varchar	2147483647	√	null
substitution	Table	child_country	varchar	2147483647	√	null
ref_cited_class	Table	main_class	varchar	2147483647	√	null
perd_application_data	Table	confirm_number	varchar	2147483647	√	null
hague_agreement	Table	filing_date	varchar	2147483647	√	null
pad_assignment	Table	caddress_4	varchar	2147483647	√	null
perd_pat_term_adj	Table	pta_event_date	varchar	2147483647	√	null
sequence_list	Table	doc_num	varchar	2147483647		null
class_cpc_further	Table	class	varchar	2147483647	√	null
figures	Table	num_of_drawing_sheets	varchar	2147483647	√	null
substitution	Table	parent_status	varchar	2147483647	√	null
class_cpc_comb_rank	Table	class	varchar	2147483647	√	null
related_doc	Table	parent_country	varchar	2147483647	√	null
continuation_in_part	Table	date	varchar	2147483647	√	null
perd_application_data	Table	abandon_date	varchar	2147483647	√	null
pad_assignment	Table	caddress_2	varchar	2147483647	√	null
appref	Table	country	varchar	2147483647	√	null
us_exemplary_claim	Table	us_examplary_claim	varchar	2147483647	√	null
reissue	Table	date	varchar	2147483647	√	null
claims	Table	doc_num	varchar	2147483647		null
pad_assignment	Table	cname	varchar	2147483647	√	null
pad_assignee	Table	rf_id	varchar	2147483647	√	null
nplcit	Table	num	varchar	2147483647	√	null
deceased	Table	dead_id_ctr	int4	10	√	null
appref	Table	doc_num	varchar	2147483647		null
pad_documentid_admin	Table	appno_doc_num	varchar	2147483647	√	null
us_ref_cited_class	Table	us_ref_class_cited_id_ctr	int4	10	√	null
us_related_doc_reexam	Table	parent_grant_kind	varchar	2147483647	√	null
description_heading	Table	description_id_ctr	int4	10	√	null
further_class	Table	further_classification	varchar	2147483647	√	null
ref_cited_class	Table	us_ref_class_cited_id_ctr	int4	10	√	null
assignee	Table	addr_book_role	varchar	2147483647	√	null
pad_assignment	Table	convey_text	varchar	2147483647	√	null
us_deceased	Table	postcode	varchar	2147483647	√	null
perd_application_data	Table	examiner_id	varchar	2147483647	√	null
class_cpc_further	Table	action_date	varchar	2147483647	√	null
us_inventor	Table	city	varchar	2147483647	√	null
perd_application_data	Table	disposal_type	varchar	2147483647	√	null
agents	Table	country	varchar	2147483647	√	null
reissue	Table	parent_country	varchar	2147483647	√	null
class_cpc_main	Table	class_status	varchar	2147483647	√	null
ref_cited	Table	class_cpc_text	varchar	2147483647	√	null
related_doc	Table	parent_status	varchar	2147483647	√	null
ref_cited	Table	doc_num	varchar	2147483647		null
agents	Table	orgname	varchar	2147483647	√	null
perd_pat_term_adj	Table	delay_duration	varchar	2147483647	√	null
field_of_search_ipc	Table	doc_num	varchar	2147483647		null
us_ref_cited	Table	doc_num	varchar	2147483647		null
pct_regional_fil	Table	us371c12_date	varchar	2147483647	√	null
field_of_search_ipc	Table	class_ipc_main_class	varchar	2147483647	√	null
us_related_doc_reexam	Table	child_doc_num	varchar	2147483647	√	null
us_deceased	Table	country	varchar	2147483647	√	null
pad_assignee	Table	ee_city	varchar	2147483647	√	null
class_cpc_comb_rank	Table	subclass	varchar	2147483647	√	null
dod_head	Table	description_id_ctr	int4	10	√	null
class_cpc_main	Table	section	varchar	2147483647	√	null
pad_assignment	Table	file_id	varchar	2147483647	√	null
ref_cited_class	Table	country	varchar	2147483647	√	null
pubref	Table	class_ipc_main_class	varchar	2147483647	√	null
pct_regional_fil	Table	country	varchar	2147483647	√	null
us_related_doc_reexam	Table	parent_date	varchar	2147483647	√	null
applicant	Table	app_type	varchar	2147483647	√	null
claim	Table	text	varchar	2147483647	√	null
us_related_doc_reexam	Table	doc_num	varchar	2147483647		null
abstract_p	Table	abstract_p_id_ctr	int4	10	√	null
perd_correspondence_address	Table	correspondence_region_name	varchar	2147483647	√	null
assist_examiner	Table	first_name	varchar	2147483647	√	null
us_related_doc_reexam	Table	us_relate_doc_reexam_ctr	int4	10	√	null
continuation_in_part	Table	parent_pct_date	varchar	2147483647	√	null
continuation	Table	international_filing_date	varchar	2147483647	√	null
dod_head	Table	dod_head_id_ctr	int4	10	√	null
us_botanic	Table	botanic_latin_name	varchar	2147483647	√	null
applicant	Table	country	varchar	2147483647	√	null
continuation_in_part	Table	parent_status	varchar	2147483647	√	null
class_ipcr	Table	class_ipcr_data_status	varchar	2147483647	√	null
related_doc	Table	related_doc_id_ctr	int4	10	√	null
description	Table	doc_num	varchar	2147483647		null
ref_cited	Table	patcit_date	varchar	2147483647	√	null
us_continuing_reissue	Table	doc_id_doc_num	varchar	2147483647	√	null
us_maths	Table	img_file	varchar	2147483647	√	null
ref_cited	Table	ref_id_ctr	int4	10	√	null
assignee	Table	addr_book_last_name	varchar	2147483647	√	null
pad_documentid_admin	Table	error	varchar	2147483647	√	null
pubref	Table	filename	varchar	2147483647	√	null
us_applicant	Table	addr_street	varchar	2147483647	√	null
priority_claim	Table	kind	varchar	2147483647	√	null
examiner	Table	examiner_id_ctr	int4	10	√	null
us_deceased	Table	last_name	varchar	2147483647	√	null
class_cpc_main	Table	main_group	varchar	2147483647	√	null
draw_fig	Table	drawing_id_ctr	int4	10	√	null
perd_all_inventors	Table	inventor_country_code	varchar	2147483647	√	null
us_agents	Table	first_name	varchar	2147483647	√	null
us_sequence_list	Table	carriers	varchar	2147483647	√	null
inventor	Table	city	varchar	2147483647	√	null
class_ipcr	Table	doc_num	varchar	2147483647		null
us_field_of_class_search_cpc	Table	text	varchar	2147483647	√	null
class_national	Table	additional	varchar	2147483647	√	null
agents	Table	reg_type	varchar	2147483647	√	null
perd_application_data	Table	wipo_pub_number	varchar	2147483647	√	null
perd_foreign_priority	Table	parent_country	varchar	2147483647	√	null
class_cpc_main	Table	subclass	varchar	2147483647	√	null
substitution	Table	date	varchar	2147483647	√	null
dod_head	Table	doc_num	varchar	2147483647		null
pubref	Table	class_national	varchar	2147483647	√	null
description_heading	Table	doc_num	varchar	2147483647		null
us_ref_cited	Table	patcit_kind	varchar	2147483647	√	null
us_continuing_reissue	Table	parent_grant_doc_num	varchar	2147483647	√	null
perd_all_inventors	Table	inventor_address_type	varchar	2147483647	√	null
examiner	Table	first_name	varchar	2147483647	√	null
applicant	Table	city	varchar	2147483647	√	null
perd_application_data	Table	earliest_pgpub_date	varchar	2147483647	√	null
agents	Table	agents_id_ctr	int4	10	√	null
related_doc	Table	parent_pct_doc_num	varchar	2147483647	√	null
pct_regional_fil	Table	kind	varchar	2147483647	√	null
field_of_search_national	Table	national_country	varchar	2147483647	√	null
pad_assignee	Table	ee_postcode	varchar	2147483647	√	null
applicant	Table	app_auth_cat	varchar	2147483647	√	null
us_chem	Table	cdx_file	varchar	2147483647	√	null
abstract_p	Table	num	varchar	2147483647	√	null
description_p	Table	doc_num	varchar	2147483647		null
perd_foreign_priority	Table	parent_country_code	varchar	2147483647	√	null
perd_application_data	Table	filing_date	varchar	2147483647	√	null
class_cpc_comb_rank	Table	class_data_source	varchar	2147483647	√	null
pubref	Table	series_code	varchar	2147483647	√	null
us_ref_cited	Table	patcit_date	varchar	2147483647	√	null
reissue	Table	doc_num	varchar	2147483647		null
substitution	Table	substitution_id_ctr	int4	10	√	null
perd_application_data	Table	customer_number	varchar	2147483647	√	null
continuation_in_part	Table	parent_pct_doc_num	varchar	2147483647	√	null
class_ipcr	Table	class_ipcr_class	varchar	2147483647	√	null
pad_assignment	Table	record_dt	varchar	2147483647	√	null
class_ipc_further_class	Table	doc_num	varchar	2147483647		null
related_doc	Table	parent_doc_num	varchar	2147483647	√	null
us_sequence_list	Table	file_type	varchar	2147483647	√	null
related_doc	Table	par_grant_doc_num	varchar	2147483647	√	null
pubref	Table	us_sir_flag	varchar	2147483647	√	null
assignee	Table	addr_book_addr_city	varchar	2147483647	√	null
continuation_in_part	Table	parent_pct_country	varchar	2147483647	√	null
pct_regional_pub	Table	country	varchar	2147483647	√	null
class_cpc_further	Table	section	varchar	2147483647	√	null
perd_continuity_parents	Table	continuation_type	varchar	2147483647	√	null
us_botanic	Table	us_botanic_id_ctr	int4	10	√	null
us_related_doc_reexam	Table	parent_grant_date	varchar	2147483647	√	null
related_doc	Table	parent_date	varchar	2147483647	√	null
us_continuing_reissue	Table	us_cont_reissue_ctr	int4	10	√	null
us_applicant	Table	app_type	varchar	2147483647	√	null
class_ipcr	Table	class_ipcr_action_date	varchar	2147483647	√	null
class_cpc_main	Table	class_cpc_main_id_ctr	int4	10	√	null
pubref	Table	dtd_version	varchar	2147483647	√	null
claim	Table	claim_id_ctr	int4	10	√	null
ref_cited_further	Table	ref_id_ctr	int4	10	√	null
perd_status_codes	Table	status_description	varchar	2147483647	√	null
inventor	Table	first_name	varchar	2147483647	√	null
related_doc	Table	parent_pct_kind	varchar	2147483647	√	null
deceased	Table	last_name	varchar	2147483647	√	null
ref_cited_class	Table	ref_id_ctr	int4	10	√	null
us_maths	Table	us_maths_id_ctr	int4	10	√	null
class_cpc_main	Table	class	varchar	2147483647	√	null
class_cpc_comb_rank	Table	subgroup	varchar	2147483647	√	null
inventor	Table	doc_num	varchar	2147483647		null
us_applicant	Table	addr_book_country	varchar	2147483647	√	null
perd_foreign_priority	Table	application_number	varchar	14	√	null
us_sequence_list_p	Table	seq_list_p_id_ctr	int4	10	√	null
us_applicant	Table	addr_country	varchar	2147483647	√	null
related_doc	Table	international_filing_date	varchar	2147483647	√	null
pad_assignee	Table	ee_state	varchar	2147483647	√	null
abstract_p	Table	pubref_abs_id_ctr	int4	10	√	null
pubref	Table	prosecution_app	varchar	2147483647	√	null
pad_assignment	Table	page_count	varchar	2147483647	√	null
continuation	Table	child_doc_num	varchar	2147483647	√	null
us_applicant	Table	addr_book_first_name	varchar	2147483647	√	null
description_p	Table	id_p	varchar	2147483647	√	null
figures	Table	num_of_figures	varchar	2147483647	√	null
pad_assignor	Table	or_name	varchar	2147483647	√	null
perd_correspondence_address	Table	correspondence_country_code	varchar	2147483647	√	null
perd_all_inventors	Table	inventor_name_first	varchar	2147483647	√	null
hague_agreement	Table	hague_agreement_id_ctr	int4	10	√	null
perd_pat_term_adj	Table	start_pta_sequence_number	varchar	2147483647	√	null
us_inventor	Table	state	varchar	2147483647	√	null
class_cpc_comb_rank	Table	section	varchar	2147483647	√	null
us_agents	Table	seq	varchar	2147483647	√	null
us_applicant	Table	designation	varchar	2147483647	√	null
applicant	Table	country_residence	varchar	2147483647	√	null
us_nplcit	Table	doc_num	varchar	2147483647		null
pubref_abs	Table	pubref_abs_id_ctr	int4	10	√	null
class_cpc_comb_rank	Table	action_date	varchar	2147483647	√	null
continuation	Table	parent_date	varchar	2147483647	√	null
continuation_in_part	Table	country	varchar	2147483647	√	null
assignee	Table	role	varchar	2147483647	√	null
field_of_search_national	Table	national_additional	varchar	2147483647	√	null
us_maths	Table	doc_num	varchar	2147483647		null
field_of_search_national	Table	national_clasification	varchar	2147483647	√	null
class_cpc_comb_rank	Table	symbol_position	varchar	2147483647	√	null
class_national	Table	doc_num	varchar	2147483647		null
class_cpc_further	Table	class_cpc_further_id_ctr	int4	10	√	null
us_related_doc_reexam	Table	child_country	varchar	2147483647	√	null
inventor	Table	inventor_id	int4	10	√	null
pad_documentid	Table	grant_date	varchar	2147483647	√	null
perd_correspondence_address	Table	correspondence_street_line_1	varchar	2147483647	√	null
hague_agreement	Table	reg_date	varchar	2147483647	√	null
abstract_p	Table	p_id	varchar	2147483647	√	null
class_national	Table	class_national_id_ctr	int4	10	√	null
claims	Table	id	varchar	2147483647	√	null
applicant	Table	postcode	varchar	2147483647	√	null
class_cpc_main	Table	cpc_version_date	varchar	2147483647	√	null
pad_assignment_conveyance	Table	rf_id	varchar	2147483647	√	null
perd_pta_summary	Table	patent_term_adjustment	varchar	2147483647	√	null
perd_correspondence_address	Table	customer_number	varchar	2147483647	√	null
us_applicant	Table	seq	varchar	2147483647	√	null
us_deceased	Table	us_dead_id_ctr	int4	10	√	null
claim	Table	doc_num	varchar	2147483647		null
us_deceased	Table	state	varchar	2147483647	√	null
pct_regional_fil	Table	date	varchar	2147483647	√	null
perd_application_data	Table	examiner_name_last	varchar	2147483647	√	null
nplcit	Table	othercit	varchar	2147483647	√	null
pubref	Table	country	varchar	2147483647	√	null
pubref	Table	disclaimer	varchar	2147483647	√	null
continuation	Table	child_country	varchar	2147483647	√	null
us_inventor	Table	inventor_id_ctr	int4	10	√	null
claims	Table	claims_id_ctr	int4	10	√	null
us_agents	Table	orgname	varchar	2147483647	√	null
perd_foreign_priority	Table	foreign_parent_date	varchar	2147483647	√	null
nplcit	Table	nplcit_id_ctr	int4	10	√	null
related_doc	Table	date	varchar	2147483647	√	null
applicant	Table	designation	varchar	2147483647	√	null
us_sequence_list_p	Table	id	varchar	2147483647	√	null
pad_assignee	Table	ee_country	varchar	2147483647	√	null
us_related_doc_reexam	Table	parent_country	varchar	2147483647	√	null
appref	Table	appref_id_ctr	int4	10	√	null
class_cpc_further	Table	class_source	varchar	2147483647	√	null
continuation_in_part	Table	child_doc_kind	varchar	2147483647	√	null
us_field_of_class_search_ipcr	Table	us_class_search_ipcr	varchar	2147483647	√	null
class_ipcr	Table	class_ipcr_class_value	varchar	2147483647	√	null
continuation_in_part	Table	child_doc_num	varchar	2147483647	√	null
sequence_list_p	Table	doc_num	varchar	2147483647		null
drawings	Table	drawing_id_ctr	int4	10	√	null
ref_cited	Table	patcit_doc_num	varchar	2147483647	√	null
us_agents	Table	last_name	varchar	2147483647	√	null
ref_cited_further	Table	ref_cited_further_id_ctr	int4	10	√	null
perd_all_inventors	Table	inventor_country_name	varchar	2147483647	√	null
dod_p	Table	doc_num	varchar	2147483647		null
description_p	Table	num	varchar	2147483647	√	null
us_prov_app	Table	country	varchar	2147483647	√	null