Konsole
Die aktuelle Markierung enthält keine eindeutige („unique“) Spalte. Gitter-Bearbeitungsfunktion, Kontrollkästchen, Bearbeiten, Kopieren und Löschen von Links sind nicht verfügbar.
Zeige Datensätze 0 - ... Dieser Ansicht hat mindestens diese Anzahl von Datensätzen. Bitte lesen Sie die Dokumentation. (Die Abfrage dauerte 0,1394 Sekunden.) [ORDINAL_POSITION: 6... - 4...]
SELECT * FROM `KEY_COLUMN_USAGE` ORDER BY `ORDINAL_POSITION` DESC
| Zeilen filtern: |
| CONSTRAINT_CATALOG | CONSTRAINT_SCHEMA | CONSTRAINT_NAME | TABLE_CATALOG | TABLE_SCHEMA | TABLE_NAME | COLUMN_NAME |
ORDINAL_POSITION 1
|
POSITION_IN_UNIQUE_CONSTRAINT | REFERENCED_TABLE_SCHEMA | REFERENCED_TABLE_NAME | REFERENCED_COLUMN_NAME | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| def | dolibarr23 | uk_c_hrm_public_holiday2 | def | dolibarr23 | dbv_c_hrm_public_holiday | year | 6 | NULL | NULL | NULL | NULL | |
| def | dolibarr23 | uk_default_values | def | dolibarr23 | dbv_default_values | param | 5 | NULL | NULL | NULL | NULL | |
| def | phpmyadmin | PRIMARY | def | phpmyadmin | pma__navigationhiding | table_name | 5 | NULL | NULL | NULL | NULL | |
| def | mysql | PRIMARY | def | mysql | columns_priv | Column_name | 5 | NULL | NULL | NULL | NULL | |
| def | dolibarr23 | uk_c_hrm_public_holiday2 | def | dolibarr23 | dbv_c_hrm_public_holiday | month | 5 | NULL | NULL | NULL | NULL | |
| def | dolibarr23 | uk_societe_account_key_account_soc | def | dolibarr23 | dbv_societe_account | fk_website | 5 | NULL | NULL | NULL | NULL | |
| def | dolibarr23 | uk_actioncomm_reminder_unique | def | dolibarr23 | dbv_actioncomm_reminder | offsetunit | 5 | NULL | NULL | NULL | NULL | |
| def | dolibarr23 | uk_c_tva_id | def | dolibarr23 | dbv_c_tva | recuperableonly | 5 | NULL | NULL | NULL | NULL | |
| def | mysql | PRIMARY | def | mysql | procs_priv | Routine_type | 5 | NULL | NULL | NULL | NULL | |
| def | mysql | PRIMARY | def | mysql | index_stats | prefix_arity | 4 | NULL | NULL | NULL | NULL | |
| def | dolibarr23 | uk_object_lang | def | dolibarr23 | dbv_object_lang | lang | 4 | NULL | NULL | NULL | NULL | |
| def | dolibarr23 | idx_societe_contacts_idx1 | def | dolibarr23 | dbv_societe_contacts | fk_socpeople | 4 | NULL | NULL | NULL | NULL | |
| def | dolibarr23 | uk_product_fournisseur_price_ref | def | dolibarr23 | dbv_product_fournisseur_price | entity | 4 | NULL | NULL | NULL | NULL | |
| def | phpmyadmin | PRIMARY | def | phpmyadmin | pma__navigationhiding | db_name | 4 | NULL | NULL | NULL | NULL | |
| def | dolibarr23 | idx_element_element_idx1 | def | dolibarr23 | dbv_element_element | targettype | 4 | NULL | NULL | NULL | NULL | |
| def | mysql | PRIMARY | def | mysql | columns_priv | Table_name | 4 | NULL | NULL | NULL | NULL | |
| def | dolibarr23 | uk_c_hrm_public_holiday2 | def | dolibarr23 | dbv_c_hrm_public_holiday | day | 4 | NULL | NULL | NULL | NULL | |
| def | mysql | PRIMARY | def | mysql | tables_priv | Table_name | 4 | NULL | NULL | NULL | NULL | |
| def | mysql | PRIMARY | def | mysql | proxies_priv | Proxied_user | 4 | NULL | NULL | NULL | NULL | |
| def | dolibarr23 | uk_societe_account_key_account_soc | def | dolibarr23 | dbv_societe_account | site | 4 | NULL | NULL | NULL | NULL | |
| def | mysql | PRIMARY | def | mysql | innodb_index_stats | stat_name | 4 | NULL | NULL | NULL | NULL | |
| def | dolibarr23 | uk_actioncomm_reminder_unique | def | dolibarr23 | dbv_actioncomm_reminder | offsetvalue | 4 | NULL | NULL | NULL | NULL | |
| def | dolibarr23 | uk_boxes | def | dolibarr23 | dbv_boxes | fk_user | 4 | NULL | NULL | NULL | NULL | |
| def | dolibarr23 | uk_c_tva_id | def | dolibarr23 | dbv_c_tva | taux | 4 | NULL | NULL | NULL | NULL | |
| def | dolibarr23 | idx_element_resources_idx1 | def | dolibarr23 | dbv_element_resources | element_type | 4 | NULL | NULL | NULL | NULL |
| Zeilen filtern: |