{"id":123,"date":"2018-03-25T03:47:00","date_gmt":"2018-03-25T03:47:00","guid":{"rendered":"https:\/\/kindsonthegenius.com\/blog\/2018\/03\/25\/restful-web-services-tutorial-5-create-employee-database-in-ms-sql-server\/"},"modified":"2020-08-22T21:53:37","modified_gmt":"2020-08-22T19:53:37","slug":"restful-web-services-tutorial-5-create-employee-database-in-ms-sql-server","status":"publish","type":"post","link":"https:\/\/kindsonthegenius.com\/blog\/restful-web-services-tutorial-5-create-employee-database-in-ms-sql-server\/","title":{"rendered":"RESTful Web Services Tutorial 5 &#8211; Create Employee Database in MS SQL Server"},"content":{"rendered":"<div style=\"color: #555555; font-size: 18px; line-height: 30px; text-align: justify;\">\n<div style=\"font-family: 'segoe ui';\">\n<p>In this tutorial, we are going to work with MS SQL database to set up our Employees database.<br \/>\nGranted, this lesson is not a REST API lesson, but you need to learn how to store data while working with web services and this is going to be very easy and clear.<\/p>\n<div style=\"clear: both; text-align: center;\"><a style=\"margin-left: 1em; margin-right: 1em;\" href=\"https:\/\/2.bp.blogspot.com\/-mHfsW6NfxbE\/WrcY0CWcPdI\/AAAAAAAABjg\/MEZ3hL5uJf0vvlvZ7I6jEnuPVdyhGP2BQCLcBGAs\/s1600\/Tutorial%2B5-%2BCreate%2Ba%2BDatabase.jpg\"><img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/2.bp.blogspot.com\/-mHfsW6NfxbE\/WrcY0CWcPdI\/AAAAAAAABjg\/MEZ3hL5uJf0vvlvZ7I6jEnuPVdyhGP2BQCLcBGAs\/s320\/Tutorial%2B5-%2BCreate%2Ba%2BDatabase.jpg\" width=\"320\" height=\"184\" border=\"0\" data-original-height=\"709\" data-original-width=\"1230\" \/><\/a><\/div>\n<p>We would cover the following:<\/p>\n<ul>\n<li><a href=\"http:\/\/kindsonthegenius.blogspot.com\/#t1\">Part 1: Download and Install MS SQL Server 2017 Express Edition for free<\/a><\/li>\n<li><a href=\"http:\/\/kindsonthegenius.blogspot.com\/#t2\">Part 2: Create a new database<\/a><\/li>\n<li><a href=\"http:\/\/kindsonthegenius.blogspot.com\/#t3\">Part 3: Create the database tables<\/a><\/li>\n<li><a href=\"http:\/\/kindsonthegenius.blogspot.com\/#t4\">Part 4: Create the Database diagram and Relationships<\/a><\/li>\n<li><a href=\"http:\/\/kindsonthegenius.blogspot.com\/#t5\">Part 5: Notes of Relationships<\/a><\/li>\n<li><a href=\"http:\/\/kindsonthegenius.blogspot.com\/#t6\">Part 6: Next Steps<\/a><\/li>\n<\/ul>\n<p><ins style=\"display: block; text-align: center;\" data-ad-client=\"ca-pub-7041870931346451\" data-ad-format=\"fluid\" data-ad-layout=\"in-article\" data-ad-slot=\"8227894917\"><\/ins><br \/>\n<b><\/b><\/p>\n<h3><b>Part 1: Download and Install MS SQL Server 2017 Express Edition for free<\/b><\/h3>\n<p>MS SQL Server 2017 Express Edition is\u00a0 free version of MS SQL Server that you can download and use for building small applications.<\/p>\n<p>In this tutorial, I used MS SQL Server 2014.<\/p>\n<p>You can download in from this link: <a href=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/sql-server-downloads\" target=\"_blank\" rel=\"nofollow noopener\">https:\/\/www.microsoft.com\/en-us\/sql-server\/sql-server-downloads<\/a><br \/>\nIn this tutorial, I use SQL Server 2014 and it would also work perfectly.<br \/>\nAfter downloading it, follow the instructions to install it in your system. After successfully installing it, you will see SQL Server 2014 Management Studio.<\/p>\n<p>&nbsp;<\/p>\n<h3><b>Part 2: Create a new Database<\/b><\/h3>\n<p>1. Lauch the SQL Server 2014 Management Studio or any other version you have.<br \/>\n2. In the left hand side Right-Click on Databases and Select New Database as shown in <b>Figure 1<\/b><\/p>\n<div style=\"clear: both; text-align: center;\"><a style=\"margin-left: 1em; margin-right: 1em;\" href=\"https:\/\/3.bp.blogspot.com\/-sw2TkAyQX0U\/WrZ00nWikHI\/AAAAAAAABhQ\/OPR_2sKzpbkGpKzQ7SG42y_GibDoMYqJwCPcBGAYYCw\/s1600\/Figure%2B1%2B-%2BNew%2BDatabase.jpg\"><img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/3.bp.blogspot.com\/-sw2TkAyQX0U\/WrZ00nWikHI\/AAAAAAAABhQ\/OPR_2sKzpbkGpKzQ7SG42y_GibDoMYqJwCPcBGAYYCw\/s320\/Figure%2B1%2B-%2BNew%2BDatabase.jpg\" width=\"318\" height=\"320\" border=\"0\" data-original-height=\"864\" data-original-width=\"860\" \/><\/a><\/div>\n<p>&nbsp;<\/p>\n<div style=\"text-align: center;\"><b>Figure 1<\/b>: Create New Database<\/div>\n<p>3. In the Create New Database Wizard Enter the name of the database as EmployeeDB ( you could use any name you want)<\/p>\n<p>&nbsp;<\/p>\n<div style=\"clear: both; text-align: center;\"><a style=\"margin-left: 1em; margin-right: 1em;\" href=\"https:\/\/2.bp.blogspot.com\/-XLz6jgqhNVo\/WrZ1iWmjqEI\/AAAAAAAABhY\/pW4GSN_ybFIbz4MfNU0VrbXu1TJR7UeIwCPcBGAYYCw\/s1600\/Figure%2B2%2B-%2BNew%2BDatabase%2BWizard.jpg\"><img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/2.bp.blogspot.com\/-XLz6jgqhNVo\/WrZ1iWmjqEI\/AAAAAAAABhY\/pW4GSN_ybFIbz4MfNU0VrbXu1TJR7UeIwCPcBGAYYCw\/s320\/Figure%2B2%2B-%2BNew%2BDatabase%2BWizard.jpg\" width=\"320\" height=\"289\" border=\"0\" data-original-height=\"695\" data-original-width=\"767\" \/><\/a><\/div>\n<div style=\"text-align: center;\"><b>Figure 2<\/b>: New Database Wizard<\/div>\n<p>4. Click OK after you have entered the name of he database<br \/>\n5. Now expand Databases on the left pane, and you can see the new database you just created<\/p>\n<p><i>To create a table<\/i><br \/>\n1. Expand the database you created in the previous step<br \/>\n2. Right-Click on Table and Select Table as shown in <b>Figure 3<\/b><\/p>\n<div style=\"clear: both; text-align: center;\"><a style=\"margin-left: 1em; margin-right: 1em;\" href=\"https:\/\/3.bp.blogspot.com\/-8ZEZffIY2v4\/WrbS2GPWjoI\/AAAAAAAABho\/RjvVwcP4ZCAiCiO-JyqriREsnsyP42HFwCPcBGAYYCw\/s1600\/Figure%2B3%2B-%2BCreate%2BNew%2BTable.jpg\"><img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/3.bp.blogspot.com\/-8ZEZffIY2v4\/WrbS2GPWjoI\/AAAAAAAABho\/RjvVwcP4ZCAiCiO-JyqriREsnsyP42HFwCPcBGAYYCw\/s320\/Figure%2B3%2B-%2BCreate%2BNew%2BTable.jpg\" width=\"222\" height=\"320\" border=\"0\" data-original-height=\"847\" data-original-width=\"588\" \/><\/a><\/div>\n<p>&nbsp;<\/p>\n<div style=\"text-align: center;\"><b>Figure 3<\/b>: Creating a New Table<\/div>\n<p>The New Table window appears as shown in <b>Figure 4<\/b>. Now you can define the field that you table would contain (field is same as column)<\/p>\n<p>3. Define the table according the the data provided against each of the tables. Under Column Name, enter the name of the column and under Data Type, select the data type of the column.<\/p>\n<div style=\"clear: both; text-align: center;\"><a style=\"margin-left: 1em; margin-right: 1em;\" href=\"https:\/\/2.bp.blogspot.com\/-gdmCS-mBdnM\/WrcJCX-ApNI\/AAAAAAAABig\/50E7PRZPa94Zp_R-opjq6CIOfjmFp87CwCLcBGAs\/s1600\/Figure%2B4%2B-%2BNew%2BTable%2BDefinition.jpg\"><img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/2.bp.blogspot.com\/-gdmCS-mBdnM\/WrcJCX-ApNI\/AAAAAAAABig\/50E7PRZPa94Zp_R-opjq6CIOfjmFp87CwCLcBGAs\/s400\/Figure%2B4%2B-%2BNew%2BTable%2BDefinition.jpg\" width=\"400\" height=\"331\" border=\"0\" data-original-height=\"697\" data-original-width=\"837\" \/><\/a><\/div>\n<div style=\"clear: both; text-align: center;\"><b>Figure 4:<\/b> New Table Definition<\/div>\n<p>&nbsp;<\/p>\n<h3><b>Part 3: Create the Database Tables<\/b><\/h3>\n<p>You need to create the following tables in the database. Here we are going to use four tables just to keep it simple.<\/p>\n<ul>\n<li>Employees Table<\/li>\n<li>Departments Table<\/li>\n<li>Countries Table<\/li>\n<li>Addresses Table<\/li>\n<\/ul>\n<p><ins style=\"display: block; text-align: center;\" data-ad-client=\"ca-pub-7041870931346451\" data-ad-format=\"fluid\" data-ad-layout=\"in-article\" data-ad-slot=\"8227894917\"><\/ins> <i>Employees Table<\/i>: This table would be the master table that holds the records of all the employees. The Employees table is related to the other Departments table, the Countries table and the Addresses table throught the DepartmentId field, the CountryId field and the AddressId field respectively.<\/p>\n<ul>\n<li style=\"list-style-type: none\">\n<ul>\n<li>Id (int)<\/li>\n<li>Firstname (varchar(50))<\/li>\n<li>Lastname (varchar(50))<\/li>\n<li>Phone\u00a0 (varchar(50))<\/li>\n<li>Email\u00a0 (varchar(50))<\/li>\n<li>CountryId (int)<\/li>\n<li>Dateofbirth (date)<\/li>\n<li>DepartmentId (int)<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<div style=\"text-align: left;\"><\/div>\n<ul>\n<li>AddressId (int)<\/li>\n<\/ul>\n<p>After defining the Employees table save it with the name Employees. The table should look like shown in <b>Figure 5<\/b><\/p>\n<div style=\"clear: both; text-align: center;\"><a style=\"margin-left: 1em; margin-right: 1em;\" href=\"https:\/\/1.bp.blogspot.com\/-PW5nCn_InDo\/WrcJPr3kATI\/AAAAAAAABik\/ETS13Dq55oM7cudt6Qb2hr62v1UcYoYCQCLcBGAs\/s1600\/Figure%2B5%2B-%2BEmployee%2BTable%2BDefinition.jpg\"><img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/1.bp.blogspot.com\/-PW5nCn_InDo\/WrcJPr3kATI\/AAAAAAAABik\/ETS13Dq55oM7cudt6Qb2hr62v1UcYoYCQCLcBGAs\/s320\/Figure%2B5%2B-%2BEmployee%2BTable%2BDefinition.jpg\" width=\"320\" height=\"262\" border=\"0\" data-original-height=\"634\" data-original-width=\"774\" \/>\u00a0<\/a><\/div>\n<div style=\"clear: both; text-align: center;\"><b>Figure 5: <\/b>Employees Table Definition<\/div>\n<p><i>Departments Table<\/i>: This table holds a records of the departments in the company which employees may be assigned to. The fields in the Departments table are:<\/p>\n<ul>\n<li>Id (int)<\/li>\n<li>Name (varchar(50))<\/li>\n<li>ManagerId (int)<\/li>\n<\/ul>\n<p><i>Countries Table<\/i>: This table holds a list of countries as well as the country code, the capital and the nationality of that country.<\/p>\n<ul>\n<li>Id (int)<\/li>\n<li>Code (varchar(3))<\/li>\n<li>Name (varchar(50))<\/li>\n<li>Capital (varchar(50))<\/li>\n<li>Nationality (varchar(50))<\/li>\n<\/ul>\n<p><i>Addresses Table:<\/i> This table holds a list of addresses. The address of the employees are stored in this table. We store address in a separate table since there could be more than one employee staying in the same address. So instead of entering address for for each employee record, we have the address stored once, and the employee record relates to it using the AddressId.<\/p>\n<ul>\n<li>Id (int)<\/li>\n<li>Street (varchar(50))<\/li>\n<li>Number (varchar(50))<\/li>\n<li>City (varchar(50))<\/li>\n<li>Region (varchar(50))<\/li>\n<li>CountryId (int)<\/li>\n<\/ul>\n<p><b><br \/>\n<\/b><b><\/b><\/p>\n<h3><b>Part 4: Create the Database Diagram and the Relationships<\/b><\/h3>\n<p>You need to create the relationships between the tables.<br \/>\nFor example the Employee table is related to the Department table through the DepartmentID column<br \/>\nIn this case:<br \/>\nDepartmentID is a Foreign Key (FK) in the Employees table<\/p>\n<p>To create relationships, follow the steps below<\/p>\n<p>1. Expand Databases<br \/>\n2. Expand the EmployeeDB database<br \/>\n3. Expand Database Diagrams. If you try to expand it, it would give a warning, which asks if you would like to create the diagrams.This is shown in <b>Figure 6<\/b>.<\/p>\n<div style=\"clear: both; text-align: center;\"><a style=\"margin-left: 1em; margin-right: 1em;\" href=\"https:\/\/3.bp.blogspot.com\/-3A5hiX_5hXg\/Wrbim-kEYvI\/AAAAAAAABiA\/xsuzamf72Zwd1YnAc5QAz6FbUISAyIhCACPcBGAYYCw\/s1600\/Figure%2B6%2B-%2BCreate%2BDatabase%2BDiagram.jpg\"><img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/3.bp.blogspot.com\/-3A5hiX_5hXg\/Wrbim-kEYvI\/AAAAAAAABiA\/xsuzamf72Zwd1YnAc5QAz6FbUISAyIhCACPcBGAYYCw\/s320\/Figure%2B6%2B-%2BCreate%2BDatabase%2BDiagram.jpg\" width=\"320\" height=\"229\" border=\"0\" data-original-height=\"844\" data-original-width=\"1175\" \/>\u00a0<\/a><\/div>\n<div style=\"clear: both; text-align: center;\"><b>Figure 6:<\/b> Adding Database Diagram<\/div>\n<p>4. Click on Yes. Now, the Database diagramming is enabled and you can add new diagram.<\/p>\n<p>5. Rigtht-Click on Database Diagram and choose New Database Diagram. The Add Table dialog box is displayed containing a list of all your tables as shown in <b>Figure 7.<\/b><\/p>\n<div style=\"clear: both; text-align: center;\"><a style=\"margin-left: 1em; margin-right: 1em;\" href=\"https:\/\/4.bp.blogspot.com\/-hM2TEiQt2hk\/Wrbk1V1y4zI\/AAAAAAAABiQ\/xdSI7piIVvwEqlqu2PVT2Z2yoI5gxuYQgCPcBGAYYCw\/s1600\/Figure%2B7-%2BAdd%2BTable%2Bto%2BDiagram%2BDialog.jpg\"><img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/4.bp.blogspot.com\/-hM2TEiQt2hk\/Wrbk1V1y4zI\/AAAAAAAABiQ\/xdSI7piIVvwEqlqu2PVT2Z2yoI5gxuYQgCPcBGAYYCw\/s400\/Figure%2B7-%2BAdd%2BTable%2Bto%2BDiagram%2BDialog.jpg\" width=\"400\" height=\"276\" border=\"0\" data-original-height=\"769\" data-original-width=\"1109\" \/>\u00a0<\/a><\/div>\n<div style=\"clear: both; text-align: center;\"><b>Figure 7:<\/b> Add Table Dialog Box<\/div>\n<p>6. Then close the Add Table dialog box. Now all the tables are added to the diagram.<\/p>\n<p>7. Drag the tables to rearrange it to look like <b>Figure 8<\/b><\/p>\n<div style=\"clear: both; text-align: center;\"><a style=\"margin-left: 1em; margin-right: 1em;\" href=\"https:\/\/4.bp.blogspot.com\/-yESgDtu9yNo\/WrcLKjV_wdI\/AAAAAAAABi0\/c39CFB7qYnscKMr5ugCfi7HDjxG6v1jkgCLcBGAs\/s1600\/Figure%2B8%2B-%2B%2BDiagrams%2Bwith%2BTable%2BArranged.jpg\"><img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/4.bp.blogspot.com\/-yESgDtu9yNo\/WrcLKjV_wdI\/AAAAAAAABi0\/c39CFB7qYnscKMr5ugCfi7HDjxG6v1jkgCLcBGAs\/s640\/Figure%2B8%2B-%2B%2BDiagrams%2Bwith%2BTable%2BArranged.jpg\" width=\"640\" height=\"432\" border=\"0\" data-original-height=\"635\" data-original-width=\"938\" \/><\/a><\/div>\n<div style=\"clear: both; text-align: center;\"><b>Figure 8<\/b>: Database diagram with arranged tables<\/div>\n<p>8. Save the Diagram with a name (I used EmployeeDiagram)<\/p>\n<p><ins style=\"display: block; text-align: center;\" data-ad-client=\"ca-pub-7041870931346451\" data-ad-format=\"fluid\" data-ad-layout=\"in-article\" data-ad-slot=\"8227894917\"><\/ins> <i>Add the Relationships<\/i><br \/>\nYou create relationship by draging the primary key(PK) on one table to the corresponding foreign key (FK) in the relatedt table.<\/p>\n<p>For example, to create a relationship between the Employees table and the Departments table, drag the Id from the Departments table and place it on the DepartmentId in the Employee Table<br \/>\nIf you do this correctly, the dialog box appears as shown in <b>Figure 9<\/b><\/p>\n<div style=\"clear: both; text-align: center;\"><a style=\"margin-left: 1em; margin-right: 1em;\" href=\"https:\/\/1.bp.blogspot.com\/-21yId2DKmmQ\/WrcL09k26cI\/AAAAAAAABi8\/_z-42y71zxguaDQg2sfM3XdiQ1hyi5MSACLcBGAs\/s1600\/Figure%2B9%2B-%2B%2BCreating%2BRelationships%2B1.jpg\"><img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/1.bp.blogspot.com\/-21yId2DKmmQ\/WrcL09k26cI\/AAAAAAAABi8\/_z-42y71zxguaDQg2sfM3XdiQ1hyi5MSACLcBGAs\/s320\/Figure%2B9%2B-%2B%2BCreating%2BRelationships%2B1.jpg\" width=\"320\" height=\"241\" border=\"0\" data-original-height=\"349\" data-original-width=\"463\" \/>\u00a0<\/a><\/div>\n<div style=\"clear: both; text-align: center;\"><b>Figure 9: <\/b>Creating Relationships<\/div>\n<p>A second dialog box appears as shown in Figure 10.<br \/>\nClick OK again in this second dialog box<\/p>\n<div style=\"clear: both; text-align: center;\"><a style=\"margin-left: 1em; margin-right: 1em;\" href=\"https:\/\/4.bp.blogspot.com\/-kW4slqImzbo\/WrcMJM4pgmI\/AAAAAAAABjA\/8GMHZGw6K0Qg1PRMHvaRCsFalpdsh5LDACLcBGAs\/s1600\/Figure%2B10%2B-%2BCreating%2BRelationships%2B2.jpg\"><img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/4.bp.blogspot.com\/-kW4slqImzbo\/WrcMJM4pgmI\/AAAAAAAABjA\/8GMHZGw6K0Qg1PRMHvaRCsFalpdsh5LDACLcBGAs\/s320\/Figure%2B10%2B-%2BCreating%2BRelationships%2B2.jpg\" width=\"320\" height=\"203\" border=\"0\" data-original-height=\"359\" data-original-width=\"565\" \/>\u00a0<\/a><\/div>\n<div style=\"clear: both; text-align: center;\"><b>Figure 10<\/b>: Foreign Key Relationship<\/div>\n<p>Repeat the same thing for all the relationship between all the tables.<br \/>\nAt the end, the final diagram would be as shown in <b>Figure 11<\/b><\/p>\n<p>&nbsp;<\/p>\n<div style=\"clear: both; text-align: center;\"><a style=\"margin-left: 1em; margin-right: 1em;\" href=\"https:\/\/2.bp.blogspot.com\/-lkIllZXNDl0\/WrcM__-JL0I\/AAAAAAAABjQ\/M7vsJknhI20f-II10SoILi1qmFbw51fMgCLcBGAs\/s1600\/Figure%2B11%2B-%2BFinal%2BRelationship%2BDiagram.jpg\"><img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/2.bp.blogspot.com\/-lkIllZXNDl0\/WrcM__-JL0I\/AAAAAAAABjQ\/M7vsJknhI20f-II10SoILi1qmFbw51fMgCLcBGAs\/s640\/Figure%2B11%2B-%2BFinal%2BRelationship%2BDiagram.jpg\" width=\"640\" height=\"432\" border=\"0\" data-original-height=\"632\" data-original-width=\"934\" \/><\/a><\/div>\n<div style=\"clear: both; text-align: center;\"><b>Figure 11<\/b>: Final Relationships Diagram<\/div>\n<p>&nbsp;<\/p>\n<h3><b>Part 5: Notes on Relationships<\/b><\/h3>\n<p>The type of relationship we created between the Departments table and the Employees table is an example of one-to-many relationship. This means one department to many employees. That is, more than one employee can have the same DepartmentId.<br \/>\nExamine the arrow connecting the two table. One side of the arrow is a key, this is the &#8216;one&#8217; side&#8217;. The other side of the arrow is an &#8216;infinity&#8217; symbol, this is the many side.<br \/>\nAlso know that there are other types of relationships which we are not going to cover here. They are:<\/p>\n<ul>\n<li>one-to-one<\/li>\n<li>many-to-many<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<h3><b>Part 6: Next Steps<\/b><\/h3>\n<p>Now you have successfully created that database we need for our REST API. So I could say congrats\ud83d\ude03\ud83d\ude03\ud83d\ude03\ud83d\ude03\ud83d\ude03<\/p>\n<p>I still need to teach you one more thing. How to generate the corresponding class diagram in Visual Studio. This is what we are going to do in the next tutorial.<\/p>\n<p>Additionally, we would learn a bit about Entity Framework which allows us to sync out database with visual studio and have updates made automatically from Visual Studio without having to open SQL Server.<\/p>\n<p>For now, I would like to thank you for reading.<\/p>\n<p>If you have any challenge following this tutorial or you have any observation, do mention it in the comment box below.<\/p>\n<p><ins style=\"display: block; text-align: center;\" data-ad-client=\"ca-pub-7041870931346451\" data-ad-format=\"fluid\" data-ad-layout=\"in-article\" data-ad-slot=\"8227894917\"><\/ins><br \/>\n<ins style=\"display: block; text-align: center;\" data-ad-client=\"ca-pub-7041870931346451\" data-ad-format=\"fluid\" data-ad-layout=\"in-article\" data-ad-slot=\"8227894917\"><\/ins><\/p>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>In this tutorial, we are going to work with MS SQL database to set up our Employees database. Granted, this lesson is not a REST &hellip; <\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_mi_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0},"categories":[289],"tags":[],"_links":{"self":[{"href":"https:\/\/kindsonthegenius.com\/blog\/wp-json\/wp\/v2\/posts\/123"}],"collection":[{"href":"https:\/\/kindsonthegenius.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/kindsonthegenius.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/kindsonthegenius.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/kindsonthegenius.com\/blog\/wp-json\/wp\/v2\/comments?post=123"}],"version-history":[{"count":1,"href":"https:\/\/kindsonthegenius.com\/blog\/wp-json\/wp\/v2\/posts\/123\/revisions"}],"predecessor-version":[{"id":1542,"href":"https:\/\/kindsonthegenius.com\/blog\/wp-json\/wp\/v2\/posts\/123\/revisions\/1542"}],"wp:attachment":[{"href":"https:\/\/kindsonthegenius.com\/blog\/wp-json\/wp\/v2\/media?parent=123"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/kindsonthegenius.com\/blog\/wp-json\/wp\/v2\/categories?post=123"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kindsonthegenius.com\/blog\/wp-json\/wp\/v2\/tags?post=123"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}