Hello to this wonderful collection of helpful people!
Playing with the fancy FM13 here.
I'm designing a solution for leasing land/buildings/units to clients.
I have a CONTRACTS Table that connects Lessee and the Property the are renting - using the One to Many (ie order details) model.
A lessee can lease one or more [Units] in [Building(s)] on a [Parcel] of land.
OR, they can lease an entire [Building] including any [Units]
OR, they can lease an entire [Parcel] including any [Buildings] or [Units]
The attributes of each of these items are fairly similar (square footage, address, etc.)
I'm having trouble with the property part of the equation.
#1 Should I think of any Unit/Building/Parcel an ASSET, which would be attributes of the same entities - one "Assets" table.
#2 Should I create 3 separate tables PARCEL, BUILDING, UNIT and make a (FK) to link them all.
Generally, I'm going to want to pull information into similar reports regardless of what they are renting, including multiple assets on the same contract.