...
- pubVersion
- updatedTime
- updatedBy
- deleted
Databas primay keys (PRIMARY), unique columns (UC_...), foreign keys (FK...) och index (..._idx)
Kodblock | ||
---|---|---|
| ||
mysql> SELECT INDEX_NAME, COLUMN_NAME, TABLE_NAME, NON_UNIQUE FROM INFORMATION_SCHEMA.STATISTICS WHERE TABLE_SCHEMA = "takver2";
+-------------------------------+---------------------+----------------------+------------+
| INDEX_NAME | COLUMN_NAME | TABLE_NAME | NON_UNIQUE |
+-------------------------------+---------------------+----------------------+------------+
| PRIMARY | id | anropsadress | 0 |
-------------------------------------------------------------------------------------------
| UC_TJANSTEKOMPONENT_ADRESS | tjanstekomponent_id | anropsadress | 0 |
| UC_TJANSTEKOMPONENT_ADRESS | rivTaProfil_id | anropsadress | 0 |
| UC_TJANSTEKOMPONENT_ADRESS | adress | anropsadress | 0 |
| UC_TJANSTEKOMPONENT_ADRESS | deleted | anropsadress | 0 |
-------------------------------------------------------------------------------------------
| FK9144C39E31F3452 | tjanstekomponent_id | anropsadress | 1 |
| FK9144C39E388AE8DD | rivTaProfil_id | anropsadress | 1 |
___________________________________________________________________________________________
| PRIMARY | id | anropsbehorighet | 0 |
-------------------------------------------------------------------------------------------
| UC_TJANSTEKONSUMENT | tjanstekonsument_id | anropsbehorighet | 0 |
| UC_TJANSTEKONSUMENT | tjanstekontrakt_id | anropsbehorighet | 0 |
| UC_TJANSTEKONSUMENT | logiskAdress_id | anropsbehorighet | 0 |
| UC_TJANSTEKONSUMENT | fromTidpunkt | anropsbehorighet | 0 |
| UC_TJANSTEKONSUMENT | tomTidpunkt | anropsbehorighet | 0 |
| UC_TJANSTEKONSUMENT | deleted | anropsbehorighet | 0 |
-------------------------------------------------------------------------------------------
| FK1144C39E31F3452 | tjanstekontrakt_id | anropsbehorighet | 1 |
| FK1144C39E388AE8DD | tjanstekonsument_id | anropsbehorighet | 1 |
| FK1144C39EA69F7BA2 | logiskAdress_id | anropsbehorighet | 1 |
-------------------------------------------------------------------------------------------
| anropsbehorighet_distinct_idx | fromTidpunkt | anropsbehorighet | 1 |
| anropsbehorighet_distinct_idx | integrationsavtal | anropsbehorighet | 1 |
| anropsbehorighet_distinct_idx | tomTidpunkt | anropsbehorighet | 1 |
| anropsbehorighet_distinct_idx | version | anropsbehorighet | 1 |
| anropsbehorighet_distinct_idx | logiskAdress_id | anropsbehorighet | 1 |
| anropsbehorighet_distinct_idx | tjanstekonsument_id | anropsbehorighet | 1 |
| anropsbehorighet_distinct_idx | tjanstekontrakt_id | anropsbehorighet | 1 |
| anropsbehorighet_distinct_idx | deleted | anropsbehorighet | 1 |
___________________________________________________________________________________________
| PRIMARY | id | anvandare | 0 |
___________________________________________________________________________________________
| PRIMARY | id | filter | 0 |
-------------------------------------------------------------------------------------------
| UC_SERVICEDOMAIN | anropsbehorighet_id | filter | 0 |
| UC_SERVICEDOMAIN | servicedomain | filter | 0 |
| UC_SERVICEDOMAIN | deleted | filter | 0 |
-------------------------------------------------------------------------------------------
| FK7D6DB798BC716E82 | anropsbehorighet_id | filter | 1 |
___________________________________________________________________________________________
| PRIMARY | id | filtercategorization | 0 |
-------------------------------------------------------------------------------------------
| UC_CATEGORY | filter_id | filtercategorization | 0 |
| UC_CATEGORY | category | filtercategorization | 0 |
| UC_CATEGORY | deleted | filtercategorization | 0 |
-------------------------------------------------------------------------------------------
| FK7EB5D6C12046FE42 | filter_id | filtercategorization | 1 |
___________________________________________________________________________________________
| PRIMARY | id | logiskadress | 0 |
| UC_HSAID | hsaId | logiskadress | 0 |
| UC_HSAID | deleted | logiskadress | 0 |
___________________________________________________________________________________________
| PRIMARY | id | pubversion | 0 |
___________________________________________________________________________________________
| PRIMARY | id | rivtaprofil | 0 |
-------------------------------------------------------------------------------------------
| UC_NAMN | namn | rivtaprofil | 0 |
| UC_NAMN | deleted | rivtaprofil | 0 |
___________________________________________________________________________________________
| PRIMARY | id | tjanstekomponent | 0 |
-------------------------------------------------------------------------------------------
| UC_HSAID | hsaId | tjanstekomponent | 0 |
| UC_HSAID | deleted | tjanstekomponent | 0 |
___________________________________________________________________________________________
| PRIMARY | id | tjanstekontrakt | 0 |
-------------------------------------------------------------------------------------------
| UC_NAMNRYMD | namnrymd | tjanstekontrakt | 0 |
| UC_NAMNRYMD | deleted | tjanstekontrakt | 0 |
___________________________________________________________________________________________
| PRIMARY | id | vagval | 0 |
-------------------------------------------------------------------------------------------
| UC_VAGVAL_ADRESS | anropsAdress_id | vagval | 0 |
| UC_VAGVAL_ADRESS | tjanstekontrakt_id | vagval | 0 |
| UC_VAGVAL_ADRESS | logiskAdress_id | vagval | 0 |
| UC_VAGVAL_ADRESS | fromTidpunkt | vagval | 0 |
| UC_VAGVAL_ADRESS | tomTidpunkt | vagval | 0 |
| UC_VAGVAL_ADRESS | deleted | vagval | 0 |
-------------------------------------------------------------------------------------------
| FK2C881BB350F9DB81 | anropsAdress_id | vagval | 1 |
| FK2C881BB3E6234A82 | tjanstekontrakt_id | vagval | 1 |
| FK2C881BB331F3452 | logiskAdress_id | vagval | 1 |
-------------------------------------------------------------------------------------------
___________________________________________________________________________________________
+-------------------------------+---------------------+----------------------+------------+
59 rows in set (0.04 sec) |
Utredning och implementations detaljer
...