I'm struggling to figure this out. I was able to a few years ago, but my knowledge has slagged.

I'm create a practice run web-app to look for web hosting.

Database model:

Host -> Plans

Host can have many plans
Plans can be of different types (shared, reseller, VPS etc.)
Hosts can have reviews (just URLs)

Hosts are easy.
Plans is where I'm drawing dead.

Do I just need to create a table for each type or do I just have an "attribute" table and have one of the "plan" fields be "attributes".

Thanks for any help,
I hope I get MyIQ back.

at this point, neither

nor this

each host will have separate plans, and to start out, you do not need the hassle of "pre-defining" a plan before you can add a host

just create the host_plans table using a 2-part PK, the hostid plus the plan name, and go ahead and use a VARCHAR for the plan name

The problem I have (or difficulty getting my head around) is that in the host_plans table I'll have to define things like: space allocated, bandwidth, RAM etc. And for shared for instance a RAM value wouldn't be specified but for a VPS it would. Do I just leave them empty and not display the values that are null when throwing it at the reseller_result template (for instance)?

Thanks for the help!

yes, that seems like the way to do it