Changes

Jump to navigation Jump to search
All columns (variables): Two possibilities, depending on whether we want data to be repeated or not.
Not-repeated (with exception of primary/foreign key): * rf_id, (bigint) reel frame number* next_transaction (also bigint) rf_id), of next transaction* num_conveyance (int) number in order of conveyance by date), * acknowledgment_date (in ASSIGNOR for date) date that the assignor acknowledged the assignment data paper but would be moved here. Could originally be stored in ASSIGNOR until CONVEYANCE is generated), transaction* execution_date (same deal as acknowledgment date, should probably be moved here; if there are multiple execution dates, we will store ) date that the last onetransaction* conveyance_type (varchar(255)) conveyance_typethe 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** merger** change of name** government interest** agreement** security agreement** release 
Repeated, also include: * assignee_name (varchar(255)) name of the assignee, * assignor_name (varchar(255)) name of the assignor, patent_id* patent_number (varchar(255)) identifying number for the patent
===DOCUMENT_INFO===

Navigation menu