-
Notifications
You must be signed in to change notification settings - Fork 3
Open
Milestone
Description
Add a new table "sectionAuthors" that links the authorname to the section table so we can handle cases where there are multiple authors in a single section. The table would look like:
DROP TABLE IF EXISTS sectionAuthors;
CREATE TABLE sectionAuthors (
section_id int(11) NOT NULL AUTO_INCREMENT,
given_name varchar(255) DEFAULT NULL,
family_name varchar(255) DEFAULT NULL,
KEY section_id (section_id),
CONSTRAINT section_ibfk_1 FOREIGN KEY (section_id) REFERENCES section (section_id) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
Also, drop the given_name, family_name from section table
Need to adjust digester assignments to handle this...
Metadata
Metadata
Assignees
Labels
No labels