create domain dmn_tescilno varchar(16) check ( value ~ '^[0-9]{8}((IM)|(EX)|(AN)|(TR)|(DG)|(T0)|(C0)|(B0)|(G0)|(M0)|(R0)|(RL))[0-9]{6}$'); select '22222222AN111111'::dmn_tescilno;  

Sqlite Türkiye il ilce mahalle sokak veritabani devşirmedir asıl kaynak: https://github.com/emreuenal/turkiye-il-ilce-sokak-mahalle-veri-tabani/tree/master/dumps/dumps_5Nisan2021 indirmek için: https://disk.yandex.com.tr/d/q3JaRHLe7mWGyQ

SELECT s.username tutan_kullanici, s.sid tutan_session, t.username bekleyen_kullanici, t.sid bekleyen_session, l.type locktype, l.dbsname veritabani, l.tabname tablo, l.rowidlk tutulan_rowid FROM sysmaster:syslocks l INNER JOIN sysmaster:syssessions s ON s.sid = l.owner LEFT JOIN sysmaster:syssessions t ON l.waiter = t.sid WHERE l.dbsname <> 'sysmaster' and l.tabname <> 'sysdatabases' ORDER BY veritabani, l.tabname;  

devşirmedir asıl kaynak: https://github.com/emreuenal/turkiye-il-ilce-sokak-mahalle-veri-tabani/tree/master/dumps/dumps_5Nisan2021 indirmek için: https://disk.yandex.com.tr/d/qfmuyISRKxuoGQ