Skip to content

Handle Multiple Section Authors #36

@jdeck88

Description

@jdeck88

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
No labels

Type

No type

Projects

No projects

Relationships

None yet

Development

No branches or pull requests

Issue actions