uspto Database

TABLES 83

COLUMNS 662

Constraints 0

Anomalies 173

Routines 0

Database Properties

Database Type: PostgreSQL - 9.2.2

Schema public

standard public schema

Tables

Table / View	Children	Parents	Columns	Rows	Type
nplcit	0	1	5	10989759	Table
dod_head	0	1	6	3193917	Table
us_ref_cited_class	0	1	5	17120280	Table
class_ipcr	0	1	15	10079314	Table
us_botanic	0	1	4	14953	Table
perd_correspondence_address	0	0	12	10616102	Table
abstract_p	0	1	6	3530062	Table
us_maths	0	1	11	2116365	Table
pad_assignee	0	0	8	7972573	Table
description_p	0	1	6	319443322	Table
us_inventor	0	1	9	5743457	Table
further_class	0	1	3	6393882	Table
class_cpc_main	0	1	15	1445929	Table
claims	0	1	3	3778701	Table
hague_agreement	0	1	6	2718	Table
related_pub	0	1	6	3097738	Table
draw_fig	0	1	5	38552892	Table
us_sequence_list	0	1	6	84937	Table
perd_status_codes	0	0	2	236	Table
us_chem	0	1	5	12061350	Table
substitution	0	2	8	445	Table
appref	0	1	5	3778701	Table
pubref	88	0	30	3778701	Table
us_field_of_class_search_ipcr	0	1	3	42259	Table
class_cpc_comb_set	0	1	3	201321	Table
priority_claim	0	1	6	1727438	Table
us_nplcit	0	1	5	20836802	Table
class_cpc_comb_rank	0	1	16	475194	Table
examiner	0	1	5	3778701	Table
pad_assignment	0	0	14	7697840	Table
inventor	0	1	7	0	Table
pubref_abs	0	1	3	3432897	Table
us_deceased	0	1	10	1611	Table
pct_regional_fil	0	1	7	545197	Table
pad_documentid	0	3	12	13084209	Table
perd_pta_summary	0	0	5	3706329	Table
continuation	0	4	20	848936	Table
us_field_of_class_search_cpc	0	1	3	8079235	Table
class_national	0	1	5	22216879	Table
assist_examiner	0	1	4	1291902	Table
ref_cited_class	0	1	5	14983079	Table
us_ref_cited	0	2	10	102301708	Table
pad_documentid_admin	0	2	6	13034433	Table
pct_regional_pub	0	1	5	544669	Table
pad_assignor	0	0	4	17941397	Table
us_exemplary_claim	0	1	3	3835454	Table
dod_p	0	1	6	42397115	Table
field_of_search_ipc	0	1	4	1659	Table
us_related_doc_reexam	0	4	12	1	Table
claim	0	1	6	57966353	Table
reissue	0	1	16	9224	Table
us_agents	0	1	12	2362199	Table
class_ipc_further_class	0	1	3	74560	Table
us_prov_app	0	1	6	1241233	Table
description	0	1	3	3778701	Table
assignee	0	1	13	3617025	Table
perd_pat_term_adj	0	0	8	185889529	Table
perd_application_data	0	0	29	11125755	Table
related_doc	0	4	20	345149	Table
sequence_list	0	1	6	3160	Table
perd_all_inventors	0	0	9	32804370	Table
us_field_of_class_search_cpc_comb	0	1	3	572467	Table
perd_transactions	0	0	5	368571830	Table
perd_foreign_priority	0	0	5	4464628	Table
field_of_search_national	0	1	5	1451281	Table
us_sequence_list_p	0	1	6	3113	Table
applicant	0	1	17	4285530	Table
perd_continuity_children	0	0	4	6540050	Table
deceased	0	1	5	1611	Table
us_applicant	0	1	20	3695065	Table
continuation_in_part	0	4	19	410702	Table
description_heading	0	1	6	28549486	Table
sequence_list_p	0	1	6	0	Table
class_cpc_further	0	1	15	8022207	Table
perd_continuity_parents	0	0	4	7824363	Table
perd_event_codes	0	0	2	2082	Table
ref_cited_further	0	1	5	0	Table
drawings	0	1	3	3610520	Table
figures	0	1	4	3620858	Table
agents	0	1	8	1919316	Table
pad_assignment_conveyance	0	0	3	7697840	Table
us_continuing_reissue	0	4	10	1	Table
ref_cited	0	2	12	56331329	Table