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,