| Innehållsförteckning |
|---|
Tillgång till källkoden
Se Instruktioner för utvecklare.
Komponenter i tjänsteadresseringskatalogen
...
| 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
...