• so is it going to be something like this?

    Note table: Noteid, NoteDetail, NoteDate, CreateDate, createdby

    NoteBridgeTable:

    columns: NoteID, NoteTypeID, Objectid (cannot find a good name for it)

    Data:

    Noteid, notetypid, hearingid

    Noteid, notetypid, conferenceid,

    Noteid, notetypeid, workshopid

    Noteid, notetypeid, Interventionid

    Should NoteType in Note table or in NoteBridge table?

    Thanks,