Asterisk Realtime; Mysql; and Foreign Keys


#1

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.