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 |