|-
| Patent || patent (same thing as patentnumber), grantdate, prioritydate (date patent was filed), prioritycountry (country patent was filed in), prioritypatentnumber (application number), cpcsubgroup, pctpatentnumber (only relevant if applying for international patents), claims, appnum, grantyear, appdate, appyear, nber(only relevant for utility patents), uspc, uspc_sub (categorizes patents) || patentnumber, grantdate, prioritydate, prioritycountry, prioritypatentnumber, cpcsubgroup, claims, grantyear, nber (NULL for non-utility patents), uspc, uspc_sub, appdate, appyear
|}
{| class="wikitable"
! Table
! Current Attributes (primary key in red)
! New Attributes (primary key in red) (relate back to patent in blue)
|-
| Patent
| patent (same thing as patentnumber), grantdate, prioritydate (date patent was filed), prioritycountry (country patent was filed in), prioritypatentnumber (application number), cpcsubgroup, pctpatentnumber (only relevant if applying for international patents), claims, appnum, grantyear, appdate, appyear, nber(only relevant for utility patents), uspc, uspc_sub (categorizes patents)
| patentnumber, grantdate, prioritydate, prioritycountry, prioritypatentnumber, cpcsubgroup, claims, grantyear, nber (NULL for non-utility patents), uspc, uspc_sub, appdate, appyear
|}