I am currently desiging a billing system and i am rather concerned about data-redundancy with some of the tables.
I would like to ensure that there is no redundancy in my tables, and would like to setup proper relationships and attributes between tables.
Will asterisk pickup on relationships defines.
for example…
Can I have tables like this:
Sip_users:
ID
DDI_Number_fk
DDI_Numbers:
ID
DDI_Number
Will asterisk pickup the relationships, or do i have to design my tables breaking SQL Normalisation practices.