{"id":41,"date":"2017-02-17T12:42:31","date_gmt":"2017-02-17T12:42:31","guid":{"rendered":"https:\/\/www.threesl.com:2958\/blog\/?p=41"},"modified":"2017-05-10T15:34:47","modified_gmt":"2017-05-10T14:34:47","slug":"cradle-database","status":"publish","type":"post","link":"https:\/\/www.threesl.com\/blog\/cradle-database\/","title":{"rendered":"Contents of a Cradle database"},"content":{"rendered":"<p>Each Cradle database contains different sets of information. These can be imagined as layers, where each layer uses the data in the layers below it. For example, cross references cannot exist until the items exist whose relationships are shown by the cross reference. These layers are, highest to lowest:<\/p>\n<p>1. Cross references &#8211; the links between the data<br \/>\n2. Items &#8211; the data<br \/>\n3. Definitions &#8211; how to find, view and report the data<br \/>\n4. User profiles &#8211; who can own and access the data<br \/>\n5. Schema &#8211; the structure of the data<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-40\" src=\"https:\/\/www.threesl.com:2958\/blog\/wp-content\/uploads\/2017\/02\/cradle-db-300x183.png\" alt=\"Cradle database layers\" width=\"300\" height=\"183\" srcset=\"https:\/\/www.threesl.com\/blog\/wp-content\/uploads\/2017\/02\/cradle-db-300x183.png 300w, https:\/\/www.threesl.com\/blog\/wp-content\/uploads\/2017\/02\/cradle-db.png 543w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><br \/>\nYou can export\/import each layer individually, or in any combination, or all layers. You should only import a layer of information if the lower layers already exist in the database (unless you know that it is safe).<\/p>\n<p>To initialise a new database from an existing database, you need as a minimum:<\/p>\n<p>&#8211; The schema<br \/>\n&#8211; Definitions<\/p>\n<p>User profiles are needed to use a database and may be needed for some parts of the schema (such as workflows and alerts) and definitions (user and personal scopes).<\/p>\n<aside class=\"mashsb-container mashsb-main mashsb-stretched\"><div class=\"mashsb-box\"><div class=\"mashsb-buttons\"><a class=\"mashicon-twitter mash-small mash-center mashsb-noshadow\" href=\"https:\/\/twitter.com\/intent\/tweet?text=&amp;url=https:\/\/www.threesl.com\/blog\/cradle-database\/&amp;via=threesl\" target=\"_top\" rel=\"nofollow\"><span class=\"icon\"><\/span><span class=\"text\">Tweet<\/span><\/a><a class=\"mashicon-facebook mash-small mash-center mashsb-noshadow\" href=\"https:\/\/www.facebook.com\/sharer.php?u=https%3A%2F%2Fwww.threesl.com%2Fblog%2Fcradle-database%2F\" target=\"_top\" rel=\"nofollow\"><span class=\"icon\"><\/span><span class=\"text\">Share<\/span><\/a><a class=\"mashicon-subscribe mash-small mash-center mashsb-noshadow\" href=\"#\" target=\"_top\" rel=\"nofollow\"><span class=\"icon\"><\/span><span class=\"text\">Newsletter<\/span><\/a><div class=\"onoffswitch2 mash-small mashsb-noshadow\" style=\"display:none\"><\/div><\/div>\n            <\/div>\n                <div style=\"clear:both\"><\/div><\/aside>\n            <!-- Share buttons by mashshare.net - Version: 4.0.47-->","protected":false},"excerpt":{"rendered":"<p>Each Cradle database contains different sets of information. These can be imagined as layers, where each layer uses the data in the layers below it. For example, cross references cannot exist until the items exist whose relationships are shown by the cross reference. These layers are, highest to lowest: 1. Cross references &#8211; the links &hellip; <\/p>\n<p class=\"link-more\"><a href=\"https:\/\/www.threesl.com\/blog\/cradle-database\/\" class=\"more-link\">Continue reading<span class=\"screen-reader-text\"> &#8220;Contents of a Cradle database&#8221;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_lmt_disableupdate":"","_lmt_disable":"","footnotes":""},"categories":[78],"tags":[345,329,331,330,64,494],"class_list":["post-41","post","type-post","status-publish","format-standard","hentry","category-articles","tag-cradle-database","tag-cross-references","tag-definitions","tag-items","tag-project-schema","tag-users"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.4 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Contents of a Cradle database - 3SL Blog<\/title>\n<meta name=\"description\" content=\"Contents of a Cradle database showing how the Cradle database is contrucuted and what it consists of. Cradle items, cross references, user profiles etc.\" \/>\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.threesl.com\/blog\/cradle-database\/\" \/>\n<meta property=\"og:locale\" content=\"en_GB\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Contents of a Cradle database - 3SL Blog\" \/>\n<meta property=\"og:description\" content=\"Contents of a Cradle database showing how the Cradle database is contrucuted and what it consists of. Cradle items, cross references, user profiles etc.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.threesl.com\/blog\/cradle-database\/\" \/>\n<meta property=\"og:site_name\" content=\"3SL Blog\" \/>\n<meta property=\"article:publisher\" content=\"http:\/\/facebook.com\/3SLCradle\" \/>\n<meta property=\"article:published_time\" content=\"2017-02-17T12:42:31+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2017-05-10T14:34:47+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.threesl.com:2958\/blog\/wp-content\/uploads\/2017\/02\/cradle-db-300x183.png\" \/>\n<meta name=\"author\" content=\"3SL\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@threesl\" \/>\n<meta name=\"twitter:site\" content=\"@threesl\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"3SL\" \/>\n\t<meta name=\"twitter:label2\" content=\"Estimated reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.threesl.com\\\/blog\\\/cradle-database\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.threesl.com\\\/blog\\\/cradle-database\\\/\"},\"author\":{\"name\":\"3SL\",\"@id\":\"https:\\\/\\\/www.threesl.com\\\/blog\\\/#\\\/schema\\\/person\\\/749ccd9b2d74303fa8927e06c2af8b0b\"},\"headline\":\"Contents of a Cradle database\",\"datePublished\":\"2017-02-17T12:42:31+00:00\",\"dateModified\":\"2017-05-10T14:34:47+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.threesl.com\\\/blog\\\/cradle-database\\\/\"},\"wordCount\":179,\"publisher\":{\"@id\":\"https:\\\/\\\/www.threesl.com\\\/blog\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/www.threesl.com\\\/blog\\\/cradle-database\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.threesl.com:2958\\\/blog\\\/wp-content\\\/uploads\\\/2017\\\/02\\\/cradle-db-300x183.png\",\"keywords\":[\"Cradle database\",\"cross references \\\/ links\",\"definitions\",\"items\",\"project schema\",\"users\"],\"articleSection\":[\"Articles\"],\"inLanguage\":\"en-GB\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.threesl.com\\\/blog\\\/cradle-database\\\/\",\"url\":\"https:\\\/\\\/www.threesl.com\\\/blog\\\/cradle-database\\\/\",\"name\":\"Contents of a Cradle database - 3SL Blog\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.threesl.com\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.threesl.com\\\/blog\\\/cradle-database\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.threesl.com\\\/blog\\\/cradle-database\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.threesl.com:2958\\\/blog\\\/wp-content\\\/uploads\\\/2017\\\/02\\\/cradle-db-300x183.png\",\"datePublished\":\"2017-02-17T12:42:31+00:00\",\"dateModified\":\"2017-05-10T14:34:47+00:00\",\"description\":\"Contents of a Cradle database showing how the Cradle database is contrucuted and what it consists of. Cradle items, cross references, user profiles etc.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.threesl.com\\\/blog\\\/cradle-database\\\/#breadcrumb\"},\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.threesl.com\\\/blog\\\/cradle-database\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\\\/\\\/www.threesl.com\\\/blog\\\/cradle-database\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.threesl.com:2958\\\/blog\\\/wp-content\\\/uploads\\\/2017\\\/02\\\/cradle-db-300x183.png\",\"contentUrl\":\"https:\\\/\\\/www.threesl.com:2958\\\/blog\\\/wp-content\\\/uploads\\\/2017\\\/02\\\/cradle-db-300x183.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.threesl.com\\\/blog\\\/cradle-database\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.threesl.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Contents of a Cradle database\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.threesl.com\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.threesl.com\\\/blog\\\/\",\"name\":\"3SL Blog\",\"description\":\"From concept to creation\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.threesl.com\\\/blog\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.threesl.com\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-GB\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.threesl.com\\\/blog\\\/#organization\",\"name\":\"3SL\",\"url\":\"https:\\\/\\\/www.threesl.com\\\/blog\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\\\/\\\/www.threesl.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/www.threesl.com\\\/blog\\\/wp-content\\\/uploads\\\/2017\\\/02\\\/3SL_Logo_Medium.png\",\"contentUrl\":\"https:\\\/\\\/www.threesl.com\\\/blog\\\/wp-content\\\/uploads\\\/2017\\\/02\\\/3SL_Logo_Medium.png\",\"width\":152,\"height\":80,\"caption\":\"3SL\"},\"image\":{\"@id\":\"https:\\\/\\\/www.threesl.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"http:\\\/\\\/facebook.com\\\/3SLCradle\",\"https:\\\/\\\/x.com\\\/threesl\"]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.threesl.com\\\/blog\\\/#\\\/schema\\\/person\\\/749ccd9b2d74303fa8927e06c2af8b0b\",\"name\":\"3SL\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/cee8089745b3e7d79c57d621cc634da71def3561fcf40d4932a3e38743e23af0?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/cee8089745b3e7d79c57d621cc634da71def3561fcf40d4932a3e38743e23af0?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/cee8089745b3e7d79c57d621cc634da71def3561fcf40d4932a3e38743e23af0?s=96&d=mm&r=g\",\"caption\":\"3SL\"},\"sameAs\":[\"http:\\\/\\\/www.threesl.com\\\/\",\"https:\\\/\\\/x.com\\\/threesl\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Contents of a Cradle database - 3SL Blog","description":"Contents of a Cradle database showing how the Cradle database is contrucuted and what it consists of. Cradle items, cross references, user profiles etc.","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.threesl.com\/blog\/cradle-database\/","og_locale":"en_GB","og_type":"article","og_title":"Contents of a Cradle database - 3SL Blog","og_description":"Contents of a Cradle database showing how the Cradle database is contrucuted and what it consists of. Cradle items, cross references, user profiles etc.","og_url":"https:\/\/www.threesl.com\/blog\/cradle-database\/","og_site_name":"3SL Blog","article_publisher":"http:\/\/facebook.com\/3SLCradle","article_published_time":"2017-02-17T12:42:31+00:00","article_modified_time":"2017-05-10T14:34:47+00:00","og_image":[{"url":"https:\/\/www.threesl.com:2958\/blog\/wp-content\/uploads\/2017\/02\/cradle-db-300x183.png","type":"","width":"","height":""}],"author":"3SL","twitter_card":"summary_large_image","twitter_creator":"@threesl","twitter_site":"@threesl","twitter_misc":{"Written by":"3SL","Estimated reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.threesl.com\/blog\/cradle-database\/#article","isPartOf":{"@id":"https:\/\/www.threesl.com\/blog\/cradle-database\/"},"author":{"name":"3SL","@id":"https:\/\/www.threesl.com\/blog\/#\/schema\/person\/749ccd9b2d74303fa8927e06c2af8b0b"},"headline":"Contents of a Cradle database","datePublished":"2017-02-17T12:42:31+00:00","dateModified":"2017-05-10T14:34:47+00:00","mainEntityOfPage":{"@id":"https:\/\/www.threesl.com\/blog\/cradle-database\/"},"wordCount":179,"publisher":{"@id":"https:\/\/www.threesl.com\/blog\/#organization"},"image":{"@id":"https:\/\/www.threesl.com\/blog\/cradle-database\/#primaryimage"},"thumbnailUrl":"https:\/\/www.threesl.com:2958\/blog\/wp-content\/uploads\/2017\/02\/cradle-db-300x183.png","keywords":["Cradle database","cross references \/ links","definitions","items","project schema","users"],"articleSection":["Articles"],"inLanguage":"en-GB"},{"@type":"WebPage","@id":"https:\/\/www.threesl.com\/blog\/cradle-database\/","url":"https:\/\/www.threesl.com\/blog\/cradle-database\/","name":"Contents of a Cradle database - 3SL Blog","isPartOf":{"@id":"https:\/\/www.threesl.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.threesl.com\/blog\/cradle-database\/#primaryimage"},"image":{"@id":"https:\/\/www.threesl.com\/blog\/cradle-database\/#primaryimage"},"thumbnailUrl":"https:\/\/www.threesl.com:2958\/blog\/wp-content\/uploads\/2017\/02\/cradle-db-300x183.png","datePublished":"2017-02-17T12:42:31+00:00","dateModified":"2017-05-10T14:34:47+00:00","description":"Contents of a Cradle database showing how the Cradle database is contrucuted and what it consists of. Cradle items, cross references, user profiles etc.","breadcrumb":{"@id":"https:\/\/www.threesl.com\/blog\/cradle-database\/#breadcrumb"},"inLanguage":"en-GB","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.threesl.com\/blog\/cradle-database\/"]}]},{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/www.threesl.com\/blog\/cradle-database\/#primaryimage","url":"https:\/\/www.threesl.com:2958\/blog\/wp-content\/uploads\/2017\/02\/cradle-db-300x183.png","contentUrl":"https:\/\/www.threesl.com:2958\/blog\/wp-content\/uploads\/2017\/02\/cradle-db-300x183.png"},{"@type":"BreadcrumbList","@id":"https:\/\/www.threesl.com\/blog\/cradle-database\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.threesl.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Contents of a Cradle database"}]},{"@type":"WebSite","@id":"https:\/\/www.threesl.com\/blog\/#website","url":"https:\/\/www.threesl.com\/blog\/","name":"3SL Blog","description":"From concept to creation","publisher":{"@id":"https:\/\/www.threesl.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.threesl.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-GB"},{"@type":"Organization","@id":"https:\/\/www.threesl.com\/blog\/#organization","name":"3SL","url":"https:\/\/www.threesl.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/www.threesl.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.threesl.com\/blog\/wp-content\/uploads\/2017\/02\/3SL_Logo_Medium.png","contentUrl":"https:\/\/www.threesl.com\/blog\/wp-content\/uploads\/2017\/02\/3SL_Logo_Medium.png","width":152,"height":80,"caption":"3SL"},"image":{"@id":"https:\/\/www.threesl.com\/blog\/#\/schema\/logo\/image\/"},"sameAs":["http:\/\/facebook.com\/3SLCradle","https:\/\/x.com\/threesl"]},{"@type":"Person","@id":"https:\/\/www.threesl.com\/blog\/#\/schema\/person\/749ccd9b2d74303fa8927e06c2af8b0b","name":"3SL","image":{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/secure.gravatar.com\/avatar\/cee8089745b3e7d79c57d621cc634da71def3561fcf40d4932a3e38743e23af0?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/cee8089745b3e7d79c57d621cc634da71def3561fcf40d4932a3e38743e23af0?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/cee8089745b3e7d79c57d621cc634da71def3561fcf40d4932a3e38743e23af0?s=96&d=mm&r=g","caption":"3SL"},"sameAs":["http:\/\/www.threesl.com\/","https:\/\/x.com\/threesl"]}]}},"modified_by":null,"_links":{"self":[{"href":"https:\/\/www.threesl.com\/blog\/wp-json\/wp\/v2\/posts\/41","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.threesl.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.threesl.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.threesl.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.threesl.com\/blog\/wp-json\/wp\/v2\/comments?post=41"}],"version-history":[{"count":4,"href":"https:\/\/www.threesl.com\/blog\/wp-json\/wp\/v2\/posts\/41\/revisions"}],"predecessor-version":[{"id":650,"href":"https:\/\/www.threesl.com\/blog\/wp-json\/wp\/v2\/posts\/41\/revisions\/650"}],"wp:attachment":[{"href":"https:\/\/www.threesl.com\/blog\/wp-json\/wp\/v2\/media?parent=41"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.threesl.com\/blog\/wp-json\/wp\/v2\/categories?post=41"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.threesl.com\/blog\/wp-json\/wp\/v2\/tags?post=41"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}