| Table | Fields | Max Size | English translation |
| adresses | Id | int(11) | Number |
| adresses | OptSel | smallint(1) | Not used |
| adresses | Categorie | 50 | Categorie |
| adresses | Societe | 50 | Firm |
| adresses | Civilite | 50 | Civility |
| adresses | Nom | 50 | Last name |
| adresses | Prenom | 50 | First name |
| adresses | Fonction | 100 | Post |
| adresses | Rue | 200 | Street |
| adresses | Ville | 100 | Town |
| adresses | CP | 15 | Zip code |
| adresses | Pays | 50 | Country |
| adresses | Tel_Princ | 100 | Main phone |
| adresses | Tel_Gsm | 100 | Gsm phone |
| adresses | Tel_Standard | 100 | Switchboard |
| adresses | Tel_Fax | 100 | Fax |
| adresses | Tel_Autre1 | 100 | Free phone 1 |
| adresses | Tel_Autre2 | 100 | Free phone 2 |
| adresses | Tel_Autre3 | 100 | Free phone 3 |
| adresses | Tel_Autre4 | 100 | Free phone 4 |
| adresses | Email1 | 100 | |
| adresses | Email2 | 100 | |
| adresses | Email3 | 100 | |
| adresses | Email4 | 100 | |
| adresses | Url1 | 255 | |
| adresses | Url2 | 255 | |
| adresses | Pseudo1 | 100 | Free info 1 |
| adresses | Pseudo2 | 100 | Free info 2 |
| adresses | Pseudo3 | 100 | Free info 3 |
| adresses | Pseudo4 | 100 | Free info 4 |
| adresses | Notes | mediumtext | Comments |
| adresses | Creat | datetime | Update date |
| categories | Categorie | 50 | Categorie |
| civilites | Civilite | 50 | Civility |
| pays | Pays | 50 | Country |
| pays | Tel | 4 | International phone code |
| pays | ISO2 | 2 | Used for internet TLD |
| pays | ISO3 | 3 | Used for currency |
| pays | Devise | 50 | Currency |
| pays | GMT | 10 | GMT zone |
| pays | Capitale | 50 | Capital |