It would be great if two tables could share the same ID as a primary key. For example, say we have a client table and a sole trader table.
Not all clients are sole traders, some are limited companies or even individuals. At the moment in time I have a redundant column that acts as a primary key, but the primary key should be the client ID.
Thanks in advance