Hello all,

I am currently working on the design for a new DB, and have run into a wall. In essence, I have a number of primary objects, each with their own table, stored in my database. I want to be able to create notes that can be connected with any of these existing primary objects.

As an example, think of a library with the following tables: Books, Patrons, Loans
Each table has its own ID attribute. I want to be able to create a new "Notes" table so that I can attach notes to any of the existing objects (ie a Particular book, or a particular customer). I imagine it going something like this.

Notes
-NoteID(INT)
-ObjectType(Either varchar ref to object title, ie "Books", or possibly an INT that references another table in which I store the primary object types)
-ObjectID(INT; this will reference the specific objects ID such as BookID)
-Details(Varchar(150))
-etc....

The main point of this would be able to look at all notes together, . Anyone have any idea how I might accomplish this, or if there is a standard DB design used to handle this sort of situation?

Thanks,
Chris