[DiscordArchive] do you also plan to include database tables ?
[DiscordArchive] do you also plan to include database tables ?
Original source
do you also plan to include database tables ?
rektbyfaith
06-29-2023, 10:03 PM #1Archived author: Titi • Posted: 2023-06-29T22:03:55.978000+00:00
Original source
do you also plan to include database tables ?
Original source
SkillLineCategory is missing ?
rektbyfaith
06-29-2023, 10:05 PM #2Archived author: Titi • Posted: 2023-06-29T22:05:07.851000+00:00
Original source
SkillLineCategory is missing ?
Original source
Just as an FYI since I ran into this back in the day when I created a dbc -> sql converter: There are all kinds of inconsistencies inside the foreign keys in terms of sentinel values. Sometimes they use 0, other times they use -1. Then they use both, neither or they reference records that just do not exist.
If you're just interested in the relationships then this is fine. If you're interested in creating the tables and filling them with data AND you're trying to use proper constraints, then this will be a fair bit of tedious labor.
rektbyfaith
06-29-2023, 10:06 PM #3Archived author: Ike • Posted: 2023-06-29T22:06:13.732000+00:00
Original source
Just as an FYI since I ran into this back in the day when I created a dbc -> sql converter: There are all kinds of inconsistencies inside the foreign keys in terms of sentinel values. Sometimes they use 0, other times they use -1. Then they use both, neither or they reference records that just do not exist.
If you're just interested in the relationships then this is fine. If you're interested in creating the tables and filling them with data AND you're trying to use proper constraints, then this will be a fair bit of tedious labor.
Original source
It's only an hours work, a lot to do still.
rektbyfaith
06-29-2023, 10:06 PM #4Archived author: stoneharry • Posted: 2023-06-29T22:06:45.903000+00:00
Original source
It's only an hours work, a lot to do still.
Original source
Yes that's correct, this can't be used actually for storing data with formal keys -- it's too inconsistent for that. I'm only interested in having a diagram to map the relationships, for reference when programming or editing data
rektbyfaith
06-29-2023, 10:07 PM #5Archived author: stoneharry • Posted: 2023-06-29T22:07:21.773000+00:00
Original source
Yes that's correct, this can't be used actually for storing data with formal keys -- it's too inconsistent for that. I'm only interested in having a diagram to map the relationships, for reference when programming or editing data
Original source
definitely ran into this developping DBC tooling for noggit red, had to add a lot of null checks
rektbyfaith
06-29-2023, 10:07 PM #6Archived author: Titi • Posted: 2023-06-29T22:07:39.067000+00:00
Original source
definitely ran into this developping DBC tooling for noggit red, had to add a lot of null checks
Original source
non existing entries references are very common. they seem to have been cleansed later though because in classic/retail data those are now 0
rektbyfaith
06-29-2023, 10:08 PM #7Archived author: Titi • Posted: 2023-06-29T22:08:23.063000+00:00
Original source
non existing entries references are very common. they seem to have been cleansed later though because in classic/retail data those are now 0
Original source
I was always curious about that, since it implies that they manually fiddled with the records instead of using proper tooling. At least at some point
rektbyfaith
06-29-2023, 10:10 PM #8Archived author: Ike • Posted: 2023-06-29T22:10:23.139000+00:00
Original source
I was always curious about that, since it implies that they manually fiddled with the records instead of using proper tooling. At least at some point
Original source
no, they probably just removed those entries, or they didn't get shipped to production
rektbyfaith
06-29-2023, 10:10 PM #9Archived author: Titi • Posted: 2023-06-29T22:10:47.996000+00:00
Original source
no, they probably just removed those entries, or they didn't get shipped to production
Original source
I mean the inconsitent sentinel values
rektbyfaith
06-29-2023, 10:11 PM #10Archived author: Ike • Posted: 2023-06-29T22:11:03.026000+00:00
Original source
I mean the inconsitent sentinel values
1 Guest(s)
1 Guest(s)