619
edits
Changes
Jump to navigation
Jump to search
==Current Problems==[[Category: Internal]][[Internal Classification: Legacy| ]]
no edit summary
==Table Purpose==
<section begin="assignment" />The Assignment Table brings the information in the Assignee, Assignor, and Patent Id Tables together in a more usable format. The most relevant properties of an assignment are included in the table. <section end="assignment" />
==Table Structure==
Table "public.assignment"
==Table Variables==
Reel and frame give the location on the microfilm files where the particular transaction is recorded. The reel number and frame number are unique to a transaction between the assignee and assignor. The recdate is the date the assignment was recorded. Patent is the patent number assigned. The names of each assignee and assignor involved in the assignment are given in the table. The table has a composite key consisting of reel number, frame number, and recdate.
==Current Problems==
