Changes

Patent Data Cleanup (June 2016) (view source)

530 bytes added , 10:45, 7 July 2016

no edit summary

CREATE DATABASE allpatent_clone WITH TEMPLATE allpatent OWNER dbuser;

== Renaming Tables and Columns ==

To standardize table and column names, and to make them as user-friendly as possible, a few tables and columns have been renamed.

* '''allpatent''' database -> '''patent'''

* assignees -> assignee

* judges -> judge

* citations -> citation

* matchassignees -> MatchOrgNames

* patents -> patent

* assignees -> ptoassignee

* assignments -> ptoassignment

* assignors -> ptoassignor

* patentassignment -> ptopatentfile

* properties -> ptoproperty

* mslfee -> feestatus

* patentmaintenancefee -> fee

154

edits