Changes

Patent Assignment Data Restructure (view source)

669 bytes added , 15:48, 2 May 2017

--1128247

===Ptotracking Tables===

The purpose of the ptotracking tables is to track the ownership of patents based on the update date and filing dates of the assignment.

DROP TABLE ptotracking;

CREATE TABLE ptotracking AS

SELECT M1.reelno, M1.frameno, M1.documentid, M2.last_update_date, M2.recorded_date

FROM ptoproperty_cleaned M1, ptoassignmentnd M2

WHERE (M1.reelno = M2.reelno) AND (M1.frameno = M2.frameno);

DROP TABLE ptotracking2;

CREATE TABLE ptotracking2 AS

SELECT M1.reelno, M1.frameno, M1.documentid, M2.name, M1.last_update_date, M1.recorded_date

FROM ptotracking M1, ptoassigneend M2

WHERE (M1.reelno = M2.reelno) AND (M1.frameno = M2.frameno);

===US ONLY Patent Assignee Table===

1,181

edits