Re: How to store footnotes or comments per field
Neither of those two.
Presumably there'll be no need to annotate at_id or at_recorded, perhaps not at_description either. Then at most you need a four-column child table ...
create table account_trans_notes (
at_id int(10) unsigned primary key,
at_description_notes varchar(255),
at_amount_notes varchar(255),
at_price_notes varchar(255),
foreign key(at_id) references account_trans(at_id) on delete cascade on update cascade
);
Subject
Written By
Posted
February 12, 2013 12:37PM
Re: How to store footnotes or comments per field
February 12, 2013 02:17PM
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.