==ER Diagram for Assignment and Patent Databases==
Note: this is currently out of sync with matches the current description design below for but may not match the patent exact database(nor the code that creates the schema of the database currently. It will In the future these should be updated once I have finalized how we will organize unique attributes for plant, design, and reissue patentsmade to sync up.
[[File:PatentAndAssignmentER2erdplus-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.