8000 Case #003 - person_id inconsistent · Issue #17 · hristo2612/SQLNoir · GitHub
[go: up one dir, main page]
More Web Proxy on the site http://driver.im/
Skip to content

Case #003 - person_id inconsistent #17

New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom
Open
koebi opened this issue Feb 17, 2025 · 1 comment
Open

Case #003 - person_id inconsistent #17

koebi opened this issue Feb 17, 2025 · 1 comment

Comments

@koebi
Copy link
koebi commented Feb 17, 2025

In case #3, hotel_checkins has an entry:
id person_id hotel_name check_in_date
2 27 Sunset Bay Hotel 19860813

and surveillance_records has an entry:
id person_id hotel_checkin_id suspicious_activity
8 8 2 Left suddenly at 3 AM

and according to the schema, the hotel_checkins.id is the one used in surveillance_records.hotel_checkin_id.
These two records have the same entry there, but different person_id.

This is rather confusing.
Kelley12 added a commit to Kelley12/SQLNoir that referenced this issue Feb 17, 2025
@Kelley12
Remove unused hotel_checkin_id
d547478 
The person_id and hotel_checkin_id are inconsistent and cause major confusion.

hristo2612#17
@Kelley12 Kelley12 mentioned this issue Feb 17, 2025
Closed
@hristo2612
Copy link
Owner

Hey @koebi, will look into it.

@krimha krimha mentioned this issue Feb 20, 2025
Open
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
2 participants
@koebi @hristo2612
2A4F
0