377
edits
Changes
Jump to navigation
Jump to search
Redesign Assignment and Patent Database (view source)
Revision as of 09:42, 3 October 2017
, 09:42, 3 October 2017→ASSIGNEE
Primary key: patent_number, first_name, last_name (in case it is possible for there to be multiple assignees for an individual patent)
All columns (variables): First * patent_number (varchar(255)) unique identifier for the patent from the UPSTO office, can contain letters hence varchar *first_name (varchar(255)) first name, of assignee*last name (varchar(255)) last name, of assignee* address (varchar(255)) address, of assignee* postcode (varchar(255)) postcode, of assignee orgname, city, country, patentnumber, state, residence, size of firm
===CITATION===
