sork
167
2
General

design database tables for real estate contracts

Posted 2 years ago by sork

I am creating an app to manage real estate sale and rent contracts. i do have three tables as below:

contracts : contain columns that are available in both rent and sale contracts such as: client name, landlord name, location ...etc.

rent_contracts: contain columns that are specific only for rent contracts such as: rent start date , end date ..etc.

sale_contracts: contain columns that are specific only for sale contracts.

i would like to ask

  • having three tables like above is a good approach?
  • is there any other table design idea for such a system?

Please sign in or create an account to participate in this conversation.