I've read this. But I'm not sure if I understood correctly or my situation is slightly different.
So, Here is my situation: I've a single table with customer's delivery addresses and there are two types of delivery addresses - main delivery address (every column is required) & alternative delivery address(optional).
id(PK) city_id(FK) area_id(FK) recipient_name(NULL) street_address(NULL) contact_no(NULL)
id(PK) delivery_info_id(FK) alt_delivery_info_id(FK) status ...
The city (
city_id) and area (
area_id) of both addresses will always be available and must be same that means the alternative delivery address must be in the same city and same area of main delivery address. But other 3 columns -
contact_no is required for main delivery address but optional for alternative delivery address.
So my question is should i separate these two types of delivery addresses in two different tables e.g.
delivery_info and a
alt_delivery_info OR Keep it as it is???