Difference between revisions of "Assignee Info Table"
Jump to navigation
Jump to search
| Line 23: | Line 23: | ||
asgtype | integer | | asgtype | integer | | ||
| − | The orgname (organization name) and the first and last name columns identify the patent assignee. Other than patentcountry, all other table variables apply to the organization or person. Orgname is not standardized. Certain patents have multiple assignees, resulting in repeated patent numbers. The key in this table is composite and consists of a unique combination of last and first name, orgname, and patent number. | + | The orgname (organization name) and the first and last name columns identify the patent assignee. Other than patentcountry, all other table variables apply to the organization or person. Patentcountry refers to where the patent was granted. Orgname is not standardized. Certain patents have multiple assignees, resulting in repeated patent numbers. The key in this table is composite and consists of a unique combination of last and first name, orgname, and patent number. |
Revision as of 14:16, 6 July 2016
Return to Patent Data Specifications.
Table Variables
Below is how the assignee table appears in the database and includes the list of table variables.
Table "public.assignee" Column | Type | Modifiers ---------------+------------------------+----------- lastname | character varying(200) | firstname | character varying(200) | address | character varying(200) | postcode | character varying(200) | orgname | character varying(500) | city | character varying(200) | country | character varying(200) | patent | character varying(200) | state | character varying(200) | patentcountry | character varying(200) | nationality | character varying(200) | residence | character varying(200) | asgseq | integer | asgtype | integer |
The orgname (organization name) and the first and last name columns identify the patent assignee. Other than patentcountry, all other table variables apply to the organization or person. Patentcountry refers to where the patent was granted. Orgname is not standardized. Certain patents have multiple assignees, resulting in repeated patent numbers. The key in this table is composite and consists of a unique combination of last and first name, orgname, and patent number.
