pubref


Columns

Column Type Size Nulls Auto Default Children Parents Comments
doc_num varchar 2147483647 null
abstract_p.doc_num Implied Constraint R
agents.doc_num Implied Constraint R
applicant.doc_num Implied Constraint R
appref.doc_num Implied Constraint R
assignee.doc_num Implied Constraint R
assist_examiner.doc_num Implied Constraint R
claim.doc_num Implied Constraint R
claims.doc_num Implied Constraint R
class_cpc_comb_rank.doc_num Implied Constraint R
class_cpc_comb_set.doc_num Implied Constraint R
class_cpc_further.doc_num Implied Constraint R
class_cpc_main.doc_num Implied Constraint R
class_ipc_further_class.doc_num Implied Constraint R
class_ipcr.doc_num Implied Constraint R
class_national.doc_num Implied Constraint R
continuation.child_doc_num Implied Constraint R
continuation.doc_num Implied Constraint R
continuation.parent_doc_num Implied Constraint R
continuation.parent_pct_doc_num Implied Constraint R
continuation_in_part.child_doc_num Implied Constraint R
continuation_in_part.doc_num Implied Constraint R
continuation_in_part.parent_grant_doc_num Implied Constraint R
continuation_in_part.parent_pct_doc_num Implied Constraint R
deceased.doc_num Implied Constraint R
description.doc_num Implied Constraint R
description_heading.doc_num Implied Constraint R
description_p.doc_num Implied Constraint R
dod_head.doc_num Implied Constraint R
dod_p.doc_num Implied Constraint R
draw_fig.doc_num Implied Constraint R
drawings.doc_num Implied Constraint R
examiner.doc_num Implied Constraint R
field_of_search_ipc.doc_num Implied Constraint R
field_of_search_national.doc_num Implied Constraint R
figures.doc_num Implied Constraint R
further_class.doc_num Implied Constraint R
hague_agreement.doc_num Implied Constraint R
inventor.doc_num Implied Constraint R
nplcit.doc_num Implied Constraint R
pad_documentid.appno_doc_num Implied Constraint R
pad_documentid.grant_doc_num Implied Constraint R
pad_documentid.pgpub_doc_num Implied Constraint R
pad_documentid_admin.appno_doc_num Implied Constraint R
pad_documentid_admin.grant_doc_num Implied Constraint R
pct_regional_fil.doc_num Implied Constraint R
pct_regional_pub.doc_num Implied Constraint R
priority_claim.doc_num Implied Constraint R
pubref_abs.doc_num Implied Constraint R
ref_cited.doc_num Implied Constraint R
ref_cited.patcit_doc_num Implied Constraint R
ref_cited_class.doc_num Implied Constraint R
ref_cited_further.doc_num Implied Constraint R
reissue.doc_num Implied Constraint R
related_doc.doc_num Implied Constraint R
related_doc.par_grant_doc_num Implied Constraint R
related_doc.parent_doc_num Implied Constraint R
related_doc.parent_pct_doc_num Implied Constraint R
related_pub.doc_num Implied Constraint R
sequence_list.doc_num Implied Constraint R
sequence_list_p.doc_num Implied Constraint R
substitution.child_doc_num Implied Constraint R
substitution.doc_num Implied Constraint R
us_agents.doc_num Implied Constraint R
us_applicant.doc_num Implied Constraint R
us_botanic.doc_num Implied Constraint R
us_chem.doc_num Implied Constraint R
us_continuing_reissue.child_doc_doc_num Implied Constraint R
us_continuing_reissue.doc_id_doc_num Implied Constraint R
us_continuing_reissue.doc_num Implied Constraint R
us_continuing_reissue.parent_grant_doc_num Implied Constraint R
us_deceased.doc_num Implied Constraint R
us_exemplary_claim.doc_num Implied Constraint R
us_field_of_class_search_cpc.doc_num Implied Constraint R
us_field_of_class_search_cpc_comb.doc_num Implied Constraint R
us_field_of_class_search_ipcr.doc_num Implied Constraint R
us_inventor.doc_num Implied Constraint R
us_maths.doc_num Implied Constraint R
us_nplcit.doc_num Implied Constraint R
us_prov_app.doc_num Implied Constraint R
us_ref_cited.doc_num Implied Constraint R
us_ref_cited.patcit_doc_num Implied Constraint R
us_ref_cited_class.doc_num Implied Constraint R
us_related_doc_reexam.child_doc_num Implied Constraint R
us_related_doc_reexam.doc_num Implied Constraint R
us_related_doc_reexam.parent_doc_num Implied Constraint R
us_related_doc_reexam.parent_grant_doc_num Implied Constraint R
us_sequence_list.doc_num Implied Constraint R
us_sequence_list_p.doc_num Implied Constraint R
disclaimer varchar 2147483647 √ null
class_national varchar 2147483647 √ null
claim_statement varchar 2147483647 √ null
status varchar 2147483647 √ null
produced_date varchar 2147483647 √ null
dtd_version varchar 2147483647 √ null
length_grant varchar 2147483647 √ null
us_term_extension varchar 2147483647 √ null
us_microform_quantity varchar 2147483647 √ null
class_ipc_edition varchar 2147483647 √ null
doc_id_date varchar 2147483647 √ null
prosecution_app varchar 2147483647 √ null
main_class varchar 2147483647 √ null
prior_disclosure_affidavit_filed varchar 2147483647 √ null
country varchar 2147483647 √ null
series_code varchar 2147483647 √ null
lang varchar 2147483647 √ null
invention_title varchar 2147483647 √ null
qq varchar 2147483647 √ null
class_ipc_main_class varchar 2147483647 √ null
no_of_claims varchar 2147483647 √ null
doc_id_country varchar 2147483647 √ null
ident varchar 2147483647 √ null
us_sir_flag varchar 2147483647 √ null
filename varchar 2147483647 √ null
class_locarno varchar 2147483647 √ null
classification varchar 2147483647 √ null
doc_id_kind varchar 2147483647 √ null
pub_date varchar 2147483647 √ null

Table contained 3778701 rows

Indexes

Constraint Name Type Sort Column(s)
pubref_pkey Primary key Asc doc_num

Relationships

Close relationships within degrees of separation