I'm developing a small property management application,
to record rent payments made on leases (associated to a property)
Im just a bit uncertain on my table design as to whether it's the right way to do things and was hoping to get some feedback.
This is what I have at the moment..
lease_party_id (fk) <----- Should this be just Person_id??
lease_party_id (fk) <---- Should this be just Person_id? or is this good..
Lease_Party (stores Lease - Tenant/Landlord association)
person_id (fk) ~ tenant or landlord
type_id (fk) ~ reference a type table to state whether tenant or landlord
Person (stores Tenant/Landlord details)
Any advice / guidance appreciated!