MySQL Forums
Forum List  »  MySQL Workbench

Forward Engineering - Process Creates NULL and UN-NEEDED Columns - Help Removing
Posted by: Eric Hanlon
Date: November 05, 2019 11:28AM

I am working with a friend on creating a database, so far we have 3 versions, and two of them work pretty decently but likely still have flaws.

The database at minimum will keep track of FIVE MLB SEASONS and the associated TEAM STATS for each of the 30 MLB TEAMS. The database is to be designed to have room for growth.

We are seeking help on an issue with Forward Engineering inside MySQL Workbench that creates everything (6 TABLES, 1 TEAM TABLE AND 1 TABLE FOR EACH YEAR (5 year), except that one of our tables ends up having 5 EXTRA COLUMNS that are UN-NEEDED, PHOTO to follow. This error is found inside the TEAMS TABLE upon trying to view the entire table.

PHOTO (MySQL Workbench SELECT ALL): https://ibb.co/f8LkBp8

==============================================================================

PHOTO (EER DIAGRAM): https://ibb.co/ZTyTRnV

PASTEBIN (FORWARD ENGINEER SCRIPT): https://pastebin.com/kEnb99Ae

PASTEBIN (INSERT): https://pastebin.com/fD18gZyX


==============================================================================

Options: ReplyQuote


Subject
Views
Written By
Posted
Forward Engineering - Process Creates NULL and UN-NEEDED Columns - Help Removing
39
November 05, 2019 11:28AM


Sorry, only registered users may post in this forum.

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.