{"id":29621,"date":"2025-09-17T05:32:38","date_gmt":"2025-09-17T02:32:38","guid":{"rendered":"https:\/\/fatihsoysal.com\/blog\/sql-server-ledger-tablolari-bankacilik-ornegiyle-tam-kilavuz\/"},"modified":"2025-09-17T05:32:38","modified_gmt":"2025-09-17T02:32:38","slug":"sql-server-ledger-tablolari-bankacilik-ornegiyle-tam-kilavuz","status":"publish","type":"post","link":"https:\/\/fatihsoysal.com\/blog\/sql-server-ledger-tablolari-bankacilik-ornegiyle-tam-kilavuz\/","title":{"rendered":"SQL Server Ledger Tablolar\u0131: Bankac\u0131l\u0131k \u00d6rne\u011fiyle Tam K\u0131lavuz"},"content":{"rendered":"<p>SQL Server Ledger Tablolar\u0131: Bankac\u0131l\u0131k \u00d6rne\u011fiyle Tam K\u0131lavuz<\/p>\n<p>G\u00fcn\u00fcm\u00fcz\u00fcn karma\u015f\u0131k finansal d\u00fcnyas\u0131nda, g\u00fcvenilir ve verimli bir muhasebe sistemi hayati \u00f6nem ta\u015f\u0131maktad\u0131r.  SQL Server&#8217;\u0131n sundu\u011fu g\u00fc\u00e7l\u00fc veri y\u00f6netim yetenekleri, bu ihtiyac\u0131 kar\u015f\u0131lamak i\u00e7in ideal bir \u00e7\u00f6z\u00fcm sunmaktad\u0131r. Bu makalede, SQL Server&#8217;da ledger (muhasebe defteri) tablolar\u0131n\u0131n nas\u0131l tasarlanaca\u011f\u0131n\u0131, uygulanaca\u011f\u0131n\u0131 ve optimize edilece\u011fini, ger\u00e7ek d\u00fcnya senaryolar\u0131yla birlikte ad\u0131m ad\u0131m inceleyece\u011fiz.  Bankac\u0131l\u0131k sekt\u00f6r\u00fcnden \u00f6rnekler kullanarak, SQL Server ile g\u00fc\u00e7l\u00fc ve g\u00fcvenilir bir muhasebe sisteminin nas\u0131l kurulabilece\u011fini g\u00f6rece\u011fiz.  \u0130ster yeni ba\u015flayan ister deneyimli bir SQL geli\u015ftiricisi olun, bu k\u0131lavuz size SQL Server ledger tablolar\u0131 konusunda kapsaml\u0131 bir anlay\u0131\u015f kazand\u0131racakt\u0131r.<\/p>\n<h2>SQL Server Ledger Tablolar\u0131: Temel Kavramlar<\/h2>\n<p>Ledger tablolar\u0131, finansal i\u015flemleri kronolojik olarak kaydeden ve i\u015fletmenin finansal durumunu izlemek i\u00e7in kullan\u0131lan \u00f6zel veritaban\u0131 tablolar\u0131d\u0131r.  Standart bir SQL tablosu gibi g\u00f6r\u00fcnseler de,  muhasebe ilkelerine uygun \u015fekilde tasarlanmalar\u0131 ve y\u00f6netilmeleri kritik \u00f6neme sahiptir.  Her i\u015flem, belirli bir tarih ve saatle birlikte kaydedilmelidir ve tablo genellikle debet ve kredi s\u00fctunlar\u0131na sahiptir. Bu s\u00fctunlar, i\u015flemin hangi hesaplar\u0131 etkiledi\u011fini ve miktar\u0131n\u0131 g\u00f6sterir.  Veri b\u00fct\u00fcnl\u00fc\u011f\u00fcn\u00fc sa\u011flamak i\u00e7in, her debet giri\u015finin kar\u015f\u0131l\u0131\u011f\u0131 bir kredi giri\u015fi olmal\u0131d\u0131r (\u00e7ift kay\u0131t sistemi).  Bu, tutarl\u0131 bir muhasebe kayd\u0131 sa\u011flar ve hatalar\u0131 azalt\u0131r.  \u00d6rne\u011fin, bir para yat\u0131rma i\u015flemi, m\u00fc\u015fterinin hesab\u0131n\u0131 art\u0131ran (debet) ve bankan\u0131n hesab\u0131n\u0131 art\u0131ran (kredi) iki kay\u0131ttan olu\u015facakt\u0131r.  Bunun yan\u0131 s\u0131ra, i\u015flemin a\u00e7\u0131klamas\u0131n\u0131, i\u015flem t\u00fcr\u00fcn\u00fc ve ilgili hesap numaralar\u0131n\u0131 i\u00e7eren di\u011fer s\u00fctunlar da gereklidir.  Do\u011fru bir ledger tablosu tasar\u0131m\u0131,  performans\u0131, veri b\u00fct\u00fcnl\u00fc\u011f\u00fcn\u00fc ve izlenebilirli\u011fi \u00f6nemli \u00f6l\u00e7\u00fcde etkiler.  Verimli bir tasar\u0131m, indeksleme ve veri tiplerinin do\u011fru se\u00e7imi ile elde edilir.  Hatal\u0131 bir tasar\u0131m ise performans sorunlar\u0131na ve veri tutars\u0131zl\u0131klar\u0131na yol a\u00e7abilir.<\/p>\n<h2>Ledger Tablosu Tasar\u0131m\u0131: Ad\u0131m Ad\u0131m K\u0131lavuz<\/h2>\n<p>\u015eimdi, bir bankac\u0131l\u0131k sistemi i\u00e7in tipik bir ledger tablosunun tasar\u0131m\u0131n\u0131 ad\u0131m ad\u0131m inceleyelim.  Bu \u00f6rnek, ger\u00e7ek d\u00fcnyadaki senaryolar\u0131 yans\u0131tarak, kavramlar\u0131 daha iyi anlaman\u0131za yard\u0131mc\u0131 olacakt\u0131r. \u0130lk olarak, temel s\u00fctunlar\u0131 belirleyelim:<\/p>\n<ul>\n<li><code>TransactionID<\/code> (INT, PRIMARY KEY): Her i\u015flemin benzersiz kimli\u011fini belirtir.<\/li>\n<li><code>TransactionDate<\/code> (DATETIME): \u0130\u015flemin ger\u00e7ekle\u015fti\u011fi tarih ve saati kaydeder.<\/li>\n<li><code>AccountID<\/code> (INT, FOREIGN KEY): \u0130\u015flemin ger\u00e7ekle\u015fti\u011fi hesab\u0131n kimli\u011fini belirtir.<\/li>\n<li><code>DebitAmount<\/code> (DECIMAL(18,2)): \u0130\u015flemin debet taraf\u0131ndaki miktar\u0131n\u0131 kaydeder.<\/li>\n<li><code>CreditAmount<\/code> (DECIMAL(18,2)): \u0130\u015flemin kredi taraf\u0131ndaki miktar\u0131n\u0131 kaydeder.<\/li>\n<li><code>TransactionType<\/code> (VARCHAR(50)): \u0130\u015flemin t\u00fcr\u00fcn\u00fc (\u00f6rne\u011fin, para yat\u0131rma, para \u00e7ekme, havale) belirtir.<\/li>\n<li><code>Description<\/code> (VARCHAR(255)): \u0130\u015flemin a\u00e7\u0131klamas\u0131n\u0131 i\u00e7erir.<\/li>\n<\/ul>\n<p>Bu temel s\u00fctunlar\u0131 kullanarak, a\u015fa\u011f\u0131daki gibi bir SQL Server tablosu olu\u015fturabiliriz:<\/p>\n<pre><code class=\"language-sql\">CREATE TABLE Ledger (\n    TransactionID INT PRIMARY KEY IDENTITY(1,1),\n    TransactionDate DATETIME NOT NULL,\n    AccountID INT NOT NULL,\n    DebitAmount DECIMAL(18,2) NOT NULL DEFAULT 0.00,\n    CreditAmount DECIMAL(18,2) NOT NULL DEFAULT 0.00,\n    TransactionType VARCHAR(50) NOT NULL,\n    Description VARCHAR(255)\n);<\/pre>\n<p><\/code><\/p>\n<p>Bu tablo,  bankac\u0131l\u0131k i\u015flemlerini kaydetmek i\u00e7in yeterli bir temel olu\u015fturur. Ancak daha geli\u015fmi\u015f senaryolar i\u00e7in ek s\u00fctunlar eklemek gerekebilir. \u00d6rne\u011fin,  i\u015flemin yap\u0131ld\u0131\u011f\u0131 \u015fube, m\u00fc\u015fteri kimli\u011fi veya ilgili hesap numaras\u0131 gibi bilgiler eklenebilir.  Ayr\u0131ca, performans\u0131 art\u0131rmak i\u00e7in uygun indeksler eklemek \u00f6nemlidir.  \u00d6rne\u011fin, <code>TransactionDate<\/code>, <code>AccountID<\/code> ve <code>TransactionType<\/code> s\u00fctunlar\u0131na indeks eklemek, veri aramalar\u0131n\u0131 h\u0131zland\u0131rabilir.  Daha fazla bilgi i\u00e7in (https:\/\/fatihsoysal.com) inceleyebilirsiniz.<\/p>\n<h2>SQL Server Ledger Tablolar\u0131na Veri Ekleme ve Sorgulama<\/h2>\n<p>Ledger tablosuna veri eklemek i\u00e7in,  <code>INSERT INTO<\/code> komutunu kullanabiliriz.  \u00d6rne\u011fin, a\u015fa\u011f\u0131daki komut,  yeni bir para yat\u0131rma i\u015flemi ekler:<\/p>\n<pre><code class=\"language-sql\">INSERT INTO Ledger (TransactionDate, AccountID, DebitAmount, CreditAmount, TransactionType, Description)\nVALUES (&#039;2024-03-08 10:00:00&#039;, 12345, 0.00, 1000.00, &#039;Para Yat\u0131rma&#039;, &#039;M\u00fc\u015fteri taraf\u0131ndan para yat\u0131r\u0131ld\u0131.&#039;);<\/pre>\n<p><\/code><\/p>\n<p>Mevcut verileri sorgulamak i\u00e7in ise,  <code>SELECT<\/code> komutunu kullanabiliriz.  \u00d6rne\u011fin,  belirli bir tarih aral\u0131\u011f\u0131ndaki t\u00fcm i\u015flemleri sorgulamak i\u00e7in a\u015fa\u011f\u0131daki komutu kullanabiliriz:<\/p>\n<pre><code class=\"language-sql\">SELECT *\nFROM Ledger\nWHERE TransactionDate BETWEEN &#039;2024-03-01&#039; AND &#039;2024-03-31&#039;;<\/pre>\n<p><\/code><\/p>\n<p>Daha karma\u015f\u0131k sorgulamalar i\u00e7in,  <code>JOIN<\/code> komutunu kullanarak ledger tablosunu di\u011fer tablolarla birle\u015ftirebiliriz.  \u00d6rne\u011fin,  hesap bilgilerini g\u00f6r\u00fcnt\u00fclemek i\u00e7in,  <code>Accounts<\/code> tablosunu ledger tablosuna birle\u015ftirebiliriz. Bu, her bir i\u015flemin hangi hesaba ait oldu\u011funu kolayca g\u00f6rmemizi sa\u011flar.  Toplam debet ve kredi tutarlar\u0131n\u0131 hesaplamak i\u00e7in ise,  <code>SUM()<\/code> fonksiyonunu kullanabiliriz.  Bu fonksiyon,  belirli bir s\u00fct\u00fcndaki de\u011ferlerin toplam\u0131n\u0131 hesaplamak i\u00e7in kullan\u0131l\u0131r.  Bu teknikler,  ledger tablosundaki verileri analiz etmek ve rapor olu\u015fturmak i\u00e7in \u00e7ok faydal\u0131d\u0131r.<\/p>\n<h2>Performans Optimizasyonu ve \u0130leri D\u00fczey Teknikler<\/h2>\n<p>B\u00fcy\u00fck hacimli verilerle \u00e7al\u0131\u015f\u0131rken, ledger tablosunun performans\u0131n\u0131 optimize etmek kritik \u00f6nem ta\u015f\u0131r.  Bunu sa\u011flamak i\u00e7in a\u015fa\u011f\u0131daki teknikleri kullanabiliriz:<\/p>\n<ul>\n<li><strong>Uygun \u0130ndeksler:<\/strong>  S\u0131k\u00e7a sorgulama yap\u0131lan s\u00fctunlara indeks eklemek,  sorgulama s\u00fcrelerini \u00f6nemli \u00f6l\u00e7\u00fcde azaltabilir.  \u00d6rne\u011fin, <code>TransactionDate<\/code> ve <code>AccountID<\/code> s\u00fctunlar\u0131na indeks eklemek faydal\u0131 olabilir.<\/li>\n<li><strong>Par\u00e7al\u0131 Tablolar (Partitioning):<\/strong> B\u00fcy\u00fck ledger tablolar\u0131n\u0131 daha k\u00fc\u00e7\u00fck par\u00e7alara b\u00f6lmek,  sorgulama performans\u0131n\u0131 art\u0131rabilir.  Bu,  verileri daha verimli bir \u015fekilde y\u00f6netmemizi sa\u011flar.<\/li>\n<li><strong>Veri Tipleri:<\/strong>  Veri tiplerini do\u011fru se\u00e7mek \u00f6nemlidir.  Gereksiz yere b\u00fcy\u00fck veri tipleri kullanmaktan ka\u00e7\u0131nmak,  depolama alan\u0131n\u0131 ve i\u015flem h\u0131z\u0131n\u0131 etkiler.<\/li>\n<li><strong>\u00d6nbellekleme:<\/strong>  S\u0131k\u00e7a eri\u015filen verileri \u00f6nbelle\u011fe almak,  performans\u0131 art\u0131rabilir.  SQL Server'\u0131n \u00f6nbellekleme mekanizmalar\u0131ndan yararlanmak \u00f6nemlidir.<\/li>\n<\/ul>\n<p>Bunlar\u0131n yan\u0131 s\u0131ra,  denormalizasyon gibi ileri d\u00fczey teknikleri de kullanabiliriz.  Ancak,  denormalizasyonun veri tutarl\u0131l\u0131\u011f\u0131 \u00fczerindeki etkisini dikkatlice de\u011ferlendirmek gerekir.  Veri b\u00fct\u00fcnl\u00fc\u011f\u00fcn\u00fc koruyarak performans\u0131 optimize etmek i\u00e7in do\u011fru bir denge bulmak \u00f6nemlidir.  Ayr\u0131ca,  SQL Server'\u0131n sundu\u011fu performans izleme ara\u00e7lar\u0131n\u0131 kullanarak,  ledger tablosunun performans\u0131n\u0131 izleyebilir ve gerekli optimizasyonlar\u0131 yapabiliriz.<\/p>\n<h2>Ger\u00e7ek D\u00fcnya Senaryosu: Bankac\u0131l\u0131k Sistemi<\/h2>\n<p>Bir bankac\u0131l\u0131k sistemi i\u00e7in bir ledger tablosu tasar\u0131m\u0131,  yukar\u0131daki \u00f6rnekten daha karma\u015f\u0131k olabilir.  \u00d6rne\u011fin,  farkl\u0131 hesap t\u00fcrleri (cari hesap, mevduat hesab\u0131),  farkl\u0131 para birimleri ve  i\u015flem \u00fccretleri gibi fakt\u00f6rleri dikkate almak gerekebilir.  Bu durumda,  ledger tablosuna ek s\u00fctunlar eklemek veya ili\u015fkili tablolar kullanmak gerekebilir.  \u00d6rne\u011fin,  her hesap t\u00fcr\u00fc i\u00e7in ayr\u0131 bir tablo olu\u015fturmak ve ledger tablosunu bu tablolarla birle\u015ftirmek daha verimli bir yakla\u015f\u0131m olabilir.  Bu,  verileri daha d\u00fczenli ve anla\u015f\u0131l\u0131r hale getirir.  Ayr\u0131ca,  her i\u015flem i\u00e7in i\u015flem detaylar\u0131n\u0131 saklamak i\u00e7in ayr\u0131 bir tablo kullanmak,  ledger tablosunun boyutunu k\u00fc\u00e7\u00fcltmeye yard\u0131mc\u0131 olabilir.  Bu,  sorgulama performans\u0131n\u0131 art\u0131r\u0131r ve veri y\u00f6netimini kolayla\u015ft\u0131r\u0131r.  Karma\u015f\u0131k sorgulamalar\u0131n performans\u0131n\u0131 iyile\u015ftirmek i\u00e7in,  g\u00f6r\u00fcn\u00fcm (view) kullan\u0131m\u0131 da \u00f6nerilebilir.<\/p>\n<h2>G\u00fcvenlik ve Veri B\u00fct\u00fcnl\u00fc\u011f\u00fc<\/h2>\n<p>Dikkat! Ledger tablolar\u0131,  duyarl\u0131 finansal veriler i\u00e7erir.  Bu nedenle,  g\u00fcvenli\u011fi sa\u011flamak i\u00e7in gerekli \u00f6nlemleri almak son derece \u00f6nemlidir.  SQL Server'\u0131n sundu\u011fu g\u00fcvenlik \u00f6zelliklerini kullanarak,  yetkisiz eri\u015fimi \u00f6nlemeli ve veri b\u00fct\u00fcnl\u00fc\u011f\u00fcn\u00fc korumal\u0131y\u0131z.  \u00d6rne\u011fin,  sadece yetkili kullan\u0131c\u0131lar\u0131n ledger tablosuna eri\u015febilmesini sa\u011flamak i\u00e7in,  rol tabanl\u0131 eri\u015fim kontrol\u00fc (RBAC) kullanabiliriz.  Ayr\u0131ca,  verileri \u015fifreleyerek,  fiziksel ve mant\u0131ksal g\u00fcvenli\u011fi sa\u011flayabiliriz.  Veri b\u00fct\u00fcnl\u00fc\u011f\u00fcn\u00fc korumak i\u00e7in,  k\u0131s\u0131tlamalar (constraints) ve tetikleyiciler (triggers) kullanabiliriz.  \u00d6rne\u011fin,  <code>DebitAmount<\/code> ve <code>CreditAmount<\/code> s\u00fctunlar\u0131n\u0131n her zaman pozitif de\u011ferler i\u00e7ermesini sa\u011flayabiliriz.  Ayr\u0131ca,  her debet giri\u015finin kar\u015f\u0131l\u0131\u011f\u0131nda bir kredi giri\u015finin olmas\u0131n\u0131 sa\u011flamak i\u00e7in bir tetikleyici kullanabiliriz.  Bu \u00f6nlemler,  veri tutars\u0131zl\u0131klar\u0131n\u0131 \u00f6nlemeye ve veri g\u00fcvenli\u011fini art\u0131rmaya yard\u0131mc\u0131 olur.<\/p>\n<h2>\u00d6\u011frenme Yol Haritas\u0131<\/h2>\n<ul>\n<li><strong>Yeni Ba\u015flayan:<\/strong> Temel SQL komutlar\u0131n\u0131 (SELECT, INSERT, UPDATE, DELETE) \u00f6\u011frenin.  Basit bir ledger tablosu tasarlay\u0131n ve veri ekleme\/sorgulama i\u015flemlerini ger\u00e7ekle\u015ftirin.<\/li>\n<li><strong>Orta Seviye:<\/strong> \u0130ndeksleme, par\u00e7al\u0131 tablolar ve ili\u015fkili tablolar gibi performans optimizasyon tekniklerini \u00f6\u011frenin.  Daha karma\u015f\u0131k sorgulamalar yaz\u0131n ve verileri analiz edin.<\/li>\n<li><strong>\u0130leri Seviye:<\/strong> Denormalizasyon, tetikleyiciler ve stored procedure'lar gibi ileri d\u00fczey teknikleri \u00f6\u011frenin.  G\u00fcvenlik ve veri b\u00fct\u00fcnl\u00fc\u011f\u00fc konular\u0131nda uzmanla\u015f\u0131n.<\/li>\n<\/ul>\n<h2>Sonu\u00e7<\/h2>\n<p>SQL Server ledger tablolar\u0131,  g\u00fc\u00e7l\u00fc ve esnek bir muhasebe sistemi olu\u015fturmak i\u00e7in m\u00fckemmel bir ara\u00e7t\u0131r.  Bu makalede,  ledger tablolar\u0131n\u0131n nas\u0131l tasarlanaca\u011f\u0131n\u0131, uygulanaca\u011f\u0131n\u0131 ve optimize edilece\u011fini detayl\u0131 bir \u015fekilde inceledik.  Ger\u00e7ek d\u00fcnya senaryolar\u0131ndan \u00f6rnekler vererek,  konuyu daha iyi anlaman\u0131za yard\u0131mc\u0131 olmaya \u00e7al\u0131\u015ft\u0131k.  Unutmay\u0131n ki,  performans optimizasyonu ve g\u00fcvenlik,  ledger tablolar\u0131 tasar\u0131m\u0131 s\u00fcrecinde \u00e7ok \u00f6nemlidir.  Bu konularda uzmanla\u015fmak,  verimli ve g\u00fcvenilir bir muhasebe sistemi olu\u015fturman\u0131z i\u00e7in hayati \u00f6nem ta\u015f\u0131r.<\/p>\n<h3>S\u0131k\u00e7a Sorulan Sorular<\/h3>\n<ul>\n<li><strong>Ledger tablosu ne kadar b\u00fcy\u00fck olabilir?<\/strong>  Ledger tablolar\u0131n\u0131n boyutu,  i\u015fletmenin b\u00fcy\u00fckl\u00fc\u011f\u00fcne ve i\u015flem hacmine ba\u011fl\u0131d\u0131r.  \u00c7ok b\u00fcy\u00fck ledger tablolar\u0131 i\u00e7in par\u00e7al\u0131 tablolar kullanmak performans\u0131 art\u0131r\u0131r.<\/li>\n<li><strong>Ledger tablosunda hangi veri tiplerini kullanmal\u0131y\u0131m?<\/strong>  Veri tiplerini,  kaydedilecek verilerin t\u00fcr\u00fcne g\u00f6re se\u00e7in.  \u00d6rne\u011fin,  para birimleri i\u00e7in DECIMAL veri tipi uygun olabilir.<\/li>\n<li><strong>Ledger tablosunu nas\u0131l yedekleyebilirim?<\/strong>  SQL Server'\u0131n yedekleme ve geri y\u00fckleme \u00f6zelliklerini kullanarak ledger tablosunu d\u00fczenli olarak yedekleyebilirsiniz.<\/li>\n<li><strong>Ledger tablosunda veri b\u00fct\u00fcnl\u00fc\u011f\u00fcn\u00fc nas\u0131l sa\u011flayabilirim?<\/strong>  K\u0131s\u0131tlamalar (constraints), tetikleyiciler (triggers) ve do\u011frulama kurallar\u0131 kullanarak veri b\u00fct\u00fcnl\u00fc\u011f\u00fcn\u00fc sa\u011flayabilirsiniz.<\/li>\n<li><strong>Ledger tablosunun performans\u0131n\u0131 nas\u0131l izleyebilirim?<\/strong>  SQL Server'\u0131n performans izleme ara\u00e7lar\u0131n\u0131 kullanarak ledger tablosunun performans\u0131n\u0131 izleyebilirsiniz.<\/li>\n<\/ul>\n<p>Yazar: Fatih Soysal<\/p>\n","protected":false},"excerpt":{"rendered":"SQL Server Ledger Tablolar\u0131: Bankac\u0131l\u0131k \u00d6rne\u011fiyle Tam K\u0131lavuz G\u00fcn\u00fcm\u00fcz\u00fcn karma\u015f\u0131k finansal d\u00fcnyas\u0131nda, g\u00fcvenilir ve verimli bir muhasebe sistemi&hellip;","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"csco_page_header_type":"","csco_page_load_nextpost":"","csco_page_subscribe_form":"","csco_page_contact_form":"","footnotes":""},"categories":[1],"tags":[],"class_list":{"0":"post-29621","1":"post","2":"type-post","3":"status-publish","4":"format-standard","6":"category-genel","7":"cs-entry","8":"cs-video-wrap"},"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v20.5 (Yoast SEO v25.3.1) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>SQL Server Ledger Tablolar\u0131: Bankac\u0131l\u0131k \u00d6rne\u011fiyle Tam K\u0131lavuz<\/title>\n<meta name=\"description\" content=\"G\u00fcn\u00fcm\u00fcz\u00fcn karma\u015f\u0131k finansal d\u00fcnyas\u0131nda, g\u00fcvenilir ve verimli bir muhasebe sistemi hayati \u00f6nem ta\u015f\u0131maktad\u0131r. SQL Server&#039;\u0131n sundu\u011fu g\u00fc\u00e7l\u00fc veri y\u00f6netim yetenekleri, bu ihtiyac\u0131 kar\u015f\u0131lamak i\u00e7in ideal bir \u00e7\u00f6z\u00fcm sunmaktad\u0131r. Bu makalede, SQL Server&#039;da ledger (muhasebe defteri) tablolar\u0131n\u0131n nas\u0131l tasarlanaca\u011f\u0131n\u0131, uygulanaca\u011f\u0131n\u0131 ve optimize edilece\u011fini, ger\u00e7ek d\u00fcnya senaryolar\u0131yla birlikte ad\u0131m ad\u0131m inceleyece\u011fiz. Bankac\u0131l\u0131k sekt\u00f6r\u00fcnden \u00f6rnekler kullanarak, SQL Server ile g\u00fc\u00e7l\u00fc ve g\u00fcvenilir bir muhasebe sisteminin nas\u0131l kurulabilece\u011fini g\u00f6rece\u011fiz. \u0130ster yeni ba\u015flayan ister deneyimli bir SQL geli\u015ftiricisi olun, bu k\u0131lavuz size SQL Server ledger tablolar\u0131 konusunda kapsaml\u0131 bir anlay\u0131\u015f kazand\u0131racakt\u0131r.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/fatihsoysal.com\/blog\/sql-server-ledger-tablolari-bankacilik-ornegiyle-tam-kilavuz\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQL Server Ledger Tablolar\u0131: Bankac\u0131l\u0131k \u00d6rne\u011fiyle Tam K\u0131lavuz\" \/>\n<meta property=\"og:description\" content=\"G\u00fcn\u00fcm\u00fcz\u00fcn karma\u015f\u0131k finansal d\u00fcnyas\u0131nda, g\u00fcvenilir ve verimli bir muhasebe sistemi hayati \u00f6nem ta\u015f\u0131maktad\u0131r. SQL Server&#039;\u0131n sundu\u011fu g\u00fc\u00e7l\u00fc veri y\u00f6netim yetenekleri, bu ihtiyac\u0131 kar\u015f\u0131lamak i\u00e7in ideal bir \u00e7\u00f6z\u00fcm sunmaktad\u0131r. Bu makalede, SQL Server&#039;da ledger (muhasebe defteri) tablolar\u0131n\u0131n nas\u0131l tasarlanaca\u011f\u0131n\u0131, uygulanaca\u011f\u0131n\u0131 ve optimize edilece\u011fini, ger\u00e7ek d\u00fcnya senaryolar\u0131yla birlikte ad\u0131m ad\u0131m inceleyece\u011fiz. Bankac\u0131l\u0131k sekt\u00f6r\u00fcnden \u00f6rnekler kullanarak, SQL Server ile g\u00fc\u00e7l\u00fc ve g\u00fcvenilir bir muhasebe sisteminin nas\u0131l kurulabilece\u011fini g\u00f6rece\u011fiz. \u0130ster yeni ba\u015flayan ister deneyimli bir SQL geli\u015ftiricisi olun, bu k\u0131lavuz size SQL Server ledger tablolar\u0131 konusunda kapsaml\u0131 bir anlay\u0131\u015f kazand\u0131racakt\u0131r.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/fatihsoysal.com\/blog\/sql-server-ledger-tablolari-bankacilik-ornegiyle-tam-kilavuz\/\" \/>\n<meta property=\"og:site_name\" content=\"Kodlar\u0131n Gizemli D\u00fcnyas\u0131\" \/>\n<meta property=\"article:published_time\" content=\"2025-09-17T02:32:38+00:00\" \/>\n<meta name=\"author\" content=\"Fatih Soysal\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Yazan:\" \/>\n\t<meta name=\"twitter:data1\" content=\"Fatih Soysal\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tahmini okuma s\u00fcresi\" \/>\n\t<meta name=\"twitter:data2\" content=\"8 dakika\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/fatihsoysal.com\/blog\/sql-server-ledger-tablolari-bankacilik-ornegiyle-tam-kilavuz\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/sql-server-ledger-tablolari-bankacilik-ornegiyle-tam-kilavuz\/\"},\"author\":{\"name\":\"Fatih Soysal\",\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1\"},\"headline\":\"SQL Server Ledger Tablolar\u0131: Bankac\u0131l\u0131k \u00d6rne\u011fiyle Tam K\u0131lavuz\",\"datePublished\":\"2025-09-17T02:32:38+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/sql-server-ledger-tablolari-bankacilik-ornegiyle-tam-kilavuz\/\"},\"wordCount\":1610,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/fatihsoysal.com\/blog\/sql-server-ledger-tablolari-bankacilik-ornegiyle-tam-kilavuz\/#respond\"]}],\"copyrightYear\":\"2025\",\"copyrightHolder\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#organization\"}},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/fatihsoysal.com\/blog\/sql-server-ledger-tablolari-bankacilik-ornegiyle-tam-kilavuz\/\",\"url\":\"https:\/\/fatihsoysal.com\/blog\/sql-server-ledger-tablolari-bankacilik-ornegiyle-tam-kilavuz\/\",\"name\":\"SQL Server Ledger Tablolar\u0131: Bankac\u0131l\u0131k \u00d6rne\u011fiyle Tam K\u0131lavuz\",\"isPartOf\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#website\"},\"datePublished\":\"2025-09-17T02:32:38+00:00\",\"description\":\"G\u00fcn\u00fcm\u00fcz\u00fcn karma\u015f\u0131k finansal d\u00fcnyas\u0131nda, g\u00fcvenilir ve verimli bir muhasebe sistemi hayati \u00f6nem ta\u015f\u0131maktad\u0131r. SQL Server'\u0131n sundu\u011fu g\u00fc\u00e7l\u00fc veri y\u00f6netim yetenekleri, bu ihtiyac\u0131 kar\u015f\u0131lamak i\u00e7in ideal bir \u00e7\u00f6z\u00fcm sunmaktad\u0131r. Bu makalede, SQL Server'da ledger (muhasebe defteri) tablolar\u0131n\u0131n nas\u0131l tasarlanaca\u011f\u0131n\u0131, uygulanaca\u011f\u0131n\u0131 ve optimize edilece\u011fini, ger\u00e7ek d\u00fcnya senaryolar\u0131yla birlikte ad\u0131m ad\u0131m inceleyece\u011fiz. Bankac\u0131l\u0131k sekt\u00f6r\u00fcnden \u00f6rnekler kullanarak, SQL Server ile g\u00fc\u00e7l\u00fc ve g\u00fcvenilir bir muhasebe sisteminin nas\u0131l kurulabilece\u011fini g\u00f6rece\u011fiz. \u0130ster yeni ba\u015flayan ister deneyimli bir SQL geli\u015ftiricisi olun, bu k\u0131lavuz size SQL Server ledger tablolar\u0131 konusunda kapsaml\u0131 bir anlay\u0131\u015f kazand\u0131racakt\u0131r.\",\"breadcrumb\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/sql-server-ledger-tablolari-bankacilik-ornegiyle-tam-kilavuz\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/fatihsoysal.com\/blog\/sql-server-ledger-tablolari-bankacilik-ornegiyle-tam-kilavuz\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/fatihsoysal.com\/blog\/sql-server-ledger-tablolari-bankacilik-ornegiyle-tam-kilavuz\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Anasayfa\",\"item\":\"https:\/\/fatihsoysal.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SQL Server Ledger Tablolar\u0131: Bankac\u0131l\u0131k \u00d6rne\u011fiyle Tam K\u0131lavuz\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#website\",\"url\":\"https:\/\/fatihsoysal.com\/blog\/\",\"name\":\"Fatihsoysal.com\",\"description\":\"Blog - Yaz\u0131l\u0131m D\u00fcnyas\u0131 Tecr\u00fcbelerim\",\"publisher\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/fatihsoysal.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"tr\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1\",\"name\":\"Fatih Soysal\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/fatihsoysal.com\/blog\/wp-content\/uploads\/2024\/04\/cropped-replicate-prediction-3kgg1hgjn5rgp0cf0p5tr0jw7w-1.png\",\"contentUrl\":\"https:\/\/fatihsoysal.com\/blog\/wp-content\/uploads\/2024\/04\/cropped-replicate-prediction-3kgg1hgjn5rgp0cf0p5tr0jw7w-1.png\",\"width\":512,\"height\":512,\"caption\":\"Fatih Soysal\"},\"logo\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/image\/\"},\"description\":\"Kullan\u0131m ve kodlama m\u00fckemmeliyetini odak alan uygulamalar olu\u015fturma deneyimine sahip, profesyonel olarak 15+ y\u0131l \u00fczeri deneyime sahip bir yaz\u0131l\u0131m m\u00fchendisi.\",\"url\":\"https:\/\/fatihsoysal.com\/blog\/author\/fatihsoysal\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"SQL Server Ledger Tablolar\u0131: Bankac\u0131l\u0131k \u00d6rne\u011fiyle Tam K\u0131lavuz","description":"G\u00fcn\u00fcm\u00fcz\u00fcn karma\u015f\u0131k finansal d\u00fcnyas\u0131nda, g\u00fcvenilir ve verimli bir muhasebe sistemi hayati \u00f6nem ta\u015f\u0131maktad\u0131r. SQL Server'\u0131n sundu\u011fu g\u00fc\u00e7l\u00fc veri y\u00f6netim yetenekleri, bu ihtiyac\u0131 kar\u015f\u0131lamak i\u00e7in ideal bir \u00e7\u00f6z\u00fcm sunmaktad\u0131r. Bu makalede, SQL Server'da ledger (muhasebe defteri) tablolar\u0131n\u0131n nas\u0131l tasarlanaca\u011f\u0131n\u0131, uygulanaca\u011f\u0131n\u0131 ve optimize edilece\u011fini, ger\u00e7ek d\u00fcnya senaryolar\u0131yla birlikte ad\u0131m ad\u0131m inceleyece\u011fiz. Bankac\u0131l\u0131k sekt\u00f6r\u00fcnden \u00f6rnekler kullanarak, SQL Server ile g\u00fc\u00e7l\u00fc ve g\u00fcvenilir bir muhasebe sisteminin nas\u0131l kurulabilece\u011fini g\u00f6rece\u011fiz. \u0130ster yeni ba\u015flayan ister deneyimli bir SQL geli\u015ftiricisi olun, bu k\u0131lavuz size SQL Server ledger tablolar\u0131 konusunda kapsaml\u0131 bir anlay\u0131\u015f kazand\u0131racakt\u0131r.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/fatihsoysal.com\/blog\/sql-server-ledger-tablolari-bankacilik-ornegiyle-tam-kilavuz\/","og_locale":"tr_TR","og_type":"article","og_title":"SQL Server Ledger Tablolar\u0131: Bankac\u0131l\u0131k \u00d6rne\u011fiyle Tam K\u0131lavuz","og_description":"G\u00fcn\u00fcm\u00fcz\u00fcn karma\u015f\u0131k finansal d\u00fcnyas\u0131nda, g\u00fcvenilir ve verimli bir muhasebe sistemi hayati \u00f6nem ta\u015f\u0131maktad\u0131r. SQL Server'\u0131n sundu\u011fu g\u00fc\u00e7l\u00fc veri y\u00f6netim yetenekleri, bu ihtiyac\u0131 kar\u015f\u0131lamak i\u00e7in ideal bir \u00e7\u00f6z\u00fcm sunmaktad\u0131r. Bu makalede, SQL Server'da ledger (muhasebe defteri) tablolar\u0131n\u0131n nas\u0131l tasarlanaca\u011f\u0131n\u0131, uygulanaca\u011f\u0131n\u0131 ve optimize edilece\u011fini, ger\u00e7ek d\u00fcnya senaryolar\u0131yla birlikte ad\u0131m ad\u0131m inceleyece\u011fiz. Bankac\u0131l\u0131k sekt\u00f6r\u00fcnden \u00f6rnekler kullanarak, SQL Server ile g\u00fc\u00e7l\u00fc ve g\u00fcvenilir bir muhasebe sisteminin nas\u0131l kurulabilece\u011fini g\u00f6rece\u011fiz. \u0130ster yeni ba\u015flayan ister deneyimli bir SQL geli\u015ftiricisi olun, bu k\u0131lavuz size SQL Server ledger tablolar\u0131 konusunda kapsaml\u0131 bir anlay\u0131\u015f kazand\u0131racakt\u0131r.","og_url":"https:\/\/fatihsoysal.com\/blog\/sql-server-ledger-tablolari-bankacilik-ornegiyle-tam-kilavuz\/","og_site_name":"Kodlar\u0131n Gizemli D\u00fcnyas\u0131","article_published_time":"2025-09-17T02:32:38+00:00","author":"Fatih Soysal","twitter_card":"summary_large_image","twitter_misc":{"Yazan:":"Fatih Soysal","Tahmini okuma s\u00fcresi":"8 dakika"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/fatihsoysal.com\/blog\/sql-server-ledger-tablolari-bankacilik-ornegiyle-tam-kilavuz\/#article","isPartOf":{"@id":"https:\/\/fatihsoysal.com\/blog\/sql-server-ledger-tablolari-bankacilik-ornegiyle-tam-kilavuz\/"},"author":{"name":"Fatih Soysal","@id":"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1"},"headline":"SQL Server Ledger Tablolar\u0131: Bankac\u0131l\u0131k \u00d6rne\u011fiyle Tam K\u0131lavuz","datePublished":"2025-09-17T02:32:38+00:00","mainEntityOfPage":{"@id":"https:\/\/fatihsoysal.com\/blog\/sql-server-ledger-tablolari-bankacilik-ornegiyle-tam-kilavuz\/"},"wordCount":1610,"commentCount":0,"publisher":{"@id":"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1"},"inLanguage":"tr","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/fatihsoysal.com\/blog\/sql-server-ledger-tablolari-bankacilik-ornegiyle-tam-kilavuz\/#respond"]}],"copyrightYear":"2025","copyrightHolder":{"@id":"https:\/\/fatihsoysal.com\/blog\/#organization"}},{"@type":"WebPage","@id":"https:\/\/fatihsoysal.com\/blog\/sql-server-ledger-tablolari-bankacilik-ornegiyle-tam-kilavuz\/","url":"https:\/\/fatihsoysal.com\/blog\/sql-server-ledger-tablolari-bankacilik-ornegiyle-tam-kilavuz\/","name":"SQL Server Ledger Tablolar\u0131: Bankac\u0131l\u0131k \u00d6rne\u011fiyle Tam K\u0131lavuz","isPartOf":{"@id":"https:\/\/fatihsoysal.com\/blog\/#website"},"datePublished":"2025-09-17T02:32:38+00:00","description":"G\u00fcn\u00fcm\u00fcz\u00fcn karma\u015f\u0131k finansal d\u00fcnyas\u0131nda, g\u00fcvenilir ve verimli bir muhasebe sistemi hayati \u00f6nem ta\u015f\u0131maktad\u0131r. SQL Server'\u0131n sundu\u011fu g\u00fc\u00e7l\u00fc veri y\u00f6netim yetenekleri, bu ihtiyac\u0131 kar\u015f\u0131lamak i\u00e7in ideal bir \u00e7\u00f6z\u00fcm sunmaktad\u0131r. Bu makalede, SQL Server'da ledger (muhasebe defteri) tablolar\u0131n\u0131n nas\u0131l tasarlanaca\u011f\u0131n\u0131, uygulanaca\u011f\u0131n\u0131 ve optimize edilece\u011fini, ger\u00e7ek d\u00fcnya senaryolar\u0131yla birlikte ad\u0131m ad\u0131m inceleyece\u011fiz. Bankac\u0131l\u0131k sekt\u00f6r\u00fcnden \u00f6rnekler kullanarak, SQL Server ile g\u00fc\u00e7l\u00fc ve g\u00fcvenilir bir muhasebe sisteminin nas\u0131l kurulabilece\u011fini g\u00f6rece\u011fiz. \u0130ster yeni ba\u015flayan ister deneyimli bir SQL geli\u015ftiricisi olun, bu k\u0131lavuz size SQL Server ledger tablolar\u0131 konusunda kapsaml\u0131 bir anlay\u0131\u015f kazand\u0131racakt\u0131r.","breadcrumb":{"@id":"https:\/\/fatihsoysal.com\/blog\/sql-server-ledger-tablolari-bankacilik-ornegiyle-tam-kilavuz\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/fatihsoysal.com\/blog\/sql-server-ledger-tablolari-bankacilik-ornegiyle-tam-kilavuz\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/fatihsoysal.com\/blog\/sql-server-ledger-tablolari-bankacilik-ornegiyle-tam-kilavuz\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Anasayfa","item":"https:\/\/fatihsoysal.com\/blog\/"},{"@type":"ListItem","position":2,"name":"SQL Server Ledger Tablolar\u0131: Bankac\u0131l\u0131k \u00d6rne\u011fiyle Tam K\u0131lavuz"}]},{"@type":"WebSite","@id":"https:\/\/fatihsoysal.com\/blog\/#website","url":"https:\/\/fatihsoysal.com\/blog\/","name":"Fatihsoysal.com","description":"Blog - Yaz\u0131l\u0131m D\u00fcnyas\u0131 Tecr\u00fcbelerim","publisher":{"@id":"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/fatihsoysal.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"tr"},{"@type":["Person","Organization"],"@id":"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1","name":"Fatih Soysal","image":{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/fatihsoysal.com\/blog\/wp-content\/uploads\/2024\/04\/cropped-replicate-prediction-3kgg1hgjn5rgp0cf0p5tr0jw7w-1.png","contentUrl":"https:\/\/fatihsoysal.com\/blog\/wp-content\/uploads\/2024\/04\/cropped-replicate-prediction-3kgg1hgjn5rgp0cf0p5tr0jw7w-1.png","width":512,"height":512,"caption":"Fatih Soysal"},"logo":{"@id":"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/image\/"},"description":"Kullan\u0131m ve kodlama m\u00fckemmeliyetini odak alan uygulamalar olu\u015fturma deneyimine sahip, profesyonel olarak 15+ y\u0131l \u00fczeri deneyime sahip bir yaz\u0131l\u0131m m\u00fchendisi.","url":"https:\/\/fatihsoysal.com\/blog\/author\/fatihsoysal\/"}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/posts\/29621","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/comments?post=29621"}],"version-history":[{"count":0,"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/posts\/29621\/revisions"}],"wp:attachment":[{"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/media?parent=29621"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/categories?post=29621"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/tags?post=29621"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}