Re: How to store footnotes or comments per field
Posted by: Peter Brawley
Date: February 12, 2013 02:17PM

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
);

Options: ReplyQuote


Subject
Written By
Posted
Re: How to store footnotes or comments per field
February 12, 2013 02:17PM


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.