Details
-
Suggestion
-
Resolution: Out of scope
-
P3: Somewhat important
-
4.0.0
-
None
Description
Consider this setup:
CREATE TABLE author ( id INT NOT NULL PRIMARY KEY AUTO_INCREMENT, firstname varchar(40) NOT NULL, surname varchar(40) NOT NULL ); CREATE TABLE book ( id INT NOT NULL PRIMARY KEY AUTO_INCREMENT, title varchar(40), price numeric(10,2), authorid integer, notes varchar(255), FOREIGN KEY (authorid) REFERENCES author(id) );
I'd like to have the authorid replace with the firstname and surname from the
author table. Currently there is no API to achieve this.