-- begin TMSEXT_PUBLIC_KEY_SETTING
create unique index IDX_TMSEXT_PUBLIC_KEY_SETTING_UK_IDX on TMSEXT_PUBLIC_KEY_SETTING (IDX) ^
-- end TMSEXT_PUBLIC_KEY_SETTING
-- begin TMSEXT_ISSUER
alter table TMSEXT_ISSUER add constraint FK_TMSEXT_ISSUER_ON_ACQUIRER foreign key (ACQUIRER_ID) references TMSEXT_ACQUIRER(ID)^
create index IDX_TMSEXT_ISSUER_ON_ACQUIRER on TMSEXT_ISSUER (ACQUIRER_ID)^
-- end TMSEXT_ISSUER
-- begin TMSEXT_TERMINAL_EXT
create unique index IDX_TMSEXT_TERMINAL_EXT_UK_TERMINAL_ID on TMSEXT_TERMINAL_EXT (TERMINAL_ID) where DELETE_TS is null ^
-- end TMSEXT_TERMINAL_EXT
-- begin TMSEXT_ACQUIRER
alter table TMSEXT_ACQUIRER add constraint FK_TMSEXT_ACQUIRER_ON_TLE_SETTING foreign key (TLE_SETTING_ID) references TMSEXT_TLE_SETTING(ID)^
create index IDX_TMSEXT_ACQUIRER_ON_TLE_SETTING on TMSEXT_ACQUIRER (TLE_SETTING_ID)^
-- end TMSEXT_ACQUIRER
-- begin TMSEXT_TLE_SETTING
create unique index IDX_TMSEXT_TLE_SETTING_UK_TLE_EFT_SEC on TMSEXT_TLE_SETTING (TLE_EFT_SEC) where DELETE_TS is null ^
-- end TMSEXT_TLE_SETTING
-- begin TMSEXT_ISSUER_CARD_LINK
alter table TMSEXT_ISSUER_CARD_LINK add constraint FK_TMSISSCAR_ON_ISSUER foreign key (ISSUER_ID) references TMSEXT_ISSUER(ID)^
alter table TMSEXT_ISSUER_CARD_LINK add constraint FK_TMSISSCAR_ON_CARD foreign key (CARD_ID) references TMSEXT_CARD(ID)^
-- end TMSEXT_ISSUER_CARD_LINK
