Changes

Redesign Assignment and Patent Database (view source)

1,386 bytes added , 15:52, 26 October 2017

* exp_dt (date) expiration date of patent

* pta (int) length of patent term adjustment (which extends the amount of time the patent is allowed to be in force) in number of days

===INVENTORS===

Purpose: Represent the inventor for each of patents in the PATENT table

Each entry represents: information about an inventor for a specific patent

Primary Key: patent_number (and name, if there can be multiple inventors for a single patent)

* patent_number (varchar(255)) unique identifier for the patent from the UPSTO office, can contain letters hence varchar

* sequence (varchar(255)) appears to be a sequence of numbers that uniquely identify the inventor?

* name (varchar(255)) concatenated string of the first and last name of the inventor

* organme (varchar(255)) name of the organization the inventor works for

===LAWYERS===

Purpose: Represent the lawyers who worked on each of the patents in the PATENT table

Each entry represents: information about a lawyer for a specific patent

Primary Key: patent_number (there doesn't appear to be more than one lawyer entry for each patent)

* patent_number (varchar(255)) unique identifier for the patent from the UPSTO office, can contain letters hence varchar

* sequence (varchar(255)) appears to be a sequence of numbers that unique identify the lawyer?

* org_name (varchar(255)) the name of the firm that did arbitration for the patent

* address (varchar(255)) the address of the firm

* city (varchar(255)) city of the firm

* state (varchar(255)) state of the firm

* country (varchar(255)) country of the firm

==Connecting Patent database and Assignment database==

377

edits