Patent ID: 7685184

Claim:
A method performed by a processor for an individual to maintain a database including a core and an extension, wherein the core contains core tables including general data and the extension contains extension tables including specific data, the core tables and the extension tables having the same primary keys and the specific data being an extension of the general data, the method comprising: displaying a maintenance view of the extension table on a display prior to modifying the database; receiving an input from the individual for modifying the database; modifying the core or the extension using the received input; automatically modifying the other of the core or the extension to reflect the modifying of the core or the extension by: synchronizing data in the core with data in the extension by comparing data in the core tables with entries in the extension tables, wherein when an entry in the core table does not correspond to any entry in the extension table, a new entry is automatically added into the extension table using the same primary keys as the entry in the core table and when the entry in the extension table does not find a corresponding entry in the core table the entry in the extension table is deleted; and displaying a maintenance view of the extension table on a display after the modifying of the database.