377
edits
Changes
Jump to navigation
Jump to search
Redesign Assignment and Patent Database (view source)
Revision as of 14:37, 20 October 2017
, 14:37, 20 October 2017→CONVEYANCE
Not-repeated (with exception of primary/foreign key):
* rf_id (bigint) reel frame number
* next_transaction (bigint) rf_id of next transaction that occurred after this transaction
* num_conveyance (int) number in order of conveyance by date
* acknowledgment_date (date) date that the assignor acknowledged the transaction
* execution_date (date) date that the transactiontook place
* conveyance_type (varchar(255)) the USPTO paper determined a couple of different conveyance types and also outlined how to determine based on the conveyance text in the xml file which conveyance type is relevant to the transaction. The conveyance types are:
** assignment
