MySQL DB

Table: Regions

Table: Contacts

Contacts have

• basic information (in this table)
• phones (other table)
• photos (other table)
• links (other table)

Contacts can only belong to 1 Region

Table: Contacts_Types

Table: Contacts_Types_contacts

this table links Contacts to Contact_Types

Table: Contacts_Phones

Where contact phones are saved

Contacts can have more than one Phone

Table: Contacts_Photos

Where contact photos are saved

Contacts can have more than one Photo

Table: Contacts_Photos_Contacts

this table links contacts to photos

Table: External_links

Contacts links are save here

Contacts can have more than one Link

Table: Link_providers

not sure if this table is being used, i think it was just a test