• 0 Posts
  • 217 Comments
Joined 2 years ago
cake
Cake day: June 22nd, 2023

help-circle








  • Heya, long time dev here.

    If you’re not expecting millions of rows, you could just use the country code directly in the user table and not use a foreign key/table at all. Just an idea.

    However, if you want the country table, i would find this list in a csv format (or copy paste into goog sheets or such and massage it) and then use a tool or write a quick script to ingest it into the db. If you’re doing that you should design the country table to have id, code, name. It can be used for populating dropdowns or autocomplete or such too.

    Over-engineering is a thing; keep it simple. If you’re doing this mainly as an exercise to learn, over-engineering can be ok - just understand that it doesn’t HAVE to be done any particular way, and there is no “right” way. Design is subjective and varies based on the needs of your software.







  • Yes. There’s a chance you have to deal with collections after a while. Most the time the debt just gets written off tho.

    If it does end up in collections, you can pay it for a bargain discount (and it’s removed from credit report). Or just wait it out and let it drop off in 7 years.

    If you’re needing a loan sometime in the next 7 years, it’s a risk. But there’s certainly no criminal consequences, and they’re not coming after your wages over it.

    If you aren’t from the USA, most of that doesn’t apply. They’re not coming after you in another country over medical debt, and they won’t prevent travel into or out of the country. It’s simply not a big deal here.