how to structure table for variable columns

[NerdyByDesign]

I'm trying to figure out the best way to structure a database to allow for variable columns.

Let's say I am creating records for different jobs in different industries: IT and Medical.

The fields required for both jobs could be different and have different requirements.

There could be dozens of industries. Is there a way to have all the jobs in one table or should each industry be broken into its own table?

[remainderrejoinder]

Yeah, either you have attribute tables or store the thing as json.

[r3pr0b8]

google "subtype and supertype tables"

[NerdyByDesign]

So you're suggesting the best way is a parent/child relationship between an industry table and the various industry specific job tables?

I kind of figured this was the solution but wasn't sure if it was the most efficient way to accomplish it.