{"id":7909,"date":"2015-09-21T11:31:13","date_gmt":"2015-09-21T15:31:13","guid":{"rendered":"http:\/\/www.iri.com\/blog\/?p=7909"},"modified":"2024-12-25T14:25:20","modified_gmt":"2024-12-25T19:25:20","slug":"er-diagrams-in-iri-workbench","status":"publish","type":"post","link":"https:\/\/www.iri.com\/blog\/vldb-operations\/er-diagrams-in-iri-workbench\/","title":{"rendered":"Creating E-R Diagrams in IRI Workbench"},"content":{"rendered":"

The Entity-Relationship Diagram (ERD), or entity relationship model, is a visual depiction of database tables (entities) and how they are linked through primary and foreign keys (relationships) to each other. This article describes ERDs in more detail, and highlights the free ERD wizard IRI provides for relational databases connected in Eclipse within its Workbench IDE<\/a>.<\/p>\n

Table Attributes<\/strong><\/p>\n

Within each table in the diagram\u00a0are the column names, their data types and lengths, and whether they are a primary key, foreign key, or both. The column’s key status determines not only the order the table is maintained in, but how that value is linked to, or dependent on, the value in another table. Additionally, the diagram indicates whether that field is an index or is nullable.<\/p>\n

\u00a0<\/span>A primary key<\/i><\/span>\u00a0is one or more columns that uniquely identify a row. Every table should have a primary key, and can only have one.<\/p>\n

A foreign key<\/i><\/span>\u00a0is a\u00a0one or more columns whose\u00a0values must<\/i><\/span>\u00a0have matching values in the primary key of another (or the same) table. A foreign key thus references its primary key, and is the way data or referential integrity is maintained across linked tables.<\/p>\n

The key attributes are used in the model to define how the tables map to each other and\u00a0whether their column values\u00a0are uniquely linked to other tables or not. These relationships are known as mapping cardinalities.<\/p>\n

Mapping Cardinalities<\/strong><\/p>\n

ERDs typically display one-to-one, one-to-many, and many-to-many relationships between columns across tables.<\/p>\n

A\u00a0one-to-one relationship is where a value in a table is uniquely linked to a value in another and vice versa. For example, consider a student\u00a0database where each student in table A is linked to only one student ID in table B.<\/p>\n

A one-to-many relationship exists\u00a0where a\u00a0value in table A can be linked to one or many values in table B, but those in table B link back to the table A value. For example, schools\u00a0in table A may be linked to many students in table B, but not vice versa.<\/p>\n

A many-to-many relationship is where values in table A can be related to one or many values in table B and vice versa.\u00a0For example, for a company in which all of its employees work on multiple projects, each instance of an employee (A) is associated with many instances of a project (B), and at the same time, each instance of a project (B) has multiple employees (A) associated with it.<\/p>\n

Mapping Modality<\/b><\/p>\n

ERDs can also display required versus optional\u00a0relationships. \u00a0The difference is represented by the type of line between the tables: solid for required and dashed for an\u00a0optional\u00a0relationship.<\/p>\n

IRI ERDs<\/strong><\/p>\n

In the IRI Workbench<\/a> GUI, built on Eclipse\u2122, any relational database connected in the Data Source Explorer via a JDBC driver can be modeled. The\u00a0New\u00a0<\/em>ER Diagram Model<\/em> Wizard is one of several free data profiling facilities available in the Workbench (including a database profiling wizard<\/a> for statistical reporting and value searching) and is accessed from the toolbar’s Data Discovery Menu<\/span>. <\/span><\/p>\n

The wizard guides you through the creation of the diagram.<\/span><\/p>\n

\"ER<\/a><\/p>\n

Select the tables required for diagramming and a new image available for download is produced that shows the table structures and their key relationships:<\/p>\n

\"Schema<\/a><\/p>\n

Some\u00a0of the mapping cardinalities can be deduced\u00a0by the key information in the entities. If a Foreign Key (FK) is not also a Primary Key (PK) or Unique value in the connected table, it can link to multiple instances. However, \u00a0if the field in the connected table is a PK, there can only be one value in that table associated with it.<\/p>\n

The ERD wizard in IRI Workbench is a useful way to model any database or data warehouse schema built on relational databases. This activity serves DBAs and data architects who are working on ETL, data masking, database migration, and test data generation projects using IRI data management or masking tools in the Workbench.<\/p>\n","protected":false},"excerpt":{"rendered":"

The Entity-Relationship Diagram (ERD), or entity relationship model, is a visual depiction of database tables (entities) and how they are linked through primary and foreign keys (relationships) to each other. This article describes ERDs in more detail, and highlights the free ERD wizard IRI provides for relational databases connected in Eclipse within its Workbench IDE.<\/p>\n

Read More<\/a><\/div>\n","protected":false},"author":43,"featured_media":7509,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_exactmetrics_skip_tracking":false,"_exactmetrics_sitenote_active":false,"_exactmetrics_sitenote_note":"","_exactmetrics_sitenote_category":0,"footnotes":""},"categories":[32,31,363,776,91,29,3],"tags":[280,855,885,884,881,880,882,883,891,890,850,889,886,888,887,893,1992,892,1993],"class_list":["post-7909","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-business-intelligence","category-data-migration","category-data-quality","category-etl","category-iri-workbench","category-test-data","category-vldb-operations","tag-data-discovery","tag-database-tables","tag-entities","tag-entity-relationship-model","tag-entity-relationship-diagram","tag-er-diagram-model-wizard","tag-erd","tag-erds","tag-fk","tag-foreign-key","tag-iri-workbench","tag-many-to-many","tag-mapping-cardinalities","tag-one-to-many","tag-one-to-one","tag-pk","tag-primary-and-foreign-key-relationships","tag-primary-key","tag-relational-database-modeling-tools"],"acf":[],"yoast_head":"\nCreating E-R Diagrams in IRI Workbench - IRI<\/title>\n<meta name=\"description\" content=\"Good E-R diagram tools support database design and management. Reveal table attributes, relationships, etc. with IRI's ERD wizard in Eclipse.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.iri.com\/blog\/vldb-operations\/er-diagrams-in-iri-workbench\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Creating E-R Diagrams in IRI Workbench\" \/>\n<meta property=\"og:description\" content=\"Good E-R diagram tools support database design and management. Reveal table attributes, relationships, etc. with IRI's ERD wizard in Eclipse.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.iri.com\/blog\/vldb-operations\/er-diagrams-in-iri-workbench\/\" \/>\n<meta property=\"og:site_name\" content=\"IRI\" \/>\n<meta property=\"article:published_time\" content=\"2015-09-21T15:31:13+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-12-25T19:25:20+00:00\" \/>\n<meta name=\"author\" content=\"Claudia Irvine\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Claudia Irvine\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.iri.com\/blog\/vldb-operations\/er-diagrams-in-iri-workbench\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.iri.com\/blog\/vldb-operations\/er-diagrams-in-iri-workbench\/\"},\"author\":{\"name\":\"Claudia Irvine\",\"@id\":\"https:\/\/www.iri.com\/blog\/#\/schema\/person\/72af50bbb317610e193e96392081f9b0\"},\"headline\":\"Creating E-R Diagrams in IRI Workbench\",\"datePublished\":\"2015-09-21T15:31:13+00:00\",\"dateModified\":\"2024-12-25T19:25:20+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.iri.com\/blog\/vldb-operations\/er-diagrams-in-iri-workbench\/\"},\"wordCount\":666,\"commentCount\":2,\"publisher\":{\"@id\":\"https:\/\/www.iri.com\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.iri.com\/blog\/vldb-operations\/er-diagrams-in-iri-workbench\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2015\/07\/t_Schema-Migration-to-Star-.jpg\",\"keywords\":[\"data discovery\",\"database tables\",\"entities\",\"entity relationship model\",\"Entity-Relationship Diagram\",\"ER Diagram Model Wizard\",\"ERD\",\"ERDs\",\"FK\",\"Foreign Key\",\"IRI Workbench\",\"many-to-many\",\"mapping cardinalities\",\"one-to-many\",\"one-to-one\",\"PK\",\"primary and foreign key relationships\",\"Primary Key\",\"relational database modeling tools\"],\"articleSection\":[\"Business Intelligence (BI)\",\"Data Migration\",\"Data Quality (DQ)\",\"ETL\",\"IRI Workbench\",\"Test Data\",\"VLDB\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.iri.com\/blog\/vldb-operations\/er-diagrams-in-iri-workbench\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.iri.com\/blog\/vldb-operations\/er-diagrams-in-iri-workbench\/\",\"url\":\"https:\/\/www.iri.com\/blog\/vldb-operations\/er-diagrams-in-iri-workbench\/\",\"name\":\"Creating E-R Diagrams in IRI Workbench - IRI\",\"isPartOf\":{\"@id\":\"https:\/\/www.iri.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.iri.com\/blog\/vldb-operations\/er-diagrams-in-iri-workbench\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.iri.com\/blog\/vldb-operations\/er-diagrams-in-iri-workbench\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2015\/07\/t_Schema-Migration-to-Star-.jpg\",\"datePublished\":\"2015-09-21T15:31:13+00:00\",\"dateModified\":\"2024-12-25T19:25:20+00:00\",\"description\":\"Good E-R diagram tools support database design and management. Reveal table attributes, relationships, etc. with IRI's ERD wizard in Eclipse.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.iri.com\/blog\/vldb-operations\/er-diagrams-in-iri-workbench\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.iri.com\/blog\/vldb-operations\/er-diagrams-in-iri-workbench\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.iri.com\/blog\/vldb-operations\/er-diagrams-in-iri-workbench\/#primaryimage\",\"url\":\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2015\/07\/t_Schema-Migration-to-Star-.jpg\",\"contentUrl\":\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2015\/07\/t_Schema-Migration-to-Star-.jpg\",\"width\":505,\"height\":312},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.iri.com\/blog\/vldb-operations\/er-diagrams-in-iri-workbench\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.iri.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Creating E-R Diagrams in IRI Workbench\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.iri.com\/blog\/#website\",\"url\":\"https:\/\/www.iri.com\/blog\/\",\"name\":\"IRI\",\"description\":\"Total Data Management Blog\",\"publisher\":{\"@id\":\"https:\/\/www.iri.com\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.iri.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.iri.com\/blog\/#organization\",\"name\":\"IRI\",\"url\":\"https:\/\/www.iri.com\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.iri.com\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2019\/02\/iri-logo-total-data-management-small-1.png\",\"contentUrl\":\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2019\/02\/iri-logo-total-data-management-small-1.png\",\"width\":750,\"height\":206,\"caption\":\"IRI\"},\"image\":{\"@id\":\"https:\/\/www.iri.com\/blog\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.iri.com\/blog\/#\/schema\/person\/72af50bbb317610e193e96392081f9b0\",\"name\":\"Claudia Irvine\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.iri.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/fb33dee44756bd13ac23f1342c2bb7b2?s=96&d=blank&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/fb33dee44756bd13ac23f1342c2bb7b2?s=96&d=blank&r=g\",\"caption\":\"Claudia Irvine\"},\"url\":\"https:\/\/www.iri.com\/blog\/author\/claudiai\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Creating E-R Diagrams in IRI Workbench - IRI","description":"Good E-R diagram tools support database design and management. Reveal table attributes, relationships, etc. with IRI's ERD wizard in Eclipse.","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:\/\/www.iri.com\/blog\/vldb-operations\/er-diagrams-in-iri-workbench\/","og_locale":"en_US","og_type":"article","og_title":"Creating E-R Diagrams in IRI Workbench","og_description":"Good E-R diagram tools support database design and management. Reveal table attributes, relationships, etc. with IRI's ERD wizard in Eclipse.","og_url":"https:\/\/www.iri.com\/blog\/vldb-operations\/er-diagrams-in-iri-workbench\/","og_site_name":"IRI","article_published_time":"2015-09-21T15:31:13+00:00","article_modified_time":"2024-12-25T19:25:20+00:00","author":"Claudia Irvine","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Claudia Irvine","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.iri.com\/blog\/vldb-operations\/er-diagrams-in-iri-workbench\/#article","isPartOf":{"@id":"https:\/\/www.iri.com\/blog\/vldb-operations\/er-diagrams-in-iri-workbench\/"},"author":{"name":"Claudia Irvine","@id":"https:\/\/www.iri.com\/blog\/#\/schema\/person\/72af50bbb317610e193e96392081f9b0"},"headline":"Creating E-R Diagrams in IRI Workbench","datePublished":"2015-09-21T15:31:13+00:00","dateModified":"2024-12-25T19:25:20+00:00","mainEntityOfPage":{"@id":"https:\/\/www.iri.com\/blog\/vldb-operations\/er-diagrams-in-iri-workbench\/"},"wordCount":666,"commentCount":2,"publisher":{"@id":"https:\/\/www.iri.com\/blog\/#organization"},"image":{"@id":"https:\/\/www.iri.com\/blog\/vldb-operations\/er-diagrams-in-iri-workbench\/#primaryimage"},"thumbnailUrl":"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2015\/07\/t_Schema-Migration-to-Star-.jpg","keywords":["data discovery","database tables","entities","entity relationship model","Entity-Relationship Diagram","ER Diagram Model Wizard","ERD","ERDs","FK","Foreign Key","IRI Workbench","many-to-many","mapping cardinalities","one-to-many","one-to-one","PK","primary and foreign key relationships","Primary Key","relational database modeling tools"],"articleSection":["Business Intelligence (BI)","Data Migration","Data Quality (DQ)","ETL","IRI Workbench","Test Data","VLDB"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.iri.com\/blog\/vldb-operations\/er-diagrams-in-iri-workbench\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.iri.com\/blog\/vldb-operations\/er-diagrams-in-iri-workbench\/","url":"https:\/\/www.iri.com\/blog\/vldb-operations\/er-diagrams-in-iri-workbench\/","name":"Creating E-R Diagrams in IRI Workbench - IRI","isPartOf":{"@id":"https:\/\/www.iri.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.iri.com\/blog\/vldb-operations\/er-diagrams-in-iri-workbench\/#primaryimage"},"image":{"@id":"https:\/\/www.iri.com\/blog\/vldb-operations\/er-diagrams-in-iri-workbench\/#primaryimage"},"thumbnailUrl":"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2015\/07\/t_Schema-Migration-to-Star-.jpg","datePublished":"2015-09-21T15:31:13+00:00","dateModified":"2024-12-25T19:25:20+00:00","description":"Good E-R diagram tools support database design and management. Reveal table attributes, relationships, etc. with IRI's ERD wizard in Eclipse.","breadcrumb":{"@id":"https:\/\/www.iri.com\/blog\/vldb-operations\/er-diagrams-in-iri-workbench\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.iri.com\/blog\/vldb-operations\/er-diagrams-in-iri-workbench\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.iri.com\/blog\/vldb-operations\/er-diagrams-in-iri-workbench\/#primaryimage","url":"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2015\/07\/t_Schema-Migration-to-Star-.jpg","contentUrl":"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2015\/07\/t_Schema-Migration-to-Star-.jpg","width":505,"height":312},{"@type":"BreadcrumbList","@id":"https:\/\/www.iri.com\/blog\/vldb-operations\/er-diagrams-in-iri-workbench\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.iri.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Creating E-R Diagrams in IRI Workbench"}]},{"@type":"WebSite","@id":"https:\/\/www.iri.com\/blog\/#website","url":"https:\/\/www.iri.com\/blog\/","name":"IRI","description":"Total Data Management Blog","publisher":{"@id":"https:\/\/www.iri.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.iri.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.iri.com\/blog\/#organization","name":"IRI","url":"https:\/\/www.iri.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.iri.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2019\/02\/iri-logo-total-data-management-small-1.png","contentUrl":"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2019\/02\/iri-logo-total-data-management-small-1.png","width":750,"height":206,"caption":"IRI"},"image":{"@id":"https:\/\/www.iri.com\/blog\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/www.iri.com\/blog\/#\/schema\/person\/72af50bbb317610e193e96392081f9b0","name":"Claudia Irvine","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.iri.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/fb33dee44756bd13ac23f1342c2bb7b2?s=96&d=blank&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/fb33dee44756bd13ac23f1342c2bb7b2?s=96&d=blank&r=g","caption":"Claudia Irvine"},"url":"https:\/\/www.iri.com\/blog\/author\/claudiai\/"}]}},"jetpack_featured_media_url":"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2015\/07\/t_Schema-Migration-to-Star-.jpg","_links":{"self":[{"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/posts\/7909"}],"collection":[{"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/users\/43"}],"replies":[{"embeddable":true,"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/comments?post=7909"}],"version-history":[{"count":25,"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/posts\/7909\/revisions"}],"predecessor-version":[{"id":18206,"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/posts\/7909\/revisions\/18206"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/media\/7509"}],"wp:attachment":[{"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/media?parent=7909"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/categories?post=7909"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/tags?post=7909"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}