Primary key: rf_id
All columns (variables): * rf_id, (bigint) reel fram number* assignment_id (bigint) US patent assignment id* correspondent_name (varchar(255)) name of correspondent for the transaction, correspondent_name, could be a lawyer* correspondent_address1, correspondent_address_2, (varchar(255)) first line of address for correspondent* correspondent_address2 (varchar(255)) second line of address for correspondent* correspondent_address3, (varchar(255)) third line of address for correspondent* correspondent_address4, (varchar(255)) fourth line of address for correspondent* record_date (date) date recorded with USPTO), * last_update_date, (date) date that information for this assignment was last update with the USPTO * page_cnt (bigint) page count of assignment record)
More extensive notes exist under :E/McNair/Projects/Redesigning Patent Database/New Patent Database Project/Notes on USPTO Assignment Data Paper