Re: How to store footnotes or comments per field
Thanks, Peter. I'll try that. I think I'll need to modify the pattern a little to accommodate the comments/notes table, and I need to provide for the possibility of more than one note per field, something like this:
create table account_trans_notes (
atn_id int(10) unsigned primary key,
atn_description_notes_id int(10),
at_amount_notes_id int(10),
at_price_notes_id int(10)
);
create table account_trans_notes_to_notes (
atntn_id int(10) unsigned primary key,
atntn_atn_id int(10),
atntn_note_id int(10)
);
create table notes (
note_id int(10) unsigned primary key,
note_text varchar(450)
);
Subject
Written By
Posted
February 12, 2013 12:37PM
February 12, 2013 02:17PM
Re: How to store footnotes or comments per field
February 12, 2013 02:37PM
February 23, 2013 07:11PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.