Answered step by step
Verified Expert Solution
Question
1 Approved Answer
CREATE TABLE ` article ` ( ` id ` varchar ( 1 0 ) NOT NULL, ` volname ` varchar ( 1 0 0 )
CREATE TABLE article
id varchar NOT NULL,
volname varchar DEFAULT NULL,
volid varchar DEFAULT NULL,
title varchar NOT NULL,
bodyText text NOT NULL,
correspAut varchar DEFAULT NULL,
submissionDate date DEFAULT NULL,
result varchar DEFAULT NULL,
PRIMARY KEY id
KEY volnamevolnamevolid
KEY correspAutcorrespAut
ENGINEInnoDB DEFAULT CHARSETutfmb COLLATEutfmbgeneralci;
CREATE TABLE articlekeywords
email varchar NOT NULL,
aid varchar NOT NULL,
PRIMARY KEY emailaid
KEY aidaid
ENGINEInnoDB DEFAULT CHARSETutfmb COLLATEutfmbgeneralci;
CREATE TABLE person
email varchar NOT NULL,
name varchar DEFAULT NULL,
vname varchar NOT NULL,
vid varchar NOT NULL,
isAuthor tinyint DEFAULT NULL,
isEditor tinyint DEFAULT NULL,
isReviewer tinyint DEFAULT NULL,
PRIMARY KEY emailvnamevid
KEY vnamevnamevid
ENGINEInnoDB DEFAULT CHARSETutfmb COLLATEutfmbgeneralci;
ALTER TABLE articlekeywords
ADD CONSTRAINT articlekeywordsibfk FOREIGN KEY keywid REFERENCES keywordskeywid
ADD CONSTRAINT articlekeywordsibfk FOREIGN KEY aid REFERENCES articleid;
i got error message for alter table on mysql workbench how can i fix that
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started