====== Table user_technologies ====== ===== Table ===== ^ 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_technologies**|user_id| INT | 11 ^ INDEX | | Non | Empire | Technologies | id | | Non | Non | Non | |users|spy_tech^**user_technologies**|spying| TINYINT | 3 | | | Non | Empire | Technologies | spying | | Non | Non | Non | |users|computer_tech^**user_technologies**|computer| TINYINT | 3 | | | Non | Empire | Technologies | computer | | Non | Non | Non | |users|military_tech^**user_technologies**| | TINYINT | 3 | | | Non | Empire | Technologies | | | Non | Non | Non | |users|defence_tech^**user_technologies**| | TINYINT | 3 | | | Non | Empire | Technologies | | | Non | Non | Non | |users|shield_tech^**user_technologies**|shield| TINYINT | 3 | | | Non | Empire | Technologies | shield | | Non | Non | Non | |users|energy_tech^**user_technologies**|energy| TINYINT | 3 | | | Non | Empire | Technologies | energy | | Non | Non | Non | |users|hyperspace_tech^**user_technologies**|hyperspace| TINYINT | 3 | | | Non | Empire | Technologies | hyperspace | | Non | Non | Non | |users|combustion_tech^**user_technologies**|combustion_engine| TINYINT | 3 | | | Non | Empire | Technologies | combustion_engine | | Non | Non | Non | |users|impulse_motor_tech^**user_technologies**|impulse_engine| TINYINT | 3 | | | Non | Empire | Technologies | impulse_engine | | Non | Non | Non | |users|hyperspace_motor_tech^**user_technologies**|hyperspace_engine| TINYINT | 3 | | | Non | Empire | Technologies | hyperspace_engine | | Non | Non | Non | |users|laser_tech^**user_technologies**|laser| TINYINT | 3 | | | Non | Empire | Technologies | laser | | Non | Non | Non | |users|ionic_tech^**user_technologies**|ionic| TINYINT | 3 | | | Non | Empire | Technologies | ionic | | Non | Non | Non | |users|buster_tech^**user_technologies**| | TINYINT | 3 | | | Non | Empire | Technologies | | | Non | Non | Non | |users|intergalactic_tech^**user_technologies**|intergalactic_network| TINYINT | 3 | | | Non | Empire | Technologies | intergalactic_network | | Non | Non | Non | |users|expedition_tech^**user_technologies**|expedition| TINYINT | 3 | | | Non | Empire | Technologies | expedition | | Non | Non | Non | |users|graviton_tech^**user_technologies**|graviton| TINYINT | 3 | | | Non | Empire | Technologies | graviton | | Non | Non | Non | | | ^**user_entity**|created_at| DATETIME | | | | Non | Empire | Technologies | created_at | | Non | Non | Non | | | ^**user_entity**|updated_at| DATETIME | | | | Non | Empire | Technologies | updated_at | | Non | Non | Non | ===== Triggers ===== ^ Evènement ^ Champ ^ Valeur ^ | CREATE | created_at | NOW() | | CREATE | updated_at | NOW() | ^ ^ ^ ^ | UPDATE | updated_at | NOW() | ===== Indexes ===== ^ Type ^ Champs ^ Nom ^ Extra ^ | INDEX | user_id | IDX_OPTIONS_USER | AUTO_INCREMENT | ===== Extra ===== ^ Moteur de stockage ^ Charset ^ Interclassement ^ | InnoDB | UTF-8 | utf8_general_ci |