Structure Question: Property Management
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.
#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.
Any help would be appreciated!