Redesign Assignment and Patent Database - Revision history

Ed at 17:41, 21 September 2020

2020-09-21T17:41:45Z

Ed at 17:34, 21 September 2020

2020-09-21T17:34:20Z

Ed at 17:20, 20 September 2020

2020-09-20T17:20:11Z

Ed at 17:12, 20 September 2020

2020-09-20T17:12:23Z

ShelbyBice at 20:42, 8 December 2017

2017-12-08T20:42:23Z

ShelbyBice: /* ER Diagram for Assignment and Patent Databases */

2017-12-08T20:36:15Z

ER Diagram for Assignment and Patent Databases

ShelbyBice at 20:29, 8 December 2017

2017-12-08T20:29:14Z

ShelbyBice: /* ER Diagram for Assignment and Patent Databases */

2017-12-08T20:20:56Z

ER Diagram for Assignment and Patent Databases

ShelbyBice at 22:09, 7 December 2017

2017-12-07T22:09:51Z

ShelbyBice: /* Finding New Fields Unique to Plant, Reissue, and/or Design Patents */

2017-11-17T22:56:50Z

Finding New Fields Unique to Plant, Reissue, and/or Design Patents

@@ Line 1: / Line 1: @@
 {{Project
-|Has project output=
+|Has project output=Data
 |Has sponsor=McNair Center
 |Has title=Redesign Assignment and Patent Database

@@ Line 1: / Line 1: @@
 {{Project
 |Has sponsor=McNair Center
 |Has title=Redesign Assignment and Patent Database

@@ Line 1: / Line 1: @@
 {{Project
 |Has title=Redesign Assignment and Patent Database
 |Has owner=Shelby Bice,

@@ Line 1: / Line 1: @@
-{{McNair Projects
+{{Project
 |Has title=Redesign Assignment and Patent Database
 |Has owner=Shelby Bice,

@@ Line 6: / Line 6: @@
 |Is dependent on=Reproducible Patent Data,
 }}
-'''Final Notes''' This is more or less the finalized design for the patent database. Oliver Chang's code (see Reproducible Patent Data, which is his project page) more or less fits the design, though there are some differences and expect differences in variable names. In the future the code should be altered so that the name of variables match up and each table that is listed here exists in the database. The tables for the extra variables that exist for reissue, design, and plant patents have been added, and the instructions for adding tables can be found on Reproducible Patent Data.
+'''Final Notes''' This is more or less the finalized design for the patent database. Oliver Chang's code (see Reproducible Patent Data, which is his project page) more or less fits the design, though there are some differences and expect differences in variable names. In the future the code should be altered so that the name of variables match up and each table that is listed here exists in the database. The tables for the extra variables that exist for reissue, design, and plant patents have been added, and the instructions for adding tables can be found on Reproducible Patent Data. These three tables should fit the schema seen here, but as stated previously the schema in the code DOES NOT fit the schema here exactly and should be altered in the future to fit this schema.
 '''For Oliver:''' Unfortunately I did not get to finish making the schema in your code fit the schema that is outlined here. For whoever works on this next, whether that be you or another intern, please note that the variable in the schema in the code do not match up exactly with the schema outlined here, except for perhaps the Reissues, Plants, and Designs tables in the Patent database (called patentsj in the code, I believe, but you can create a database with any name of course).

@@ Line 22: / Line 22: @@
 Note: this matches the design below but may not match the exact database (nor the code that creates the schema of the database currently. In the future these should be made to sync up.
-[[File:erdplus-diagram(3).png]]
+[[File:Erdplus-diagram (3).png]]
 Attributes for each table are listed below with descriptions - because of how many attributes there are, I decided the ER diagram would be better suited as an overview of the tables rather than trying to show all the attributes on the diagram.
 ==Assignment Database Structure==

@@ Line 7: / Line 7: @@
 }}
 '''Final Notes''' This is more or less the finalized design for the patent database. Oliver Chang's code (see Reproducible Patent Data, which is his project page) more or less fits the design, though there are some differences and expect differences in variable names. In the future the code should be altered so that the name of variables match up and each table that is listed here exists in the database. The tables for the extra variables that exist for reissue, design, and plant patents have been added, and the instructions for adding tables can be found on Reproducible Patent Data.
 This is an extension of the work I did last semester under "Redesigning Patent Database". Instead of simply reconfiguring the existing database, this project encompasses and full redesign and creation of a new Patent database and a new Assignment database that will be joined together.
@@ Line 312: / Line 314: @@
 ====PLANT====
 =====Fields=====
-* patent_number (varchar(255)) unique identifier for the patent from the UPSTO office, can contain letters hence varchar
+* patent_no (varchar(255)) unique identifier for the patent from the UPSTO office, can contain letters hence varchar
 * latin_name (varchar(255)) latin name for the plant
 * us_botanical_variety(varchar(255)) denotes what variety of plant it is - for example, a rose has several different varieties
@@ Line 330: / Line 332: @@
 =====Fields=====
-* patent_number (varchar(255)) unique identifier for the patent from the UPSTO office, can contain letters hence varchar
+* patent_no (varchar(255)) unique identifier for the patent from the UPSTO office, can contain letters hence varchar
 * parent_doc_status (varchar(255)) status of the parent application. Probably related to whether the patent application is pending or not
 * parent_doc_number (int) probably application number for the parent document
@@ Line 348: / Line 350: @@
 ====DESIGN====
 =====Fields=====
-* patent_number (varchar(255)) unique identifier for the patent from the UPSTO office, can contain letters hence varchar
+* patent_no (varchar(255)) unique identifier for the patent from the UPSTO office, can contain letters hence varchar
 * length_of_grant (int) length of grant, most likely in years
 * hague_registration_date (date) filing date of international patent application

@@ Line 18: / Line 18: @@
 ==ER Diagram for Assignment and Patent Databases==
-Note: this is currently out of sync with the current description below for the patent database. It will be updated once I have finalized how we will organize unique attributes for plant, design, and reissue patents.
+Note: this matches the design below but may not match the exact database (nor the code that creates the schema of the database currently. In the future these should be made to sync up.
-[[File:PatentAndAssignmentER2.png]]
+[[File:erdplus-diagram(3).png]]
 Attributes for each table are listed below with descriptions - because of how many attributes there are, I decided the ER diagram would be better suited as an overview of the tables rather than trying to show all the attributes on the diagram.

@@ Line 449: / Line 449: @@
 * US Provisional Application Status (XML41)
-==Paths for the New Fields Related to Plant Reissue, and/or Design Patents
+==Paths for the New Fields Related to Plant Reissue, and/or Design Patents==
 ===Plant Patents===