1,181
edits
Changes
Jump to navigation
Jump to search
Patent Assignment Data Restructure (view source)
Revision as of 17:34, 2 May 2017
, 17:34, 2 May 2017→Patent Number Cleanup
The ptoproperty_cleaned table contains application numbers, publication numbers, and patent numbers. The patents may also have two distinct publication numbers based on the year in which it was published. Based on length of documentid, the three types of id numbers were separated into three tables.
DROP TABLE ptoproperty_patent;
CREATE TABLE ptoproperty_patent AS
SELECT * FROM ptoproperty_cleaned WHERE length(documentid) = 7;
--8696149
===Ptotracking Tables===
