377
edits
Changes
Jump to navigation
Jump to search
* Determine what tables in database need to always be there (patents, inventors, etc.) and which tables were added for separate projects
Redesigning Patent Database (view source)
Revision as of 11:01, 23 March 2017
, 11:01, 23 March 2017no edit summary
TODO on 3/21/2017 and 3/23/2017
* Start documentation for the "core" tables of the databases that should not be deleted.
* Make ER Diagram for "core" tables in database
** helpful commands for interacting with psql
* Notes on determining "core" tables for database are saved under Projects/Redesigning Patent Database/Determining which tables should be core tables
'''3/23/2017''' - Made spreadsheet with core tables and share it with other people working on patent data to get their approval
* This spreadsheet can be found under Projects/Redesigning Patent Database/Core Tables for New Patent Database
* Some tables that will later be deleted were included on the spreadsheet because their are currently being tables built to replace them
* May try to just move all the (twenty-something) "pto-" tables that have been created due to the "Restructuring Patent Data" project from "patent" to the new database
