MySQL Forums
Forum List  »  Newbie

Re: Three queries needed with the same result
Posted by: Russell Wright
Date: December 02, 2019 06:15PM

Here are the results of SHOW CREATE TABLE for all four tables in question:

STUDENT Create Table: CREATE TABLE `STUDENT` ( `STUDENT_ID` bigint(20) NOT NULL, `SALUTATION` varchar(5) DEFAULT NULL, `FIRST_NAME` varchar(25) DEFAULT NULL, `LAST_NAME` varchar(25) NOT NULL, `STREET_ADDRESS` varchar(50) DEFAULT NULL, `ZIP` varchar(5) NOT NULL, `PHONE` varchar(15) DEFAULT NULL, `EMPLOYER` varchar(50) DEFAULT NULL, `REGISTRATION_DATE` date NOT NULL, `CREATED_BY` varchar(30) NOT NULL, `CREATED_DATE` date NOT NULL, `MODIFIED_BY` varchar(30) NOT NULL, `MODIFIED_DATE` date NOT NULL, PRIMARY KEY (`STUDENT_ID`), KEY `STU_ZIP_FK_I` (`ZIP`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1

ENROLLMENT Create Table: CREATE TABLE `ENROLLMENT` ( `STUDENT_ID` bigint(20) NOT NULL, `SECTION_ID` bigint(20) NOT NULL, `ENROLL_DATE` date NOT NULL, `FINAL_GRADE` int(11) DEFAULT NULL, `CREATED_BY` varchar(30) NOT NULL, `CREATED_DATE` date NOT NULL, `MODIFIED_BY` varchar(30) NOT NULL, `MODIFIED_DATE` date NOT NULL, PRIMARY KEY (`STUDENT_ID`,`SECTION_ID`), KEY `ENR_SECT_FK_I` (`SECTION_ID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1

GRADE Create Table: CREATE TABLE `GRADE` ( `STUDENT_ID` bigint(20) NOT NULL, `SECTION_ID` bigint(20) NOT NULL, `GRADE_TYPE_CODE` char(2) NOT NULL, `GRADE_CODE_OCCURRENCE` bigint(20) NOT NULL, `NUMERIC_GRADE` double(3,0) NOT NULL, `COMMENTS` varchar(2000) DEFAULT NULL, `CREATED_BY` varchar(30) NOT NULL, `CREATED_DATE` date NOT NULL, `MODIFIED_BY` varchar(30) NOT NULL, `MODIFIED_DATE` date NOT NULL, PRIMARY KEY (`STUDENT_ID`,`SECTION_ID`,`GRADE_TYPE_CODE`,`GRADE_CODE_OCCURRENCE`), KEY `GR_GRTW_FK_I` (`SECTION_ID`,`GRADE_TYPE_CODE`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1

ZIPCODE Create Table: CREATE TABLE `ZIPCODE` ( `ZIP` varchar(5) NOT NULL, `CITY` varchar(25) DEFAULT NULL, `STATE` varchar(2) DEFAULT NULL, `CREATED_BY` varchar(30) NOT NULL, `CREATED_DATE` date NOT NULL, `MODIFIED_BY` varchar(30) NOT NULL, `MODIFIED_DATE` date NOT NULL, PRIMARY KEY (`ZIP`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1

Options: ReplyQuote


Subject
Written By
Posted
Re: Three queries needed with the same result
December 02, 2019 06:15PM


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.