| Table d'origine | Champ d'origine | Table de destination | Champ de destination | Type du champ de destination | Taille du champ de destination | Index champ de destination | Extra | Null | Module | Objet métier | Attribut de l'Objet métier | SQL lors du select | Créé dans MySQL | Objet métier créé | Présent dans l'objet métier | 
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| user_options | user_id | INT | 11 | INDEX | Non | User | Options | id | Non | Non | Non | ||||
| users | lang | user_options | locale | VARCHAR | 10 | Non | User | Options | locale | Non | Non | Non | |||
| users | avatar | user_options | avatar_url | VARCHAR | 255 | Oui | User | Options | avatar | Non | Non | Non | |||
| users | sex | user_options | gender | ENUM | “male”,”female” | Oui | User | Options | gender | Non | Non | Non | |||
| users | dpath | user_options | design | VARCHAR | 20 | Non | User | Options | design | Non | Non | Non | |||
| user_options | skin | VARCHAR | 20 | Non | User | Options | skin | Non | Non | Non | |||||
| users | settings_tooltiptime | user_options | Non | User | Options | ||||||||||
| users | settings_fleetactions | user_options | Non | User | Options | ||||||||||
| users | settings_esp | user_options | probes_count | TINYINT | 3 | Non | User | Options | probes_count | Non | Non | Non | |||
| users | settings_wri | user_options | Non | User | Options | ||||||||||
| users | settings_bud | user_options | Non | User | Options | ||||||||||
| users | settings_mis | user_options | Non | User | Options | ||||||||||
| users | settings_rep | user_options | Non | User | Options | ||||||||||
| users | planet_sort | user_options | Non | User | Options | ||||||||||
| users | planet_sort_order | user_options | Non | User | Options | ||||||||||
| users | spio_anz | user_options | Non | User | Options | 
| Type | Champs | Nom | Extra | 
|---|---|---|---|
| INDEX | user_id | IDX_OPTIONS_USER_ID | 
| Moteur de stockage | Charset | Interclassement | 
|---|---|---|
| InnoDB | UTF-8 | utf8_general_ci |