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