Relationship between notes and customer account or transaction

Hi,

I am looking for the relationship to tie the notes on a collectors window to the customer account. If notes are taken at a transaction level then the relationship between notes and transaction. When I say relationship I mean the joins in tables. For example I see multiple tables storing the notes Eg: JTF_NOTES_TL, JTF,NOTES_B, IEX_NOTES_BALI_VL and also AST_NOTES_DETAILS_VL. But I am not sure which one to use. All of them have JTF_NOTE_ID which is the primary key. But which tables have this column for me to tie it to a transaction or a customer account.