Closed jmarkulic closed 9 months ago
The main diff between the 9.1 and 8.x is the generated MD, that makes your md-file less relevant if it is generated from an old version. But I guess it's the blank spaces in "Players 2023 Fall" will look into it tomorrow
I removed the spaces in the table nae and still get the error. Here’s the 9.1 chart
Jim
From: Jens Hunt @.> Sent: Saturday, October 14, 2023 4:31 PM To: R0tenur/visualization @.> Cc: jmarkulic @.>; Author @.> Subject: Re: [R0tenur/visualization] Mermaid Error with Schema Visualization 0.9.1 (Issue #131)
The main diff between the 9.1 and 8.x is the generated MD, that makes your md-file less relevant if it is generated from an old version. But I guess it's the blank spaces in "Players 2023 Fall" will look into it tomorrow
— Reply to this email directly, view it on GitHub https://urldefense.com/v3/__https:/github.com/R0tenur/visualization/issues/131*issuecomment-1763172998__;Iw!!DLa72PTfQgg!KUKCqx_xWjOZYk0sEGfCE1u7PeolCgjN2n_IJ7BxFHHiHLHp-mq7jEkMReewIeWs1uTPJ6rzbjNv5SI2htCc-MfY$ , or unsubscribe https://urldefense.com/v3/__https:/github.com/notifications/unsubscribe-auth/AJCDK5QJBGBQO6FNT7XFK5TX7LZBFAVCNFSM6AAAAAA6ALYDZKVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMYTONRTGE3TEOJZHA__;!!DLa72PTfQgg!KUKCqx_xWjOZYk0sEGfCE1u7PeolCgjN2n_IJ7BxFHHiHLHp-mq7jEkMReewIeWs1uTPJ6rzbjNv5SI2hi52__aZ$ . You are receiving this because you authored the thread. https://github.com/notifications/beacon/AJCDK5Q6AA7YGZQAH3ACVKTX7LZBFA5CNFSM6AAAAAA6ALYDZKWGG33NNVSW45C7OR4XAZNMJFZXG5LFINXW23LFNZ2KUY3PNVWWK3TUL5UWJTTJC7RIM.gif Message ID: @. @.> >
I removed the spaces in the table nae and still get the error. Here’s the 9.1 chart
Jim
From: Jens Hunt @.> Sent: Saturday, October 14, 2023 4:31 PM To: R0tenur/visualization @.> Cc: jmarkulic @.>; Author @.> Subject: Re: [R0tenur/visualization] Mermaid Error with Schema Visualization 0.9.1 (Issue #131)
The main diff between the 9.1 and 8.x is the generated MD, that makes your md-file less relevant if it is generated from an old version. But I guess it's the blank spaces in "Players 2023 Fall" will look into it tomorrow
— Reply to this email directly, view it on GitHub https://urldefense.com/v3/__https:/github.com/R0tenur/visualization/issues/131*issuecomment-1763172998__;Iw!!DLa72PTfQgg!KUKCqx_xWjOZYk0sEGfCE1u7PeolCgjN2n_IJ7BxFHHiHLHp-mq7jEkMReewIeWs1uTPJ6rzbjNv5SI2htCc-MfY$ , or unsubscribe https://urldefense.com/v3/__https:/github.com/notifications/unsubscribe-auth/AJCDK5QJBGBQO6FNT7XFK5TX7LZBFAVCNFSM6AAAAAA6ALYDZKVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMYTONRTGE3TEOJZHA__;!!DLa72PTfQgg!KUKCqx_xWjOZYk0sEGfCE1u7PeolCgjN2n_IJ7BxFHHiHLHp-mq7jEkMReewIeWs1uTPJ6rzbjNv5SI2hi52__aZ$ . You are receiving this because you authored the thread. https://github.com/notifications/beacon/AJCDK5Q6AA7YGZQAH3ACVKTX7LZBFA5CNFSM6AAAAAA6ALYDZKWGG33NNVSW45C7OR4XAZNMJFZXG5LFINXW23LFNZ2KUY3PNVWWK3TUL5UWJTTJC7RIM.gif Message ID: @. @.> >
That reply was pretty messy.
I removed the spaces in the table name and got following
classDiagram
class Appearances {
G_1b
G_2b
G_3b
G_all
G_batting
G_c
G_cf
G_defense
G_dh
G_lf
G_of
G_p
G_ph
G_pr
G_rf
G_ss
GS
lgID
playerID
teamID
yearID
}
class AwardsManagers {
awardID
lgID
notes
playerID
tie
yearID
}
class AwardsPlayers {
awardID
lgID
notes
playerID
tie
yearID
}
class AwardsShareManagers {
awardID
lgID
playerID
pointsMax
pointsWon
votesFirst
yearID
}
class AwardsSharePlayers {
awardID
lgID
playerID
pointsMax
pointsWon
votesFirst
yearID
}
class Batting {
AB
B2
B3
BB
CS
G
GIDP
H
HBP
HR
IBB
lgID
playerID
R
RBI
SB
SF
SH
SO
stint
teamID
yearID
}
class CollegePlaying {
playerID
schoolID
yearID
}
class Fielding {
A
CS
DP
E
G
GS
InnOuts
lgID
PB
playerID
PO
POS
SB
stint
teamID
WP
yearID
ZR
}
class HallOfFame {
ballots
category
inducted
needed
needed_note
playerID
votedBy
votes
yearid
}
class HomeGames {
attendance
games
lgID
openings
parkID
span_first
span_last
teamID
yearID
}
class Managers {
G
inseason
L
lgID
playerID
plyrMgr
rank
teamID
W
yearID
}
class People {
bats
bbrefID
birthCity
birthCountry
birthDay
birthMonth
birthState
birthYear
deathCity
deathCountry
deathDay
deathMonth
deathState
deathYear
debut
ff26_Career_Range_Factor
ff26_Total_G_Played
finalGame
height
High_BA
nameFirst
nameGiven
nameLast
playerID
retroID
SRP42_Career_Range_Factor
SRP42_Total_G_Played
throws
Total_401K
Total_HR
weight
}
class Players2023Fall {
playerID
}
class AllstarFull {
gameID
gameNum
GP
lgID
playerID
startingPos
teamID
yearID
}
class Pitching {
BAOpp
BB
BFP
BK
CG
ER
ERA
G
GF
GIDP
GS
H
HBP
HR
IBB
IPouts
L
lgID
playerID
R
SF
SH
SHO
SO
stint
SV
teamID
W
WP
yearID
}
class Salaries {
401K_Player_Contributions
401K_Team_Contributions
lgID
playerID
salary
teamID
yearID
}
class Schools {
city
country
name_full
schoolID
state
}
class Teams {
AB
attendance
B2
B3
BB
BBA
BPF
CG
CS
divID
DivWin
DP
E
ER
ERA
FP
franchID
G
Ghome
H
HA
HBP
HR
HRA
IPouts
L
lgID
LgWin
name
park
PPF
R
RA
SB
SF
SHO
SO
SOA
SV
Team_Rank
teamID
teamIDBR
teamIDlahman45
teamIDretro
W
WCWin
WSWin
yearID
}
class TeamsFranchises {
active
franchID
franchName
NAassoc
}
AwardsPlayers --|> People: playerID
AwardsShareManagers --|> People: playerID
AwardsSharePlayers --|> People: playerID
Batting --|> Teams: lgID
Batting --|> People: playerID
Batting --|> Teams: teamID
Batting --|> Teams: yearID
CollegePlaying --|> People: playerID
CollegePlaying --|> Schools: schoolID
Fielding --|> Teams: lgID
Fielding --|> People: playerID
Fielding --|> Teams: teamID
Fielding --|> Teams: yearID
HallOfFame --|> People: playerID
Players2023Fall --|> People: playerID
Pitching --|> Teams: lgID
Pitching --|> People: playerID
Pitching --|> Teams: teamID
Pitching --|> Teams: yearID
Would really appreaciate your v0.9.1 markdown
Sorry, thought I sent yesterday. See attached
Jim
From: Jens Hunt @.> Sent: Sunday, October 15, 2023 3:19 AM To: R0tenur/visualization @.> Cc: jmarkulic @.>; Author @.> Subject: Re: [R0tenur/visualization] Mermaid Error with Schema Visualization 0.9.1 (Issue #131)
Would really appreaciate your v0.9.1 markdown
— Reply to this email directly, view it on GitHub https://urldefense.com/v3/__https:/github.com/R0tenur/visualization/issues/131*issuecomment-1763302505__;Iw!!DLa72PTfQgg!MvTlshHJC06tSmONgRxBkC-Ap3iL2SISB1fQM3iziDCLcRqtixfkLGFZDs5ZUfeWF-u5qDhWte9kRL858L7g_7Op$ , or unsubscribe https://urldefense.com/v3/__https:/github.com/notifications/unsubscribe-auth/AJCDK5WEARNU5ZICGLLRLC3X7OE57AVCNFSM6AAAAAA6ALYDZKVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMYTONRTGMYDENJQGU__;!!DLa72PTfQgg!MvTlshHJC06tSmONgRxBkC-Ap3iL2SISB1fQM3iziDCLcRqtixfkLGFZDs5ZUfeWF-u5qDhWte9kRL858JGCDHxR$ . You are receiving this because you authored the thread. https://github.com/notifications/beacon/AJCDK5UEKQQM47RR4I47GJ3X7OE57A5CNFSM6AAAAAA6ALYDZKWGG33NNVSW45C7OR4XAZNMJFZXG5LFINXW23LFNZ2KUY3PNVWWK3TUL5UWJTTJDHOGS.gif Message ID: @. @.> >
Not sure if your getting the email replies. I tried removing the spaces and still got the error. Here'the MD
If you'd like direct access to the database, let me know. It's publicly accessible from and I can give the connection info
Sorry, thought I sent yesterday. See attached
Jim
From: Jens Hunt @.> Sent: Sunday, October 15, 2023 3:19 AM To: R0tenur/visualization @.> Cc: jmarkulic @.>; Author @.> Subject: Re: [R0tenur/visualization] Mermaid Error with Schema Visualization 0.9.1 (Issue #131)
Would really appreaciate your v0.9.1 markdown
— Reply to this email directly, https://urldefense.com/v3/__https:/github.com/R0tenur/visualization/issues/131*issuecomment-1763302505__;Iw!!DLa72PTfQgg!MvTlshHJC06tSmONgRxBkC-Ap3iL2SISB1fQM3iziDCLcRqtixfkLGFZDs5ZUfeWF-u5qDhWte9kRL858L7g_7Op$ view it on GitHub, or https://urldefense.com/v3/__https:/github.com/notifications/unsubscribe-auth/AJCDK5WEARNU5ZICGLLRLC3X7OE57AVCNFSM6AAAAAA6ALYDZKVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMYTONRTGMYDENJQGU__;!!DLa72PTfQgg!MvTlshHJC06tSmONgRxBkC-Ap3iL2SISB1fQM3iziDCLcRqtixfkLGFZDs5ZUfeWF-u5qDhWte9kRL858JGCDHxR$ unsubscribe. You are receiving this because you authored the thread. https://github.com/notifications/beacon/AJCDK5UEKQQM47RR4I47GJ3X7OE57A5CNFSM6AAAAAA6ALYDZKWGG33NNVSW45C7OR4XAZNMJFZXG5LFINXW23LFNZ2KUY3PNVWWK3TUL5UWJTTJDHOGS.gif Message ID: < @.> @.>
erDiagram
"dbo.Appearances" {
int yearID ""
varchar(255) teamID ""
varchar(25) lgID ""
varchar(255) playerID ""
int G_all ""
varchar(255) GS ""
int G_batting ""
int G_defense ""
int G_p ""
int G_c ""
int G_1b ""
int G_2b ""
int G_3b ""
int G_ss ""
int G_lf ""
int G_cf ""
int G_rf ""
int G_of ""
varchar(255) G_dh ""
varchar(255) G_ph ""
varchar(255) G_pr ""
}
"dbo.AwardsManagers" {
varchar(255) playerID "PK"
varchar(255) awardID "PK"
int yearID "PK"
varchar(25) lgID "PK"
varchar(255) tie ""
varchar(255) notes ""
}
"dbo.AwardsPlayers" {
varchar(255) playerID "FK"
varchar(255) awardID ""
int yearID ""
varchar(25) lgID ""
varchar(255) tie ""
varchar(255) notes ""
}
"dbo.AwardsShareManagers" {
varchar(255) awardID "PK"
int yearID "PK"
varchar(25) lgID "PK"
varchar(255) playerID "PK, FK"
int pointsWon ""
int pointsMax ""
int votesFirst ""
}
"dbo.AwardsSharePlayers" {
varchar(255) awardID "PK"
int yearID "PK"
varchar(25) lgID "PK"
varchar(255) playerID "PK, FK"
int pointsWon ""
int pointsMax ""
int votesFirst ""
}
"dbo.Batting" {
varchar(255) playerID "PK, FK"
int yearID "PK, FK"
int stint "PK"
varchar(255) teamID "PK, FK"
varchar(25) lgID "PK, FK"
int G ""
int AB ""
int R ""
int H ""
int B2 ""
int B3 ""
int HR ""
int RBI ""
int SB ""
int CS ""
int BB ""
int SO ""
varchar(255) IBB ""
varchar(255) HBP ""
varchar(255) SH ""
varchar(255) SF ""
varchar(255) GIDP ""
}
"dbo.CollegePlaying" {
varchar(255) playerID "PK, FK"
varchar(255) schoolID "PK, FK"
int yearID "PK"
}
"dbo.Fielding" {
varchar(255) playerID "FK, PK"
int yearID "PK, FK"
int stint "PK"
varchar(255) teamID "PK, FK"
varchar(25) lgID "PK, FK"
varchar(255) POS "PK"
int G ""
varchar(255) GS ""
varchar(255) InnOuts ""
int PO ""
int A ""
int E ""
int DP ""
varchar(255) PB ""
varchar(255) WP ""
varchar(255) SB ""
varchar(255) CS ""
varchar(255) ZR ""
}
"dbo.HallOfFame" {
varchar(255) playerID "PK, FK"
int yearid "PK"
varchar(255) votedBy "PK"
int ballots ""
int needed ""
int votes ""
varchar(255) inducted "PK"
varchar(255) category ""
varchar(255) needed_note ""
}
"dbo.HomeGames" {
int yearID "PK"
varchar(25) lgID "PK"
varchar(255) teamID "PK"
varchar(255) parkID "PK"
varchar(255) span_first ""
varchar(255) span_last ""
int games ""
int openings ""
int attendance ""
}
"dbo.Managers" {
varchar(255) playerID "PK"
int yearID "PK"
varchar(255) teamID "PK"
varchar(25) lgID "PK"
int inseason "PK"
int G ""
int W ""
int L ""
int rank ""
varchar(255) plyrMgr ""
}
"dbo.People" {
varchar(255) playerID "PK"
int birthYear ""
int birthMonth ""
int birthDay ""
varchar(255) birthCountry ""
varchar(255) birthState ""
varchar(255) birthCity ""
varchar(255) deathYear ""
varchar(255) deathMonth ""
varchar(255) deathDay ""
varchar(255) deathCountry ""
varchar(255) deathState ""
varchar(255) deathCity ""
varchar(255) nameFirst ""
varchar(255) nameLast ""
varchar(255) nameGiven ""
int weight ""
int height ""
varchar(255) bats ""
varchar(255) throws ""
varchar(255) debut ""
varchar(255) finalGame ""
varchar(255) retroID ""
varchar(255) bbrefID ""
int Total_HR ""
float High_BA ""
money Total_401K ""
int SRP42_Total_G_Played ""
float SRP42_Career_Range_Factor ""
int ff26_Total_G_Played ""
decimal ff26_Career_Range_Factor ""
}
"dbo.AllstarFull" {
varchar(255) playerID "PK"
int yearID "PK, FK"
int gameNum ""
varchar(255) gameID "PK"
varchar(255) teamID "PK, FK"
varchar(25) lgID "PK, FK"
int GP ""
varchar(255) startingPos ""
}
"dbo.Pitching" {
varchar(255) playerID "PK, FK"
int yearID "PK, FK"
int stint "PK"
varchar(255) teamID "PK, FK"
varchar(25) lgID "PK, FK"
int W ""
int L ""
int G ""
int GS ""
int CG ""
int SHO ""
int SV ""
int IPouts ""
int H ""
int ER ""
int HR ""
int BB ""
int SO ""
varchar(255) BAOpp ""
float ERA ""
varchar(255) IBB ""
varchar(255) WP ""
varchar(255) HBP ""
int BK ""
varchar(255) BFP ""
varchar(255) GF ""
int R ""
varchar(255) SH ""
varchar(255) SF ""
varchar(255) GIDP ""
}
"dbo.Salaries" {
int yearID ""
varchar(255) teamID ""
varchar(25) lgID ""
varchar(255) playerID ""
money salary ""
money _401K_Player_Contributions ""
money _401K_Team_Contributions ""
}
"dbo.Schools" {
varchar(255) schoolID "PK"
varchar(255) name_full ""
varchar(255) city ""
varchar(255) state ""
varchar(255) country ""
}
"dbo.Teams" {
int yearID "PK"
varchar(25) lgID "PK"
varchar(255) teamID "PK"
varchar(255) franchID ""
varchar(255) divID ""
int Team_Rank ""
int G ""
varchar(255) Ghome ""
int W ""
int L ""
varchar(255) DivWin ""
varchar(255) WCWin ""
varchar(255) LgWin ""
varchar(255) WSWin ""
int R ""
int AB ""
int H ""
int B2 ""
int B3 ""
int HR ""
int BB ""
int SO ""
int SB ""
varchar(255) CS ""
varchar(255) HBP ""
varchar(255) SF ""
int RA ""
int ER ""
float ERA ""
int CG ""
int SHO ""
int SV ""
int IPouts ""
int HA ""
int HRA ""
int BBA ""
int SOA ""
int E ""
varchar(255) DP ""
float FP ""
varchar(255) name ""
varchar(255) park ""
varchar(255) attendance ""
int BPF ""
int PPF ""
varchar(255) teamIDBR ""
varchar(255) teamIDlahman45 ""
varchar(255) teamIDretro ""
}
"dbo.TeamsFranchises" {
varchar(255) franchID "PK"
varchar(255) franchName ""
varchar(255) active ""
varchar(255) NAassoc ""
}
"dbo.Players2023Fall" {
varchar(255) playerID "PK, FK"
}
"dbo.Parks" {
varchar(100) park_key "PK"
varchar(255) park_name ""
varchar(100) par_alias ""
varchar(255) city ""
varchar(100) state ""
varchar(100) country ""
}
"View: dbo.Sp2787_Player_Summary" {
dbo_Appearances yearID ""
dbo_Appearances teamID ""
dbo_Appearances playerID ""
dbo_Batting AB ""
dbo_Batting H ""
dbo_Batting HR ""
dbo_CollegePlaying schoolID ""
dbo_Fielding G ""
dbo_Fielding GS ""
dbo_HallOfFame yearid ""
dbo_HallOfFame inducted ""
dbo_People nameFirst ""
dbo_People nameLast ""
dbo_People nameGiven ""
dbo_People Total_401K ""
dbo_Pitching W ""
dbo_Pitching IPouts ""
dbo_Pitching BB ""
dbo_Pitching SO ""
dbo_Salaries salary ""
}
"View: dbo.SRP42_Player_Summary" {
dbo_AwardsManagers playerID ""
dbo_Batting yearID ""
dbo_Batting teamID ""
dbo_Batting AB ""
dbo_Batting H ""
dbo_Batting HR ""
dbo_Fielding G ""
dbo_Fielding GS ""
dbo_HallOfFame yearid ""
dbo_HallOfFame inducted ""
dbo_People nameFirst ""
dbo_People nameLast ""
dbo_People Total_401K ""
dbo_Pitching W ""
dbo_Pitching IPouts ""
dbo_Pitching BB ""
dbo_Pitching SO ""
dbo_Salaries salary ""
}
"View: dbo.pr469_player_summary" {
dbo_AwardsManagers playerID ""
dbo_AwardsManagers awardID ""
dbo_Batting yearID ""
dbo_Batting teamID ""
dbo_Batting AB ""
dbo_Batting H ""
dbo_Batting HR ""
dbo_Fielding G ""
dbo_Fielding GS ""
dbo_HallOfFame inducted ""
dbo_People nameFirst ""
dbo_People nameLast ""
dbo_People Total_401K ""
dbo_Pitching W ""
dbo_Pitching IPouts ""
dbo_Pitching BB ""
dbo_Pitching SO ""
dbo_Salaries salary ""
}
"View: dbo.31522101_Player_Summary" {
dbo_AwardsManagers playerID ""
dbo_Batting yearID ""
dbo_Batting teamID ""
dbo_Batting AB ""
dbo_Batting H ""
dbo_Batting HR ""
dbo_Fielding G ""
dbo_Fielding GS ""
dbo_HallOfFame yearid ""
dbo_HallOfFame inducted ""
dbo_People Total_401K ""
dbo_Pitching W ""
dbo_Pitching IPouts ""
dbo_Pitching BB ""
dbo_Pitching SO ""
dbo_Salaries salary ""
}
"View: dbo.ff26_Player_Summary" {
dbo_AwardsManagers playerID ""
dbo_Batting yearID ""
dbo_Batting teamID ""
dbo_Batting AB ""
dbo_Batting H ""
dbo_Batting HR ""
dbo_Fielding G ""
dbo_Fielding GS ""
dbo_HallOfFame yearid ""
dbo_HallOfFame inducted ""
dbo_People nameFirst ""
dbo_People nameLast ""
dbo_People Total_401K ""
dbo_Pitching W ""
dbo_Pitching IPouts ""
dbo_Pitching BB ""
dbo_Pitching SO ""
dbo_Salaries salary ""
}
"View: dbo.CS525_Player_Summary" {
dbo_AwardsManagers playerID ""
dbo_Batting yearID ""
dbo_Batting teamID ""
dbo_Batting AB ""
dbo_Batting H ""
dbo_Batting HR ""
dbo_Fielding G ""
dbo_Fielding GS ""
dbo_HallOfFame yearid ""
dbo_HallOfFame inducted ""
dbo_People nameFirst ""
dbo_People nameLast ""
dbo_People Total_401K ""
dbo_Pitching W ""
dbo_Pitching IPouts ""
dbo_Pitching BB ""
dbo_Pitching SO ""
dbo_Salaries salary ""
}
"View: dbo.JIH_Player_Summary" {
dbo_AwardsManagers playerID ""
dbo_AwardsManagers awardID ""
dbo_Batting yearID ""
dbo_Batting teamID ""
dbo_Batting AB ""
dbo_Batting H ""
dbo_Batting HR ""
dbo_HallOfFame yearid ""
dbo_HallOfFame inducted ""
dbo_People nameFirst ""
dbo_People nameLast ""
dbo_People nameGiven ""
dbo_People Total_401K ""
dbo_Pitching W ""
dbo_Pitching G ""
dbo_Pitching GS ""
dbo_Pitching IPouts ""
dbo_Pitching BB ""
dbo_Pitching SO ""
dbo_Salaries salary ""
}
"View: dbo.mm2836_Player_Summary" {
dbo_AwardsManagers playerID ""
dbo_AwardsManagers awardID ""
dbo_AwardsManagers yearID ""
dbo_AwardsManagers lgID ""
dbo_Batting teamID ""
dbo_Batting AB ""
dbo_Batting H ""
dbo_Batting HR ""
dbo_Fielding G ""
dbo_Fielding GS ""
dbo_HallOfFame yearid ""
dbo_HallOfFame inducted ""
dbo_People nameFirst ""
dbo_People nameLast ""
dbo_People nameGiven ""
dbo_People Total_401K ""
dbo_Pitching W ""
dbo_Pitching IPouts ""
dbo_Pitching BB ""
dbo_Pitching SO ""
dbo_Salaries salary ""
}
"View: dbo.rn352_Player_Summary" {
dbo_AwardsManagers playerID ""
dbo_Batting yearID ""
dbo_Batting teamID ""
dbo_Batting AB ""
dbo_Batting H ""
dbo_Batting HR ""
dbo_Fielding G ""
dbo_Fielding GS ""
dbo_HallOfFame yearid ""
dbo_HallOfFame inducted ""
dbo_People nameFirst ""
dbo_People nameLast ""
dbo_People Total_401K ""
dbo_Pitching W ""
dbo_Pitching IPouts ""
dbo_Pitching BB ""
dbo_Pitching SO ""
dbo_Salaries salary ""
}
"View: dbo.vs733_Player_summary" {
dbo_AwardsShareManagers playerID ""
dbo_Batting yearID ""
dbo_Batting teamID ""
dbo_Batting AB ""
dbo_Batting H ""
dbo_Batting HR ""
dbo_CollegePlaying schoolID ""
dbo_Fielding G ""
dbo_Fielding GS ""
dbo_HallOfFame yearid ""
dbo_HallOfFame inducted ""
dbo_People nameFirst ""
dbo_People nameLast ""
dbo_People nameGiven ""
dbo_People Total_401K ""
dbo_Pitching W ""
dbo_Pitching IPouts ""
dbo_Pitching BB ""
dbo_Pitching SO ""
dbo_Salaries salary ""
}
"View: dbo.PlayerStats" {
dbo_Batting playerID ""
dbo_Batting yearID ""
dbo_Batting teamID ""
dbo_Batting AB ""
dbo_Batting H ""
dbo_Batting HR ""
dbo_People nameFirst ""
dbo_People nameLast ""
dbo_People nameGiven ""
dbo_Salaries salary ""
}
"View: dbo.IS631View" {
dbo_Batting playerID ""
dbo_Batting yearID ""
dbo_Batting AB ""
dbo_Batting H ""
dbo_Batting HR ""
dbo_People nameFirst ""
dbo_People nameLast ""
dbo_People nameGiven ""
dbo_Pitching W ""
dbo_Pitching L ""
dbo_Pitching SO ""
dbo_Pitching ERA ""
dbo_Salaries salary ""
}
"dbo.AwardsPlayers" ||--|{ "dbo.People": "playerID"
"dbo.AwardsShareManagers" ||--|{ "dbo.People": "playerID"
"dbo.AwardsSharePlayers" ||--|{ "dbo.People": "playerID"
"dbo.Batting" ||--|{ "dbo.People": "playerID"
"dbo.Batting" ||--|{ "dbo.Teams": "yearID"
"dbo.Batting" ||--|{ "dbo.Teams": "teamID"
"dbo.Batting" ||--|{ "dbo.Teams": "lgID"
"dbo.CollegePlaying" ||--|{ "dbo.People": "playerID"
"dbo.CollegePlaying" ||--|{ "dbo.Schools": "schoolID"
"dbo.Fielding" ||--|{ "dbo.People": "playerID"
"dbo.Fielding" ||--|{ "dbo.Teams": "yearID"
"dbo.Fielding" ||--|{ "dbo.Teams": "teamID"
"dbo.Fielding" ||--|{ "dbo.Teams": "lgID"
"dbo.HallOfFame" ||--|{ "dbo.People": "playerID"
"dbo.AllstarFull" ||--|{ "dbo.Teams": "yearID"
"dbo.AllstarFull" ||--|{ "dbo.Teams": "teamID"
"dbo.AllstarFull" ||--|{ "dbo.Teams": "lgID"
"dbo.Pitching" ||--|{ "dbo.People": "playerID"
"dbo.Pitching" ||--|{ "dbo.Teams": "yearID"
"dbo.Pitching" ||--|{ "dbo.Teams": "teamID"
"dbo.Pitching" ||--|{ "dbo.Teams": "lgID"
"dbo.Players2023Fall" ||--|{ "dbo.People": "playerID"
"View: dbo.Sp2787_Player_Summary" ||--|| "dbo.Appearances": "Sp2787_Player_Summary => Appearances"
"View: dbo.Sp2787_Player_Summary" ||--|| "dbo.Appearances": "Sp2787_Player_Summary => Appearances"
"View: dbo.Sp2787_Player_Summary" ||--|| "dbo.Appearances": "Sp2787_Player_Summary => Appearances"
"View: dbo.Sp2787_Player_Summary" ||--|| "dbo.Batting": "Sp2787_Player_Summary => Batting"
"View: dbo.Sp2787_Player_Summary" ||--|| "dbo.Batting": "Sp2787_Player_Summary => Batting"
"View: dbo.Sp2787_Player_Summary" ||--|| "dbo.Batting": "Sp2787_Player_Summary => Batting"
"View: dbo.Sp2787_Player_Summary" ||--|| "dbo.CollegePlaying": "Sp2787_Player_Summary => CollegePlaying"
"View: dbo.Sp2787_Player_Summary" ||--|| "dbo.Fielding": "Sp2787_Player_Summary => Fielding"
"View: dbo.Sp2787_Player_Summary" ||--|| "dbo.Fielding": "Sp2787_Player_Summary => Fielding"
"View: dbo.Sp2787_Player_Summary" ||--|| "dbo.HallOfFame": "Sp2787_Player_Summary => HallOfFame"
"View: dbo.Sp2787_Player_Summary" ||--|| "dbo.HallOfFame": "Sp2787_Player_Summary => HallOfFame"
"View: dbo.Sp2787_Player_Summary" ||--|| "dbo.People": "Sp2787_Player_Summary => People"
"View: dbo.Sp2787_Player_Summary" ||--|| "dbo.People": "Sp2787_Player_Summary => People"
"View: dbo.Sp2787_Player_Summary" ||--|| "dbo.People": "Sp2787_Player_Summary => People"
"View: dbo.Sp2787_Player_Summary" ||--|| "dbo.People": "Sp2787_Player_Summary => People"
"View: dbo.Sp2787_Player_Summary" ||--|| "dbo.Pitching": "Sp2787_Player_Summary => Pitching"
"View: dbo.Sp2787_Player_Summary" ||--|| "dbo.Pitching": "Sp2787_Player_Summary => Pitching"
"View: dbo.Sp2787_Player_Summary" ||--|| "dbo.Pitching": "Sp2787_Player_Summary => Pitching"
"View: dbo.Sp2787_Player_Summary" ||--|| "dbo.Pitching": "Sp2787_Player_Summary => Pitching"
"View: dbo.Sp2787_Player_Summary" ||--|| "dbo.Salaries": "Sp2787_Player_Summary => Salaries"
"View: dbo.SRP42_Player_Summary" ||--|| "dbo.AwardsManagers": "SRP42_Player_Summary => AwardsManagers"
"View: dbo.SRP42_Player_Summary" ||--|| "dbo.Batting": "SRP42_Player_Summary => Batting"
"View: dbo.SRP42_Player_Summary" ||--|| "dbo.Batting": "SRP42_Player_Summary => Batting"
"View: dbo.SRP42_Player_Summary" ||--|| "dbo.Batting": "SRP42_Player_Summary => Batting"
"View: dbo.SRP42_Player_Summary" ||--|| "dbo.Batting": "SRP42_Player_Summary => Batting"
"View: dbo.SRP42_Player_Summary" ||--|| "dbo.Batting": "SRP42_Player_Summary => Batting"
"View: dbo.SRP42_Player_Summary" ||--|| "dbo.Fielding": "SRP42_Player_Summary => Fielding"
"View: dbo.SRP42_Player_Summary" ||--|| "dbo.Fielding": "SRP42_Player_Summary => Fielding"
"View: dbo.SRP42_Player_Summary" ||--|| "dbo.HallOfFame": "SRP42_Player_Summary => HallOfFame"
"View: dbo.SRP42_Player_Summary" ||--|| "dbo.HallOfFame": "SRP42_Player_Summary => HallOfFame"
"View: dbo.SRP42_Player_Summary" ||--|| "dbo.People": "SRP42_Player_Summary => People"
"View: dbo.SRP42_Player_Summary" ||--|| "dbo.People": "SRP42_Player_Summary => People"
"View: dbo.SRP42_Player_Summary" ||--|| "dbo.People": "SRP42_Player_Summary => People"
"View: dbo.SRP42_Player_Summary" ||--|| "dbo.Pitching": "SRP42_Player_Summary => Pitching"
"View: dbo.SRP42_Player_Summary" ||--|| "dbo.Pitching": "SRP42_Player_Summary => Pitching"
"View: dbo.SRP42_Player_Summary" ||--|| "dbo.Pitching": "SRP42_Player_Summary => Pitching"
"View: dbo.SRP42_Player_Summary" ||--|| "dbo.Pitching": "SRP42_Player_Summary => Pitching"
"View: dbo.SRP42_Player_Summary" ||--|| "dbo.Salaries": "SRP42_Player_Summary => Salaries"
"View: dbo.pr469_player_summary" ||--|| "dbo.AwardsManagers": "pr469_player_summary => AwardsManagers"
"View: dbo.pr469_player_summary" ||--|| "dbo.AwardsManagers": "pr469_player_summary => AwardsManagers"
"View: dbo.pr469_player_summary" ||--|| "dbo.Batting": "pr469_player_summary => Batting"
"View: dbo.pr469_player_summary" ||--|| "dbo.Batting": "pr469_player_summary => Batting"
"View: dbo.pr469_player_summary" ||--|| "dbo.Batting": "pr469_player_summary => Batting"
"View: dbo.pr469_player_summary" ||--|| "dbo.Batting": "pr469_player_summary => Batting"
"View: dbo.pr469_player_summary" ||--|| "dbo.Batting": "pr469_player_summary => Batting"
"View: dbo.pr469_player_summary" ||--|| "dbo.Fielding": "pr469_player_summary => Fielding"
"View: dbo.pr469_player_summary" ||--|| "dbo.Fielding": "pr469_player_summary => Fielding"
"View: dbo.pr469_player_summary" ||--|| "dbo.HallOfFame": "pr469_player_summary => HallOfFame"
"View: dbo.pr469_player_summary" ||--|| "dbo.People": "pr469_player_summary => People"
"View: dbo.pr469_player_summary" ||--|| "dbo.People": "pr469_player_summary => People"
"View: dbo.pr469_player_summary" ||--|| "dbo.People": "pr469_player_summary => People"
"View: dbo.pr469_player_summary" ||--|| "dbo.Pitching": "pr469_player_summary => Pitching"
"View: dbo.pr469_player_summary" ||--|| "dbo.Pitching": "pr469_player_summary => Pitching"
"View: dbo.pr469_player_summary" ||--|| "dbo.Pitching": "pr469_player_summary => Pitching"
"View: dbo.pr469_player_summary" ||--|| "dbo.Pitching": "pr469_player_summary => Pitching"
"View: dbo.pr469_player_summary" ||--|| "dbo.Salaries": "pr469_player_summary => Salaries"
"View: dbo.31522101_Player_Summary" ||--|| "dbo.AwardsManagers": "31522101_Player_Summary => AwardsManagers"
"View: dbo.31522101_Player_Summary" ||--|| "dbo.Batting": "31522101_Player_Summary => Batting"
"View: dbo.31522101_Player_Summary" ||--|| "dbo.Batting": "31522101_Player_Summary => Batting"
"View: dbo.31522101_Player_Summary" ||--|| "dbo.Batting": "31522101_Player_Summary => Batting"
"View: dbo.31522101_Player_Summary" ||--|| "dbo.Batting": "31522101_Player_Summary => Batting"
"View: dbo.31522101_Player_Summary" ||--|| "dbo.Batting": "31522101_Player_Summary => Batting"
"View: dbo.31522101_Player_Summary" ||--|| "dbo.Fielding": "31522101_Player_Summary => Fielding"
"View: dbo.31522101_Player_Summary" ||--|| "dbo.Fielding": "31522101_Player_Summary => Fielding"
"View: dbo.31522101_Player_Summary" ||--|| "dbo.HallOfFame": "31522101_Player_Summary => HallOfFame"
"View: dbo.31522101_Player_Summary" ||--|| "dbo.HallOfFame": "31522101_Player_Summary => HallOfFame"
"View: dbo.31522101_Player_Summary" ||--|| "dbo.People": "31522101_Player_Summary => People"
"View: dbo.31522101_Player_Summary" ||--|| "dbo.Pitching": "31522101_Player_Summary => Pitching"
"View: dbo.31522101_Player_Summary" ||--|| "dbo.Pitching": "31522101_Player_Summary => Pitching"
"View: dbo.31522101_Player_Summary" ||--|| "dbo.Pitching": "31522101_Player_Summary => Pitching"
"View: dbo.31522101_Player_Summary" ||--|| "dbo.Pitching": "31522101_Player_Summary => Pitching"
"View: dbo.31522101_Player_Summary" ||--|| "dbo.Salaries": "31522101_Player_Summary => Salaries"
"View: dbo.ff26_Player_Summary" ||--|| "dbo.AwardsManagers": "ff26_Player_Summary => AwardsManagers"
"View: dbo.ff26_Player_Summary" ||--|| "dbo.Batting": "ff26_Player_Summary => Batting"
"View: dbo.ff26_Player_Summary" ||--|| "dbo.Batting": "ff26_Player_Summary => Batting"
"View: dbo.ff26_Player_Summary" ||--|| "dbo.Batting": "ff26_Player_Summary => Batting"
"View: dbo.ff26_Player_Summary" ||--|| "dbo.Batting": "ff26_Player_Summary => Batting"
"View: dbo.ff26_Player_Summary" ||--|| "dbo.Batting": "ff26_Player_Summary => Batting"
"View: dbo.ff26_Player_Summary" ||--|| "dbo.Fielding": "ff26_Player_Summary => Fielding"
"View: dbo.ff26_Player_Summary" ||--|| "dbo.Fielding": "ff26_Player_Summary => Fielding"
"View: dbo.ff26_Player_Summary" ||--|| "dbo.HallOfFame": "ff26_Player_Summary => HallOfFame"
"View: dbo.ff26_Player_Summary" ||--|| "dbo.HallOfFame": "ff26_Player_Summary => HallOfFame"
"View: dbo.ff26_Player_Summary" ||--|| "dbo.People": "ff26_Player_Summary => People"
"View: dbo.ff26_Player_Summary" ||--|| "dbo.People": "ff26_Player_Summary => People"
"View: dbo.ff26_Player_Summary" ||--|| "dbo.People": "ff26_Player_Summary => People"
"View: dbo.ff26_Player_Summary" ||--|| "dbo.Pitching": "ff26_Player_Summary => Pitching"
"View: dbo.ff26_Player_Summary" ||--|| "dbo.Pitching": "ff26_Player_Summary => Pitching"
"View: dbo.ff26_Player_Summary" ||--|| "dbo.Pitching": "ff26_Player_Summary => Pitching"
"View: dbo.ff26_Player_Summary" ||--|| "dbo.Pitching": "ff26_Player_Summary => Pitching"
"View: dbo.ff26_Player_Summary" ||--|| "dbo.Salaries": "ff26_Player_Summary => Salaries"
"View: dbo.CS525_Player_Summary" ||--|| "dbo.AwardsManagers": "CS525_Player_Summary => AwardsManagers"
"View: dbo.CS525_Player_Summary" ||--|| "dbo.Batting": "CS525_Player_Summary => Batting"
"View: dbo.CS525_Player_Summary" ||--|| "dbo.Batting": "CS525_Player_Summary => Batting"
"View: dbo.CS525_Player_Summary" ||--|| "dbo.Batting": "CS525_Player_Summary => Batting"
"View: dbo.CS525_Player_Summary" ||--|| "dbo.Batting": "CS525_Player_Summary => Batting"
"View: dbo.CS525_Player_Summary" ||--|| "dbo.Batting": "CS525_Player_Summary => Batting"
"View: dbo.CS525_Player_Summary" ||--|| "dbo.Fielding": "CS525_Player_Summary => Fielding"
"View: dbo.CS525_Player_Summary" ||--|| "dbo.Fielding": "CS525_Player_Summary => Fielding"
"View: dbo.CS525_Player_Summary" ||--|| "dbo.HallOfFame": "CS525_Player_Summary => HallOfFame"
"View: dbo.CS525_Player_Summary" ||--|| "dbo.HallOfFame": "CS525_Player_Summary => HallOfFame"
"View: dbo.CS525_Player_Summary" ||--|| "dbo.People": "CS525_Player_Summary => People"
"View: dbo.CS525_Player_Summary" ||--|| "dbo.People": "CS525_Player_Summary => People"
"View: dbo.CS525_Player_Summary" ||--|| "dbo.People": "CS525_Player_Summary => People"
"View: dbo.CS525_Player_Summary" ||--|| "dbo.Pitching": "CS525_Player_Summary => Pitching"
"View: dbo.CS525_Player_Summary" ||--|| "dbo.Pitching": "CS525_Player_Summary => Pitching"
"View: dbo.CS525_Player_Summary" ||--|| "dbo.Pitching": "CS525_Player_Summary => Pitching"
"View: dbo.CS525_Player_Summary" ||--|| "dbo.Pitching": "CS525_Player_Summary => Pitching"
"View: dbo.CS525_Player_Summary" ||--|| "dbo.Salaries": "CS525_Player_Summary => Salaries"
"View: dbo.JIH_Player_Summary" ||--|| "dbo.AwardsManagers": "JIH_Player_Summary => AwardsManagers"
"View: dbo.JIH_Player_Summary" ||--|| "dbo.AwardsManagers": "JIH_Player_Summary => AwardsManagers"
"View: dbo.JIH_Player_Summary" ||--|| "dbo.Batting": "JIH_Player_Summary => Batting"
"View: dbo.JIH_Player_Summary" ||--|| "dbo.Batting": "JIH_Player_Summary => Batting"
"View: dbo.JIH_Player_Summary" ||--|| "dbo.Batting": "JIH_Player_Summary => Batting"
"View: dbo.JIH_Player_Summary" ||--|| "dbo.Batting": "JIH_Player_Summary => Batting"
"View: dbo.JIH_Player_Summary" ||--|| "dbo.Batting": "JIH_Player_Summary => Batting"
"View: dbo.JIH_Player_Summary" ||--|| "dbo.HallOfFame": "JIH_Player_Summary => HallOfFame"
"View: dbo.JIH_Player_Summary" ||--|| "dbo.HallOfFame": "JIH_Player_Summary => HallOfFame"
"View: dbo.JIH_Player_Summary" ||--|| "dbo.People": "JIH_Player_Summary => People"
"View: dbo.JIH_Player_Summary" ||--|| "dbo.People": "JIH_Player_Summary => People"
"View: dbo.JIH_Player_Summary" ||--|| "dbo.People": "JIH_Player_Summary => People"
"View: dbo.JIH_Player_Summary" ||--|| "dbo.People": "JIH_Player_Summary => People"
"View: dbo.JIH_Player_Summary" ||--|| "dbo.Pitching": "JIH_Player_Summary => Pitching"
"View: dbo.JIH_Player_Summary" ||--|| "dbo.Pitching": "JIH_Player_Summary => Pitching"
"View: dbo.JIH_Player_Summary" ||--|| "dbo.Pitching": "JIH_Player_Summary => Pitching"
"View: dbo.JIH_Player_Summary" ||--|| "dbo.Pitching": "JIH_Player_Summary => Pitching"
"View: dbo.JIH_Player_Summary" ||--|| "dbo.Pitching": "JIH_Player_Summary => Pitching"
"View: dbo.JIH_Player_Summary" ||--|| "dbo.Pitching": "JIH_Player_Summary => Pitching"
"View: dbo.JIH_Player_Summary" ||--|| "dbo.Salaries": "JIH_Player_Summary => Salaries"
"View: dbo.mm2836_Player_Summary" ||--|| "dbo.AwardsManagers": "mm2836_Player_Summary => AwardsManagers"
"View: dbo.mm2836_Player_Summary" ||--|| "dbo.AwardsManagers": "mm2836_Player_Summary => AwardsManagers"
"View: dbo.mm2836_Player_Summary" ||--|| "dbo.AwardsManagers": "mm2836_Player_Summary => AwardsManagers"
"View: dbo.mm2836_Player_Summary" ||--|| "dbo.AwardsManagers": "mm2836_Player_Summary => AwardsManagers"
"View: dbo.mm2836_Player_Summary" ||--|| "dbo.Batting": "mm2836_Player_Summary => Batting"
"View: dbo.mm2836_Player_Summary" ||--|| "dbo.Batting": "mm2836_Player_Summary => Batting"
"View: dbo.mm2836_Player_Summary" ||--|| "dbo.Batting": "mm2836_Player_Summary => Batting"
"View: dbo.mm2836_Player_Summary" ||--|| "dbo.Batting": "mm2836_Player_Summary => Batting"
"View: dbo.mm2836_Player_Summary" ||--|| "dbo.Fielding": "mm2836_Player_Summary => Fielding"
"View: dbo.mm2836_Player_Summary" ||--|| "dbo.Fielding": "mm2836_Player_Summary => Fielding"
"View: dbo.mm2836_Player_Summary" ||--|| "dbo.HallOfFame": "mm2836_Player_Summary => HallOfFame"
"View: dbo.mm2836_Player_Summary" ||--|| "dbo.HallOfFame": "mm2836_Player_Summary => HallOfFame"
"View: dbo.mm2836_Player_Summary" ||--|| "dbo.People": "mm2836_Player_Summary => People"
"View: dbo.mm2836_Player_Summary" ||--|| "dbo.People": "mm2836_Player_Summary => People"
"View: dbo.mm2836_Player_Summary" ||--|| "dbo.People": "mm2836_Player_Summary => People"
"View: dbo.mm2836_Player_Summary" ||--|| "dbo.People": "mm2836_Player_Summary => People"
"View: dbo.mm2836_Player_Summary" ||--|| "dbo.Pitching": "mm2836_Player_Summary => Pitching"
"View: dbo.mm2836_Player_Summary" ||--|| "dbo.Pitching": "mm2836_Player_Summary => Pitching"
"View: dbo.mm2836_Player_Summary" ||--|| "dbo.Pitching": "mm2836_Player_Summary => Pitching"
"View: dbo.mm2836_Player_Summary" ||--|| "dbo.Pitching": "mm2836_Player_Summary => Pitching"
"View: dbo.mm2836_Player_Summary" ||--|| "dbo.Salaries": "mm2836_Player_Summary => Salaries"
"View: dbo.rn352_Player_Summary" ||--|| "dbo.AwardsManagers": "rn352_Player_Summary => AwardsManagers"
"View: dbo.rn352_Player_Summary" ||--|| "dbo.Batting": "rn352_Player_Summary => Batting"
"View: dbo.rn352_Player_Summary" ||--|| "dbo.Batting": "rn352_Player_Summary => Batting"
"View: dbo.rn352_Player_Summary" ||--|| "dbo.Batting": "rn352_Player_Summary => Batting"
"View: dbo.rn352_Player_Summary" ||--|| "dbo.Batting": "rn352_Player_Summary => Batting"
"View: dbo.rn352_Player_Summary" ||--|| "dbo.Batting": "rn352_Player_Summary => Batting"
"View: dbo.rn352_Player_Summary" ||--|| "dbo.Fielding": "rn352_Player_Summary => Fielding"
"View: dbo.rn352_Player_Summary" ||--|| "dbo.Fielding": "rn352_Player_Summary => Fielding"
"View: dbo.rn352_Player_Summary" ||--|| "dbo.HallOfFame": "rn352_Player_Summary => HallOfFame"
"View: dbo.rn352_Player_Summary" ||--|| "dbo.HallOfFame": "rn352_Player_Summary => HallOfFame"
"View: dbo.rn352_Player_Summary" ||--|| "dbo.People": "rn352_Player_Summary => People"
"View: dbo.rn352_Player_Summary" ||--|| "dbo.People": "rn352_Player_Summary => People"
"View: dbo.rn352_Player_Summary" ||--|| "dbo.People": "rn352_Player_Summary => People"
"View: dbo.rn352_Player_Summary" ||--|| "dbo.Pitching": "rn352_Player_Summary => Pitching"
"View: dbo.rn352_Player_Summary" ||--|| "dbo.Pitching": "rn352_Player_Summary => Pitching"
"View: dbo.rn352_Player_Summary" ||--|| "dbo.Pitching": "rn352_Player_Summary => Pitching"
"View: dbo.rn352_Player_Summary" ||--|| "dbo.Pitching": "rn352_Player_Summary => Pitching"
"View: dbo.rn352_Player_Summary" ||--|| "dbo.Salaries": "rn352_Player_Summary => Salaries"
"View: dbo.vs733_Player_summary" ||--|| "dbo.AwardsShareManagers": "vs733_Player_summary => AwardsShareManagers"
"View: dbo.vs733_Player_summary" ||--|| "dbo.Batting": "vs733_Player_summary => Batting"
"View: dbo.vs733_Player_summary" ||--|| "dbo.Batting": "vs733_Player_summary => Batting"
"View: dbo.vs733_Player_summary" ||--|| "dbo.Batting": "vs733_Player_summary => Batting"
"View: dbo.vs733_Player_summary" ||--|| "dbo.Batting": "vs733_Player_summary => Batting"
"View: dbo.vs733_Player_summary" ||--|| "dbo.Batting": "vs733_Player_summary => Batting"
"View: dbo.vs733_Player_summary" ||--|| "dbo.CollegePlaying": "vs733_Player_summary => CollegePlaying"
"View: dbo.vs733_Player_summary" ||--|| "dbo.Fielding": "vs733_Player_summary => Fielding"
"View: dbo.vs733_Player_summary" ||--|| "dbo.Fielding": "vs733_Player_summary => Fielding"
"View: dbo.vs733_Player_summary" ||--|| "dbo.HallOfFame": "vs733_Player_summary => HallOfFame"
"View: dbo.vs733_Player_summary" ||--|| "dbo.HallOfFame": "vs733_Player_summary => HallOfFame"
"View: dbo.vs733_Player_summary" ||--|| "dbo.People": "vs733_Player_summary => People"
"View: dbo.vs733_Player_summary" ||--|| "dbo.People": "vs733_Player_summary => People"
"View: dbo.vs733_Player_summary" ||--|| "dbo.People": "vs733_Player_summary => People"
"View: dbo.vs733_Player_summary" ||--|| "dbo.People": "vs733_Player_summary => People"
"View: dbo.vs733_Player_summary" ||--|| "dbo.Pitching": "vs733_Player_summary => Pitching"
"View: dbo.vs733_Player_summary" ||--|| "dbo.Pitching": "vs733_Player_summary => Pitching"
"View: dbo.vs733_Player_summary" ||--|| "dbo.Pitching": "vs733_Player_summary => Pitching"
"View: dbo.vs733_Player_summary" ||--|| "dbo.Pitching": "vs733_Player_summary => Pitching"
"View: dbo.vs733_Player_summary" ||--|| "dbo.Salaries": "vs733_Player_summary => Salaries"
"View: dbo.PlayerStats" ||--|| "dbo.Batting": "PlayerStats => Batting"
"View: dbo.PlayerStats" ||--|| "dbo.Batting": "PlayerStats => Batting"
"View: dbo.PlayerStats" ||--|| "dbo.Batting": "PlayerStats => Batting"
"View: dbo.PlayerStats" ||--|| "dbo.Batting": "PlayerStats => Batting"
"View: dbo.PlayerStats" ||--|| "dbo.Batting": "PlayerStats => Batting"
"View: dbo.PlayerStats" ||--|| "dbo.Batting": "PlayerStats => Batting"
"View: dbo.PlayerStats" ||--|| "dbo.People": "PlayerStats => People"
"View: dbo.PlayerStats" ||--|| "dbo.People": "PlayerStats => People"
"View: dbo.PlayerStats" ||--|| "dbo.People": "PlayerStats => People"
"View: dbo.PlayerStats" ||--|| "dbo.Salaries": "PlayerStats => Salaries"
"View: dbo.IS631View" ||--|| "dbo.Batting": "IS631View => Batting"
"View: dbo.IS631View" ||--|| "dbo.Batting": "IS631View => Batting"
"View: dbo.IS631View" ||--|| "dbo.Batting": "IS631View => Batting"
"View: dbo.IS631View" ||--|| "dbo.Batting": "IS631View => Batting"
"View: dbo.IS631View" ||--|| "dbo.Batting": "IS631View => Batting"
"View: dbo.IS631View" ||--|| "dbo.People": "IS631View => People"
"View: dbo.IS631View" ||--|| "dbo.People": "IS631View => People"
"View: dbo.IS631View" ||--|| "dbo.People": "IS631View => People"
"View: dbo.IS631View" ||--|| "dbo.Pitching": "IS631View => Pitching"
"View: dbo.IS631View" ||--|| "dbo.Pitching": "IS631View => Pitching"
"View: dbo.IS631View" ||--|| "dbo.Pitching": "IS631View => Pitching"
"View: dbo.IS631View" ||--|| "dbo.Pitching": "IS631View => Pitching"
"View: dbo.IS631View" ||--|| "dbo.Salaries": "IS631View => Salaries"
Apparently mermaid don't like when a column start with a number
I changed the 401K_Player_Contributions to _401K_Player_Contributions in the chart and now the markdown seem fine.
I will need to handle that in the extension
Thanks. I names the column that way to show students some of the problems that you can encounter when starting a column name with a number. Now I have another reason to tell them :-) Thanks for looking into this so quickly.
Jim
Thank you for reporting and providing the data. I have done a fix for this in #132 but think I want to do it a bit more proper before make it into release. If you are eager to use it I could publish it anyway
Thanks for the offer, but no hurry. I can wait.
I did a version with this fix anyway: https://github.com/R0tenur/visualization/releases/tag/v0.9.2
Further on I will probably generate some kind of warning when this occurs
When creating schema diagram I get the Mermaid error below![image](https://github.com/R0tenur/visualization/assets/38024566/1fc78f3b-0f7d-4be8-bee6-8fc13609ac8b)
When I enter DISMISS it says Syntax Error in Graph Mermaid version 9.4.3![image](https://github.com/R0tenur/visualization/assets/38024566/b9bd6934-9b41-4a2b-9ea4-980d0fa0aa48)
I see this has been reported before, but no one has provided a MD. I've attached the md generated in Schema Visualization Version 0.8.2 chart.md
Every student in my class is getting this error if they use v0.9.1
The database is internet accessable. If you like connection information, let me know and I can give you access to the database