Our client owns a small business and is currently using Microsoft excel to keep track of his inventory and orders. He finds it cumbersome as he has to access multiple files to enter and retrieve the data. So we created and API by making sure that our client has all the data that he requires in one system. \nAfter communicating with our client, we decided to have 13 tables with the following attributes:
\n1)ITEM: Item_code, Man_name, Storage_id
\n2)ITEM_COLOURS: Item_code, Colour
\n3)MANUFACTURER: Name, Contact_no, Address
\n4)STORAGE: Storage_id, Quantity, Location, Admin_id
\n5)SUPPLIED_THROUGH: Item_code, Order_no, Storage_id
\n6)CUSTOMER: Customer_id, Name, Email, Phone
\n7)PAYMENT_DETAILS: Customer_id, Billing_Address, Credit, Cash_on_delivery
\n8)ADMIN: Admin_id, Name, Email
\n9)CONTACTS: Admin_id, Man_name
\n10)ORDER: Order_no, Order_date, Sale_price, Admin_id, Ship_method, Ship_date Courier_name, Customer_id
\n11)ORDER_ITEM: Order_no, Item_code, Quantity, Price
\n12)COURIER: Name, Branch
\n13)DELIVERS_TO: Customer_id, Courier_name
\nAll these tables have the basic retrieve, delete and update functionalities. All the keys for each table are unique.
\n","schema":"https://schema.getpostman.com/json/collection/v2.0.0/collection.json","toc":[],"owner":"13836687","collectionId":"36f523f1-8033-41d4-b936-56b1ac8ccaee","publishedId":"TVspjUp7","public":true,"customColor":{"top-bar":"FFFFFF","right-sidebar":"303030","highlight":"EF5B25"},"publishDate":"2020-12-15T03:13:25.000Z"},"item":[{"name":"ITEM","item":[{"name":"Populating the table","id":"55a63083-3b37-41d8-a8ba-6215665edcf4","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"POST","header":[],"body":{"mode":"raw","raw":"{\n \"Name\":\"Lego\",\n \"Man_name\":\"The Lego Group\",\n \"Storage_id\":\"03\"\n}","options":{"raw":{"language":"json"}}},"url":"http://localhost:8000/api/item/?Name=char&Man_name=char&Storage_id=int","description":"Adding the tuples to the table.
\n","urlObject":{"protocol":"http","port":"8000","path":["api","item",""],"host":["localhost"],"query":[{"description":{"content":"Name of item
\n","type":"text/plain"},"key":"Name","value":"char"},{"description":{"content":"Manufacturer of item
\n","type":"text/plain"},"key":"Man_name","value":"char"},{"description":{"content":"id of storage where item is stored
\n","type":"text/plain"},"key":"Storage_id","value":"int"}],"variable":[]}},"response":[{"id":"490519ae-7a99-4ba4-9a96-4c38334b5f95","name":"Populating the table","originalRequest":{"method":"POST","header":[],"body":{"mode":"raw","raw":"{\n \"Name\":\"Pokemon Card\",\n \"Man_name\":\"Pokemon\",\n \"Storage_id\":\"02\"\n}","options":{"raw":{"language":"json"}}},"url":"http://localhost:8000/api/item/"},"status":"Created","code":201,"_postman_previewlanguage":"html","header":[{"key":"Date","value":"Mon, 14 Dec 2020 23:20:35 GMT"},{"key":"Server","value":"WSGIServer/0.2 CPython/3.9.0"},{"key":"Content-Type","value":"text/html; charset=utf-8"},{"key":"Location","value":"/api/item/6/"},{"key":"Vary","value":"Accept"},{"key":"X-Frame-Options","value":"DENY"},{"key":"Content-Length","value":"0"},{"key":"X-Content-Type-Options","value":"nosniff"},{"key":"Referrer-Policy","value":"same-origin"}],"cookie":[],"responseTime":null,"body":null},{"id":"c1fc440d-05a6-4102-8191-94a2734b5c5a","name":"Populating the table","originalRequest":{"method":"POST","header":[],"body":{"mode":"raw","raw":"{\n \"Name\":\"Lego\",\n \"Man_name\":\"The Lego Group\",\n \"Storage_id\":\"03\"\n}","options":{"raw":{"language":"json"}}},"url":"http://localhost:8000/api/item/"},"status":"Created","code":201,"_postman_previewlanguage":"html","header":[{"key":"Date","value":"Mon, 14 Dec 2020 23:21:47 GMT"},{"key":"Server","value":"WSGIServer/0.2 CPython/3.9.0"},{"key":"Content-Type","value":"text/html; charset=utf-8"},{"key":"Location","value":"/api/item/7/"},{"key":"Vary","value":"Accept"},{"key":"X-Frame-Options","value":"DENY"},{"key":"Content-Length","value":"0"},{"key":"X-Content-Type-Options","value":"nosniff"},{"key":"Referrer-Policy","value":"same-origin"}],"cookie":[],"responseTime":null,"body":null}],"_postman_id":"55a63083-3b37-41d8-a8ba-6215665edcf4"},{"name":"Reteiving the data","id":"ae7ff4f1-ce73-4451-ab66-606543dd6db2","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"GET","header":[],"url":"http://localhost:8000/api/item/","description":"Getting the contents of the table.
\n","urlObject":{"protocol":"http","port":"8000","path":["api","item",""],"host":["localhost"],"query":[],"variable":[]}},"response":[{"id":"37c557ce-ee94-4602-8a24-7448315ae825","name":"Reteiving the data","originalRequest":{"method":"GET","header":[],"url":"http://localhost:8000/api/item/"},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"Date","value":"Mon, 14 Dec 2020 23:25:31 GMT"},{"key":"Server","value":"WSGIServer/0.2 CPython/3.9.0"},{"key":"Content-Type","value":"application/json"},{"key":"Vary","value":"Accept"},{"key":"Cache-Control","value":"no-cache"},{"key":"X-Frame-Options","value":"DENY"},{"key":"Content-Length","value":"312"},{"key":"X-Content-Type-Options","value":"nosniff"},{"key":"Referrer-Policy","value":"same-origin"}],"cookie":[],"responseTime":null,"body":"{\n \"meta\": {\n \"limit\": 20,\n \"next\": null,\n \"offset\": 0,\n \"previous\": null,\n \"total_count\": 2\n },\n \"objects\": [\n {\n \"Man_name\": \"Pokemon\",\n \"Name\": \"Pokemon Card\",\n \"Storage_id\": 2,\n \"id\": 6,\n \"resource_uri\": \"/api/item/6/\"\n },\n {\n \"Man_name\": \"The Lego Group\",\n \"Name\": \"Lego\",\n \"Storage_id\": 3,\n \"id\": 7,\n \"resource_uri\": \"/api/item/7/\"\n }\n ]\n}"}],"_postman_id":"ae7ff4f1-ce73-4451-ab66-606543dd6db2"},{"name":"Change a tuple","id":"46f57cfc-9bfb-418b-b1a4-11faf182605d","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"PUT","header":[],"body":{"mode":"raw","raw":"{\n \"Name\":\"Lego\",\n \"Man_name\":\"The Lego Maker\",\n \"Storage_id\":\"01\"\n}","options":{"raw":{"language":"json"}}},"url":"http://localhost:8000/api/item/7/","urlObject":{"protocol":"http","port":"8000","path":["api","item","7",""],"host":["localhost"],"query":[],"variable":[]}},"response":[{"id":"cef9057f-fd3b-4f25-97cf-9593343375f2","name":"Change a tuple","originalRequest":{"method":"PUT","header":[],"body":{"mode":"raw","raw":"{\n \"Name\":\"Lego\",\n \"Man_name\":\"The Lego Maker\",\n \"Storage_id\":\"01\"\n}","options":{"raw":{"language":"json"}}},"url":"http://localhost:8000/api/item/7/"},"status":"No Content","code":204,"_postman_previewlanguage":"plain","header":[{"key":"Date","value":"Mon, 14 Dec 2020 23:27:45 GMT"},{"key":"Server","value":"WSGIServer/0.2 CPython/3.9.0"},{"key":"Vary","value":"Accept"},{"key":"X-Frame-Options","value":"DENY"},{"key":"Content-Length","value":"0"},{"key":"X-Content-Type-Options","value":"nosniff"},{"key":"Referrer-Policy","value":"same-origin"}],"cookie":[],"responseTime":null,"body":null}],"_postman_id":"46f57cfc-9bfb-418b-b1a4-11faf182605d"},{"name":"Delete a tuple","id":"b428fb59-da73-463f-87ef-e02280362b61","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"DELETE","header":[],"url":"http://localhost:8000/api/item/6/","urlObject":{"protocol":"http","port":"8000","path":["api","item","6",""],"host":["localhost"],"query":[],"variable":[]}},"response":[{"id":"4c1dc66a-a63d-450a-9182-0c61efd66ffc","name":"Delete a tuple","originalRequest":{"method":"DELETE","header":[],"url":"http://localhost:8000/api/item/6/"},"status":"Not Found","code":404,"_postman_previewlanguage":"html","header":[{"key":"Date","value":"Mon, 14 Dec 2020 23:29:40 GMT"},{"key":"Server","value":"WSGIServer/0.2 CPython/3.9.0"},{"key":"Content-Type","value":"text/html; charset=utf-8"},{"key":"Vary","value":"Accept"},{"key":"X-Frame-Options","value":"DENY"},{"key":"Content-Length","value":"0"},{"key":"X-Content-Type-Options","value":"nosniff"},{"key":"Referrer-Policy","value":"same-origin"}],"cookie":[],"responseTime":null,"body":null}],"_postman_id":"b428fb59-da73-463f-87ef-e02280362b61"},{"name":"Get Result","id":"ae52972f-e2ef-4fc6-ae2f-2ba98ad986a3","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"GET","header":[],"url":"http://localhost:8000/api/item/","urlObject":{"protocol":"http","port":"8000","path":["api","item",""],"host":["localhost"],"query":[],"variable":[]}},"response":[{"id":"85e0d206-ccf8-4f83-85c4-1f367af09db4","name":"Get Result","originalRequest":{"method":"GET","header":[],"url":"http://localhost:8000/api/item/"},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"Date","value":"Mon, 14 Dec 2020 23:30:21 GMT"},{"key":"Server","value":"WSGIServer/0.2 CPython/3.9.0"},{"key":"Content-Type","value":"application/json"},{"key":"Vary","value":"Accept"},{"key":"Cache-Control","value":"no-cache"},{"key":"X-Frame-Options","value":"DENY"},{"key":"Content-Length","value":"205"},{"key":"X-Content-Type-Options","value":"nosniff"},{"key":"Referrer-Policy","value":"same-origin"}],"cookie":[],"responseTime":null,"body":"{\n \"meta\": {\n \"limit\": 20,\n \"next\": null,\n \"offset\": 0,\n \"previous\": null,\n \"total_count\": 1\n },\n \"objects\": [\n {\n \"Man_name\": \"The Lego Maker\",\n \"Name\": \"Lego\",\n \"Storage_id\": 1,\n \"id\": 7,\n \"resource_uri\": \"/api/item/7/\"\n }\n ]\n}"}],"_postman_id":"ae52972f-e2ef-4fc6-ae2f-2ba98ad986a3"}],"id":"67eacfc2-3094-4f85-a86a-9ee47f6c24ee","description":"This table includes all the attributes for the ITEM table. The attributes are: Item_code, Man_name, Storage_id.
\n","_postman_id":"67eacfc2-3094-4f85-a86a-9ee47f6c24ee"},{"name":"ITEM_COLOURS","item":[{"name":"Populating the table","id":"a1c2191c-8cd6-434a-ba98-e9c6d022a9b1","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"POST","header":[],"body":{"mode":"raw","raw":"{\n \"Item_code\": \"02\",\n \"Colour\":\"Red\"\n}","options":{"raw":{"language":"json"}}},"url":"http://localhost:8000/api/item_colours//?Item_code=int&Colour=char","urlObject":{"protocol":"http","port":"8000","path":["api","item_colours","",""],"host":["localhost"],"query":[{"description":{"content":"code of the item
\n","type":"text/plain"},"key":"Item_code","value":"int"},{"description":{"content":"colour of item
\n","type":"text/plain"},"key":"Colour","value":"char"}],"variable":[]}},"response":[{"id":"42ee9e4f-7ac2-4bc1-8c02-87f97a9a5496","name":"Populating the table","originalRequest":{"method":"POST","header":[],"body":{"mode":"raw","raw":"{\n \"Item_code\": \"01\",\n \"Colour\":\"Blue\"\n}","options":{"raw":{"language":"json"}}},"url":"http://localhost:8000/api/item_colours/"},"status":"Created","code":201,"_postman_previewlanguage":"html","header":[{"key":"Date","value":"Mon, 14 Dec 2020 23:38:02 GMT"},{"key":"Server","value":"WSGIServer/0.2 CPython/3.9.0"},{"key":"Content-Type","value":"text/html; charset=utf-8"},{"key":"Location","value":"/api/item_colours/2/"},{"key":"Vary","value":"Accept"},{"key":"X-Frame-Options","value":"DENY"},{"key":"Content-Length","value":"0"},{"key":"X-Content-Type-Options","value":"nosniff"},{"key":"Referrer-Policy","value":"same-origin"}],"cookie":[],"responseTime":null,"body":null}],"_postman_id":"a1c2191c-8cd6-434a-ba98-e9c6d022a9b1"},{"name":"Retreiving the data","id":"ae0d4092-5597-4d06-8347-0c950e0c0805","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"GET","header":[],"url":"http://localhost:8000/api/item_colours","urlObject":{"protocol":"http","port":"8000","path":["api","item_colours"],"host":["localhost"],"query":[],"variable":[]}},"response":[{"id":"5b260c7c-c72d-4ac2-ad5f-35f2bef21b32","name":"Retreiving the data","originalRequest":{"method":"GET","header":[],"url":"http://localhost:8000/api/item_colours/"},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"Date","value":"Mon, 14 Dec 2020 23:39:15 GMT"},{"key":"Server","value":"WSGIServer/0.2 CPython/3.9.0"},{"key":"Content-Type","value":"application/json"},{"key":"Vary","value":"Accept"},{"key":"Cache-Control","value":"no-cache"},{"key":"X-Frame-Options","value":"DENY"},{"key":"Content-Length","value":"268"},{"key":"X-Content-Type-Options","value":"nosniff"},{"key":"Referrer-Policy","value":"same-origin"}],"cookie":[],"responseTime":null,"body":"{\n \"meta\": {\n \"limit\": 20,\n \"next\": null,\n \"offset\": 0,\n \"previous\": null,\n \"total_count\": 2\n },\n \"objects\": [\n {\n \"Colour\": \"Blue\",\n \"id\": 1,\n \"resource_uri\": \"/api/item_colours/2/\"\n },\n {\n \"Colour\": \"Red\",\n \"id\": 2,\n \"resource_uri\": \"/api/item_colours/3/\"\n }\n ]\n}"}],"_postman_id":"ae0d4092-5597-4d06-8347-0c950e0c0805"},{"name":"Change tuple","id":"4bf65384-f254-4f25-bfd6-d7ee42138a1d","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"PUT","header":[],"body":{"mode":"raw","raw":"{\n \"Item_code\": \"02\",\n \"Colour\":\"Green\"\n}","options":{"raw":{"language":"json"}}},"url":"http://localhost:8000/api/item_colours/2/","urlObject":{"protocol":"http","port":"8000","path":["api","item_colours","2",""],"host":["localhost"],"query":[],"variable":[]}},"response":[{"id":"a07180f1-9481-45ef-a10a-f75f9c073d6a","name":"Change tuple","originalRequest":{"method":"PUT","header":[],"body":{"mode":"raw","raw":"{\n \"Item_code\": \"02\",\n \"Colour\":\"Green\"\n}","options":{"raw":{"language":"json"}}},"url":"http://localhost:8000/api/item_colours/2/"},"status":"No Content","code":204,"_postman_previewlanguage":"plain","header":[{"key":"Date","value":"Mon, 14 Dec 2020 23:42:36 GMT"},{"key":"Server","value":"WSGIServer/0.2 CPython/3.9.0"},{"key":"Vary","value":"Accept"},{"key":"X-Frame-Options","value":"DENY"},{"key":"Content-Length","value":"0"},{"key":"X-Content-Type-Options","value":"nosniff"},{"key":"Referrer-Policy","value":"same-origin"}],"cookie":[],"responseTime":null,"body":null}],"_postman_id":"4bf65384-f254-4f25-bfd6-d7ee42138a1d"},{"name":"Delete a Tuple","id":"2937e46b-d974-4e6e-b599-76688fa7c595","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"DELETE","header":[],"url":"http://localhost:8000/api/item_colours/3/","urlObject":{"protocol":"http","port":"8000","path":["api","item_colours","3",""],"host":["localhost"],"query":[],"variable":[]}},"response":[{"id":"82f52f09-fc7f-4c89-a8ea-eb90698a7781","name":"Delete a Tuple","originalRequest":{"method":"DELETE","header":[],"url":"http://localhost:8000/api/item_colours/3/"},"status":"No Content","code":204,"_postman_previewlanguage":"plain","header":[{"key":"Date","value":"Mon, 14 Dec 2020 23:43:51 GMT"},{"key":"Server","value":"WSGIServer/0.2 CPython/3.9.0"},{"key":"Vary","value":"Accept"},{"key":"X-Frame-Options","value":"DENY"},{"key":"Content-Length","value":"0"},{"key":"X-Content-Type-Options","value":"nosniff"},{"key":"Referrer-Policy","value":"same-origin"}],"cookie":[],"responseTime":null,"body":null}],"_postman_id":"2937e46b-d974-4e6e-b599-76688fa7c595"},{"name":"Get Result","id":"72c43ae0-b444-4d44-b835-76d48a478849","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"GET","header":[],"url":"http://localhost:8000/api/item_colours/","urlObject":{"protocol":"http","port":"8000","path":["api","item_colours",""],"host":["localhost"],"query":[],"variable":[]}},"response":[{"id":"61f718b4-b4b2-47b2-a00f-6c6f9faf3edc","name":"Get Result","originalRequest":{"method":"GET","header":[],"url":"http://localhost:8000/api/item_colours/"},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"Date","value":"Mon, 14 Dec 2020 23:44:22 GMT"},{"key":"Server","value":"WSGIServer/0.2 CPython/3.9.0"},{"key":"Content-Type","value":"application/json"},{"key":"Vary","value":"Accept"},{"key":"Cache-Control","value":"no-cache"},{"key":"X-Frame-Options","value":"DENY"},{"key":"Content-Length","value":"185"},{"key":"X-Content-Type-Options","value":"nosniff"},{"key":"Referrer-Policy","value":"same-origin"}],"cookie":[],"responseTime":null,"body":"{\n \"meta\": {\n \"limit\": 20,\n \"next\": null,\n \"offset\": 0,\n \"previous\": null,\n \"total_count\": 1\n },\n \"objects\": [\n {\n \"Colour\": \"Green\",\n \"Item_code\": 2,\n \"id\": 2,\n \"resource_uri\": \"/api/item_colours/2/\"\n }\n ]\n}"}],"_postman_id":"72c43ae0-b444-4d44-b835-76d48a478849"}],"id":"0a90f919-cd56-43e5-be68-25aab3369a73","description":"Keeps track of the colours of different items. The attributes are: Item_code, Colour.
\n","event":[{"listen":"prerequest","script":{"id":"eb6f8734-1b35-4300-bd10-997432305803","type":"text/javascript","exec":[""]}},{"listen":"test","script":{"id":"97c5a72e-48e4-430f-a764-4b632bb224fe","type":"text/javascript","exec":[""]}}],"_postman_id":"0a90f919-cd56-43e5-be68-25aab3369a73"},{"name":"MANUFACTURER","item":[{"name":"Populating the table","id":"fdc2d24a-9b8e-4650-b470-1bd0cd45732c","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"POST","header":[],"body":{"mode":"raw","raw":"{\n \"Name\":\"The Pokemon group\",\n \"Contact_no\":\"038789822\",\n \"Address\":\"14 Ave\"\n}","options":{"raw":{"language":"json"}}},"url":"http://localhost:8000/api/manufacturer/?Name=char&Contact_no=int&Address=char","urlObject":{"protocol":"http","port":"8000","path":["api","manufacturer",""],"host":["localhost"],"query":[{"description":{"content":"Name of manufacturer
\n","type":"text/plain"},"key":"Name","value":"char"},{"description":{"content":"Contact number of manufacturer
\n","type":"text/plain"},"key":"Contact_no","value":"int"},{"description":{"content":"address of manufacturer
\n","type":"text/plain"},"key":"Address","value":"char"}],"variable":[]}},"response":[{"id":"309209a2-de31-4fce-a00d-6d7a6c4e8a41","name":"Populating the table","originalRequest":{"method":"POST","header":[],"body":{"mode":"raw","raw":"{\n \"Name\":\"The Lego Maker\",\n \"Contact_no\":\"03877622\",\n \"Address\":\"3500 24 Ave\"\n}","options":{"raw":{"language":"json"}}},"url":"http://localhost:8000/api/manufacturer/"},"status":"Created","code":201,"_postman_previewlanguage":"html","header":[{"key":"Date","value":"Mon, 14 Dec 2020 23:58:02 GMT"},{"key":"Server","value":"WSGIServer/0.2 CPython/3.9.0"},{"key":"Content-Type","value":"text/html; charset=utf-8"},{"key":"Location","value":"/api/manufacturer/1/"},{"key":"Vary","value":"Accept"},{"key":"X-Frame-Options","value":"DENY"},{"key":"Content-Length","value":"0"},{"key":"X-Content-Type-Options","value":"nosniff"},{"key":"Referrer-Policy","value":"same-origin"}],"cookie":[],"responseTime":null,"body":null}],"_postman_id":"fdc2d24a-9b8e-4650-b470-1bd0cd45732c"},{"name":"Retreiving the data","id":"0115751f-8d02-4b42-89af-2aa5791f22d1","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"GET","header":[],"url":"http://localhost:8000/api/manufacturer/","urlObject":{"protocol":"http","port":"8000","path":["api","manufacturer",""],"host":["localhost"],"query":[],"variable":[]}},"response":[{"id":"2fc9404d-c958-40bf-aaf8-a4046eacd08c","name":"Retreiving the data","originalRequest":{"method":"GET","header":[],"url":"http://localhost:8000/api/manufacturer/"},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"Date","value":"Mon, 14 Dec 2020 23:59:05 GMT"},{"key":"Server","value":"WSGIServer/0.2 CPython/3.9.0"},{"key":"Content-Type","value":"application/json"},{"key":"Vary","value":"Accept"},{"key":"Cache-Control","value":"no-cache"},{"key":"X-Frame-Options","value":"DENY"},{"key":"Content-Length","value":"350"},{"key":"X-Content-Type-Options","value":"nosniff"},{"key":"Referrer-Policy","value":"same-origin"}],"cookie":[],"responseTime":null,"body":"{\n \"meta\": {\n \"limit\": 20,\n \"next\": null,\n \"offset\": 0,\n \"previous\": null,\n \"total_count\": 2\n },\n \"objects\": [\n {\n \"Address\": \"3500 24 Ave\",\n \"Contact_no\": 3877622,\n \"Name\": \"The Lego Maker\",\n \"id\": 1,\n \"resource_uri\": \"/api/manufacturer/1/\"\n },\n {\n \"Address\": \"14 Ave\",\n \"Contact_no\": 38789822,\n \"Name\": \"The Pokemon group\",\n \"id\": 2,\n \"resource_uri\": \"/api/manufacturer/2/\"\n }\n ]\n}"}],"_postman_id":"0115751f-8d02-4b42-89af-2aa5791f22d1"},{"name":"Change Tuple","id":"4d43e751-6d51-4099-b554-167205d1fc89","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"PUT","header":[],"body":{"mode":"raw","raw":"{\n \"Name\":\"The Pokemon Company\",\n \"Contact_no\":\"038789822\",\n \"Address\":\"22nd Ave\"\n}","options":{"raw":{"language":"json"}}},"url":"http://localhost:8000/api/manufacturer/2/","urlObject":{"protocol":"http","port":"8000","path":["api","manufacturer","2",""],"host":["localhost"],"query":[],"variable":[]}},"response":[{"id":"1f7ef02a-0817-480e-98e7-f158e1a06ec3","name":"Change Tuple","originalRequest":{"method":"PUT","header":[],"body":{"mode":"raw","raw":"{\n \"Name\":\"The Pokemon Company\",\n \"Contact_no\":\"038789822\",\n \"Address\":\"22nd Ave\"\n}","options":{"raw":{"language":"json"}}},"url":"http://localhost:8000/api/manufacturer/2/"},"status":"No Content","code":204,"_postman_previewlanguage":"plain","header":[{"key":"Date","value":"Tue, 15 Dec 2020 00:07:05 GMT"},{"key":"Server","value":"WSGIServer/0.2 CPython/3.9.0"},{"key":"Vary","value":"Accept"},{"key":"X-Frame-Options","value":"DENY"},{"key":"Content-Length","value":"0"},{"key":"X-Content-Type-Options","value":"nosniff"},{"key":"Referrer-Policy","value":"same-origin"}],"cookie":[],"responseTime":null,"body":null}],"_postman_id":"4d43e751-6d51-4099-b554-167205d1fc89"},{"name":"Delete a tuple","id":"cfa4b86c-1ee9-4456-a035-f07c8c214229","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"DELETE","header":[],"url":"http://localhost:8000/api/manufacturer/1/","urlObject":{"protocol":"http","port":"8000","path":["api","manufacturer","1",""],"host":["localhost"],"query":[],"variable":[]}},"response":[{"id":"f16b5292-393a-4a9e-9993-a647e377206b","name":"Delete a tuple","originalRequest":{"method":"DELETE","header":[],"url":"http://localhost:8000/api/manufacturer/1/"},"status":"No Content","code":204,"_postman_previewlanguage":"plain","header":[{"key":"Date","value":"Tue, 15 Dec 2020 00:08:27 GMT"},{"key":"Server","value":"WSGIServer/0.2 CPython/3.9.0"},{"key":"Vary","value":"Accept"},{"key":"X-Frame-Options","value":"DENY"},{"key":"Content-Length","value":"0"},{"key":"X-Content-Type-Options","value":"nosniff"},{"key":"Referrer-Policy","value":"same-origin"}],"cookie":[],"responseTime":null,"body":null}],"_postman_id":"cfa4b86c-1ee9-4456-a035-f07c8c214229"},{"name":"Get Result","id":"81b4a8fb-0300-433e-89be-54166e1b8a0d","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"GET","header":[],"url":"http://localhost:8000/api/manufacturer/","urlObject":{"protocol":"http","port":"8000","path":["api","manufacturer",""],"host":["localhost"],"query":[],"variable":[]}},"response":[{"id":"a5b1aafd-9593-457f-ad17-dc563ac315c7","name":"Get Result","originalRequest":{"method":"GET","header":[],"url":"http://localhost:8000/api/manufacturer/"},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"Date","value":"Tue, 15 Dec 2020 00:09:02 GMT"},{"key":"Server","value":"WSGIServer/0.2 CPython/3.9.0"},{"key":"Content-Type","value":"application/json"},{"key":"Vary","value":"Accept"},{"key":"Cache-Control","value":"no-cache"},{"key":"X-Frame-Options","value":"DENY"},{"key":"Content-Length","value":"228"},{"key":"X-Content-Type-Options","value":"nosniff"},{"key":"Referrer-Policy","value":"same-origin"}],"cookie":[],"responseTime":null,"body":"{\n \"meta\": {\n \"limit\": 20,\n \"next\": null,\n \"offset\": 0,\n \"previous\": null,\n \"total_count\": 1\n },\n \"objects\": [\n {\n \"Address\": \"22nd Ave\",\n \"Contact_no\": 38789822,\n \"Name\": \"The Pokemon Company\",\n \"id\": 2,\n \"resource_uri\": \"/api/manufacturer/2/\"\n }\n ]\n}"}],"_postman_id":"81b4a8fb-0300-433e-89be-54166e1b8a0d"}],"id":"a7b518c0-fef4-4bf2-8d7d-79decb0e6712","description":"Keeps track of manufacturers of different items. The attributes are: Name, Contact_no, Address.
\n","_postman_id":"a7b518c0-fef4-4bf2-8d7d-79decb0e6712"},{"name":"STORAGE","item":[{"name":"Populating the table","id":"7d8eb837-17d8-499c-b9f3-3347a025edb9","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"POST","header":[],"body":{"mode":"raw","raw":"{\n \"Storage_id\":\"02\",\n \"Quantity\":\"40\",\n \"Location\":\"22nd Ave\",\n \"Admin_id\":\"01\"\n}","options":{"raw":{"language":"json"}}},"url":"http://localhost:8000/api/storage/?Storage_id=int&Quantity=int&Location=char&Admin_id=int","urlObject":{"protocol":"http","port":"8000","path":["api","storage",""],"host":["localhost"],"query":[{"description":{"content":"id of storage
\n","type":"text/plain"},"key":"Storage_id","value":"int"},{"description":{"content":"quantity of items in storage
\n","type":"text/plain"},"key":"Quantity","value":"int"},{"description":{"content":"location of storage
\n","type":"text/plain"},"key":"Location","value":"char"},{"description":{"content":"id of admin incharge of storage
\n","type":"text/plain"},"key":"Admin_id","value":"int"}],"variable":[]}},"response":[{"id":"46c0d213-39d4-4c0b-a80b-2de6850aeb19","name":"Populating the table","originalRequest":{"method":"POST","header":[],"body":{"mode":"raw","raw":"{\n \"Storage_id\":\"01\",\n \"Quantity\":\"20\",\n \"Location\":\"3500 24 Ave\",\n \"Admin_id\":\"01\"\n}","options":{"raw":{"language":"json"}}},"url":"http://localhost:8000/api/storage/"},"status":"Created","code":201,"_postman_previewlanguage":"html","header":[{"key":"Date","value":"Tue, 15 Dec 2020 00:31:54 GMT"},{"key":"Server","value":"WSGIServer/0.2 CPython/3.9.0"},{"key":"Content-Type","value":"text/html; charset=utf-8"},{"key":"Location","value":"/api/storage/1/"},{"key":"Vary","value":"Accept"},{"key":"X-Frame-Options","value":"DENY"},{"key":"Content-Length","value":"0"},{"key":"X-Content-Type-Options","value":"nosniff"},{"key":"Referrer-Policy","value":"same-origin"}],"cookie":[],"responseTime":null,"body":null}],"_postman_id":"7d8eb837-17d8-499c-b9f3-3347a025edb9"},{"name":"Retreiving Data","id":"d53da62a-f8c5-4390-adcc-3185c415bb52","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"GET","header":[],"url":"http://localhost:8000/api/storage/","urlObject":{"protocol":"http","port":"8000","path":["api","storage",""],"host":["localhost"],"query":[],"variable":[]}},"response":[{"id":"c5b1cd5c-88b6-473b-9065-82accdcf0f49","name":"Retreiving Data","originalRequest":{"method":"GET","header":[],"url":"http://localhost:8000/api/storage/"},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"Date","value":"Tue, 15 Dec 2020 00:32:58 GMT"},{"key":"Server","value":"WSGIServer/0.2 CPython/3.9.0"},{"key":"Content-Type","value":"application/json"},{"key":"Vary","value":"Accept"},{"key":"Cache-Control","value":"no-cache"},{"key":"X-Frame-Options","value":"DENY"},{"key":"Content-Length","value":"304"},{"key":"X-Content-Type-Options","value":"nosniff"},{"key":"Referrer-Policy","value":"same-origin"}],"cookie":[],"responseTime":null,"body":"{\n \"meta\": {\n \"limit\": 20,\n \"next\": null,\n \"offset\": 0,\n \"previous\": null,\n \"total_count\": 2\n },\n \"objects\": [\n {\n \"Admin_id\": 1,\n \"Location\": \"3500 24 Ave\",\n \"Quantity\": 20,\n \"id\": 1,\n \"resource_uri\": \"/api/storage/1/\"\n },\n {\n \"Admin_id\": 1,\n \"Location\": \"22nd Ave\",\n \"Quantity\": 40,\n \"id\": 2,\n \"resource_uri\": \"/api/storage/2/\"\n }\n ]\n}"}],"_postman_id":"d53da62a-f8c5-4390-adcc-3185c415bb52"},{"name":"Change Tuple","id":"cae87485-3fe3-4262-b22e-e4a52ee62582","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"PUT","header":[],"body":{"mode":"raw","raw":"{\n \"Quantity\":\"35\",\n \"Location\":\"East Downtown\",\n \"Admin_id\":\"02\"\n}","options":{"raw":{"language":"json"}}},"url":"http://localhost:8000/api/storage/2/","urlObject":{"protocol":"http","port":"8000","path":["api","storage","2",""],"host":["localhost"],"query":[],"variable":[]}},"response":[{"id":"0c64c326-b6c1-4a74-9daa-11977ebac5e3","name":"Change Tuple","originalRequest":{"method":"PUT","header":[],"body":{"mode":"raw","raw":"{\n \"Quantity\":\"35\",\n \"Location\":\"East Downtown\",\n \"Admin_id\":\"02\"\n}","options":{"raw":{"language":"json"}}},"url":"http://localhost:8000/api/storage/2/"},"status":"No Content","code":204,"_postman_previewlanguage":"plain","header":[{"key":"Date","value":"Tue, 15 Dec 2020 00:34:27 GMT"},{"key":"Server","value":"WSGIServer/0.2 CPython/3.9.0"},{"key":"Vary","value":"Accept"},{"key":"X-Frame-Options","value":"DENY"},{"key":"Content-Length","value":"0"},{"key":"X-Content-Type-Options","value":"nosniff"},{"key":"Referrer-Policy","value":"same-origin"}],"cookie":[],"responseTime":null,"body":null}],"_postman_id":"cae87485-3fe3-4262-b22e-e4a52ee62582"},{"name":"Delete a tuple","id":"efde3983-2922-4895-9748-798f1b31fa55","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"DELETE","header":[],"url":"http://localhost:8000/api/storage/1/","urlObject":{"protocol":"http","port":"8000","path":["api","storage","1",""],"host":["localhost"],"query":[],"variable":[]}},"response":[{"id":"66c3d156-3e43-4c61-a1c3-559900e21c29","name":"Delete a tuple","originalRequest":{"method":"DELETE","header":[],"url":"http://localhost:8000/api/storage/1/"},"status":"No Content","code":204,"_postman_previewlanguage":"plain","header":[{"key":"Date","value":"Tue, 15 Dec 2020 00:34:54 GMT"},{"key":"Server","value":"WSGIServer/0.2 CPython/3.9.0"},{"key":"Vary","value":"Accept"},{"key":"X-Frame-Options","value":"DENY"},{"key":"Content-Length","value":"0"},{"key":"X-Content-Type-Options","value":"nosniff"},{"key":"Referrer-Policy","value":"same-origin"}],"cookie":[],"responseTime":null,"body":null}],"_postman_id":"efde3983-2922-4895-9748-798f1b31fa55"},{"name":"Get Result","id":"7d3d7395-9d8a-40e3-83e1-78f6b08ec353","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"GET","header":[],"url":"http://localhost:8000/api/storage/","urlObject":{"protocol":"http","port":"8000","path":["api","storage",""],"host":["localhost"],"query":[],"variable":[]}},"response":[{"id":"d1eb09a8-2467-481e-8eb1-998dc11dbadf","name":"Get Result","originalRequest":{"method":"GET","header":[],"url":"http://localhost:8000/api/storage/"},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"Date","value":"Tue, 15 Dec 2020 00:35:38 GMT"},{"key":"Server","value":"WSGIServer/0.2 CPython/3.9.0"},{"key":"Content-Type","value":"application/json"},{"key":"Vary","value":"Accept"},{"key":"Cache-Control","value":"no-cache"},{"key":"X-Frame-Options","value":"DENY"},{"key":"Content-Length","value":"205"},{"key":"X-Content-Type-Options","value":"nosniff"},{"key":"Referrer-Policy","value":"same-origin"}],"cookie":[],"responseTime":null,"body":"{\n \"meta\": {\n \"limit\": 20,\n \"next\": null,\n \"offset\": 0,\n \"previous\": null,\n \"total_count\": 1\n },\n \"objects\": [\n {\n \"Admin_id\": 2,\n \"Location\": \"East Downtown\",\n \"Quantity\": 35,\n \"id\": 2,\n \"resource_uri\": \"/api/storage/2/\"\n }\n ]\n}"}],"_postman_id":"7d3d7395-9d8a-40e3-83e1-78f6b08ec353"}],"id":"7151ac8c-46fc-48e9-a91a-09e27509df42","description":"This table includes details about the storages of different items. The attributes of the table are: Storage_id, Quantity, Location, Admin_id.
\n","_postman_id":"7151ac8c-46fc-48e9-a91a-09e27509df42"},{"name":"SUPPLIED THROUGH","item":[{"name":"Populating Table","id":"741f55f4-2d17-473f-9ca6-ea007df384eb","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"POST","header":[],"body":{"mode":"raw","raw":"{\n \"Item_code\":\"02\",\n \"Order_no\":\"03\",\n \"Storage_id\":\"01\"\n}","options":{"raw":{"language":"json"}}},"url":"http://localhost:8000/api/supplied_through/?Item_code=int&Order_no=int&Storage_id=int","urlObject":{"protocol":"http","port":"8000","path":["api","supplied_through",""],"host":["localhost"],"query":[{"description":{"content":"code of the item supplied
\n","type":"text/plain"},"key":"Item_code","value":"int"},{"description":{"content":"order number for which item is supplied
\n","type":"text/plain"},"key":"Order_no","value":"int"},{"description":{"content":"storage id from which item was supplied
\n","type":"text/plain"},"key":"Storage_id","value":"int"}],"variable":[]}},"response":[{"id":"8bf5b016-2911-492c-bbfd-2b1c9488621e","name":"POPULATING TABLE","originalRequest":{"method":"POST","header":[],"body":{"mode":"raw","raw":"{\n \"Item_code\":\"01\",\n \"Order_no\":\"02\",\n \"Storage_id\":\"03\"\n}","options":{"raw":{"language":"json"}}},"url":"http://localhost:8000/api/supplied_through/"},"status":"Created","code":201,"_postman_previewlanguage":"html","header":[{"key":"Date","value":"Tue, 15 Dec 2020 00:51:11 GMT"},{"key":"Server","value":"WSGIServer/0.2 CPython/3.9.0"},{"key":"Content-Type","value":"text/html; charset=utf-8"},{"key":"Location","value":"/api/supplied_through/1/"},{"key":"Vary","value":"Accept"},{"key":"X-Frame-Options","value":"DENY"},{"key":"Content-Length","value":"0"},{"key":"X-Content-Type-Options","value":"nosniff"},{"key":"Referrer-Policy","value":"same-origin"}],"cookie":[],"responseTime":null,"body":null}],"_postman_id":"741f55f4-2d17-473f-9ca6-ea007df384eb"},{"name":"Retreiving data","id":"56cedbaa-0a1a-45ec-a18b-dccd46f27eb9","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"GET","header":[],"url":"http://localhost:8000/api/supplied_through/","urlObject":{"protocol":"http","port":"8000","path":["api","supplied_through",""],"host":["localhost"],"query":[],"variable":[]}},"response":[{"id":"2fbd401f-a55d-4531-bad3-2d671a4e468d","name":"Retreiving data","originalRequest":{"method":"GET","header":[],"url":"http://localhost:8000/api/supplied_through/"},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"Date","value":"Tue, 15 Dec 2020 00:52:36 GMT"},{"key":"Server","value":"WSGIServer/0.2 CPython/3.9.0"},{"key":"Content-Type","value":"application/json"},{"key":"Vary","value":"Accept"},{"key":"Cache-Control","value":"no-cache"},{"key":"X-Frame-Options","value":"DENY"},{"key":"Content-Length","value":"305"},{"key":"X-Content-Type-Options","value":"nosniff"},{"key":"Referrer-Policy","value":"same-origin"}],"cookie":[],"responseTime":null,"body":"{\n \"meta\": {\n \"limit\": 20,\n \"next\": null,\n \"offset\": 0,\n \"previous\": null,\n \"total_count\": 2\n },\n \"objects\": [\n {\n \"Item_code\": 1,\n \"Order_no\": 2,\n \"Storage_id\": 3,\n \"id\": 1,\n \"resource_uri\": \"/api/supplied_through/1/\"\n },\n {\n \"Item_code\": 2,\n \"Order_no\": 3,\n \"Storage_id\": 1,\n \"id\": 2,\n \"resource_uri\": \"/api/supplied_through/2/\"\n }\n ]\n}"}],"_postman_id":"56cedbaa-0a1a-45ec-a18b-dccd46f27eb9"},{"name":"Change Tuple","id":"f28d0138-0dd5-451a-9ce2-d17e60dedf0c","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"PUT","header":[],"body":{"mode":"raw","raw":"{\n \"Item_code\":\"01\",\n \"Order_no\":\"03\",\n \"Storage_id\":\"03\"\n}","options":{"raw":{"language":"json"}}},"url":"http://localhost:8000/api/supplied_through/2/","urlObject":{"protocol":"http","port":"8000","path":["api","supplied_through","2",""],"host":["localhost"],"query":[],"variable":[]}},"response":[{"id":"549b7b64-77fe-4762-b394-5edfd2d553ad","name":"Change Tuple","originalRequest":{"method":"PUT","header":[],"body":{"mode":"raw","raw":"{\n \"Item_code\":\"01\",\n \"Order_no\":\"03\",\n \"Storage_id\":\"03\"\n}","options":{"raw":{"language":"json"}}},"url":"http://localhost:8000/api/supplied_through/2/"},"status":"No Content","code":204,"_postman_previewlanguage":"plain","header":[{"key":"Date","value":"Tue, 15 Dec 2020 00:58:13 GMT"},{"key":"Server","value":"WSGIServer/0.2 CPython/3.9.0"},{"key":"Vary","value":"Accept"},{"key":"X-Frame-Options","value":"DENY"},{"key":"Content-Length","value":"0"},{"key":"X-Content-Type-Options","value":"nosniff"},{"key":"Referrer-Policy","value":"same-origin"}],"cookie":[],"responseTime":null,"body":null}],"_postman_id":"f28d0138-0dd5-451a-9ce2-d17e60dedf0c"},{"name":"delete a tuple","id":"c038138c-fd5d-489d-a50a-4806e66d83fa","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"DELETE","header":[],"url":"http://localhost:8000/api/supplied_through/1/","urlObject":{"protocol":"http","port":"8000","path":["api","supplied_through","1",""],"host":["localhost"],"query":[],"variable":[]}},"response":[{"id":"3d8bfc98-b4cf-4211-a706-0f0bbfcdde87","name":"delete a tuple","originalRequest":{"method":"DELETE","header":[],"url":"http://localhost:8000/api/supplied_through/1/"},"status":"No Content","code":204,"_postman_previewlanguage":"plain","header":[{"key":"Date","value":"Tue, 15 Dec 2020 01:03:31 GMT"},{"key":"Server","value":"WSGIServer/0.2 CPython/3.9.0"},{"key":"Vary","value":"Accept"},{"key":"X-Frame-Options","value":"DENY"},{"key":"Content-Length","value":"0"},{"key":"X-Content-Type-Options","value":"nosniff"},{"key":"Referrer-Policy","value":"same-origin"}],"cookie":[],"responseTime":null,"body":null}],"_postman_id":"c038138c-fd5d-489d-a50a-4806e66d83fa"},{"name":"Get Result","id":"dd496d9d-f687-4173-9dcc-2d8e30ee2774","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"GET","header":[],"url":"http://localhost:8000/api/supplied_through/","urlObject":{"protocol":"http","port":"8000","path":["api","supplied_through",""],"host":["localhost"],"query":[],"variable":[]}},"response":[{"id":"f0beabb2-b306-4399-8755-9fc49efdeb7f","name":"Get Result","originalRequest":{"method":"GET","header":[],"url":"http://localhost:8000/api/supplied_through/"},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"Date","value":"Tue, 15 Dec 2020 01:04:05 GMT"},{"key":"Server","value":"WSGIServer/0.2 CPython/3.9.0"},{"key":"Content-Type","value":"application/json"},{"key":"Vary","value":"Accept"},{"key":"Cache-Control","value":"no-cache"},{"key":"X-Frame-Options","value":"DENY"},{"key":"Content-Length","value":"202"},{"key":"X-Content-Type-Options","value":"nosniff"},{"key":"Referrer-Policy","value":"same-origin"}],"cookie":[],"responseTime":null,"body":"{\n \"meta\": {\n \"limit\": 20,\n \"next\": null,\n \"offset\": 0,\n \"previous\": null,\n \"total_count\": 1\n },\n \"objects\": [\n {\n \"Item_code\": 1,\n \"Order_no\": 3,\n \"Storage_id\": 3,\n \"id\": 2,\n \"resource_uri\": \"/api/supplied_through/2/\"\n }\n ]\n}"}],"_postman_id":"dd496d9d-f687-4173-9dcc-2d8e30ee2774"}],"id":"abd4c9bb-cca8-45a8-98ff-5b1f77e09f74","description":"Table includes details of the items taken from a storage for an oredr. The attributes of the table are: Item_code, Order_no, Storage_id
\n","_postman_id":"abd4c9bb-cca8-45a8-98ff-5b1f77e09f74"},{"name":"CUSTOMER","item":[{"name":"Populate the table","id":"9440e779-bd26-44e2-a81e-6ae993ca24c8","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"POST","header":[],"body":{"mode":"raw","raw":"{\n \"Name\":\"james\",\n \"Email\":\"james@gmail.com\",\n \"Phone\":\"76583939707\"\n}","options":{"raw":{"language":"json"}}},"url":"http://localhost:8000/api/customer/?Name=char&Email=char&Phone=int","urlObject":{"protocol":"http","port":"8000","path":["api","customer",""],"host":["localhost"],"query":[{"description":{"content":"name of customer
\n","type":"text/plain"},"key":"Name","value":"char"},{"description":{"content":"email of customer
\n","type":"text/plain"},"key":"Email","value":"char"},{"description":{"content":"phone number of customer
\n","type":"text/plain"},"key":"Phone","value":"int"}],"variable":[]}},"response":[{"id":"e1d59de4-af2b-4ead-9b9b-171ce8da5a5b","name":"Populate the table","originalRequest":{"method":"POST","header":[],"body":{"mode":"raw","raw":"{\n \"Name\":\"james\",\n \"Email\":\"james@gmail.com\",\n \"Phone\":\"76583939707\"\n}","options":{"raw":{"language":"json"}}},"url":"http://localhost:8000/api/customer/"},"status":"Created","code":201,"_postman_previewlanguage":"html","header":[{"key":"Date","value":"Tue, 15 Dec 2020 01:11:19 GMT"},{"key":"Server","value":"WSGIServer/0.2 CPython/3.9.0"},{"key":"Content-Type","value":"text/html; charset=utf-8"},{"key":"Location","value":"/api/customer/9/"},{"key":"Vary","value":"Accept"},{"key":"X-Frame-Options","value":"DENY"},{"key":"Content-Length","value":"0"},{"key":"X-Content-Type-Options","value":"nosniff"},{"key":"Referrer-Policy","value":"same-origin"}],"cookie":[],"responseTime":null,"body":null}],"_postman_id":"9440e779-bd26-44e2-a81e-6ae993ca24c8"},{"name":"Retreiving data","id":"9bb2a095-8387-44ad-bf0a-aeb8855f6c5d","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"GET","header":[],"url":"http://localhost:8000/api/customer/","urlObject":{"protocol":"http","port":"8000","path":["api","customer",""],"host":["localhost"],"query":[],"variable":[]}},"response":[{"id":"a73e3a12-8906-4abb-aee6-1a6edb208854","name":"Retreiving data","originalRequest":{"method":"GET","header":[],"url":"http://localhost:8000/api/customer/"},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"Date","value":"Tue, 15 Dec 2020 01:11:29 GMT"},{"key":"Server","value":"WSGIServer/0.2 CPython/3.9.0"},{"key":"Content-Type","value":"application/json"},{"key":"Vary","value":"Accept"},{"key":"Cache-Control","value":"no-cache"},{"key":"X-Frame-Options","value":"DENY"},{"key":"Content-Length","value":"329"},{"key":"X-Content-Type-Options","value":"nosniff"},{"key":"Referrer-Policy","value":"same-origin"}],"cookie":[],"responseTime":null,"body":"{\n \"meta\": {\n \"limit\": 20,\n \"next\": null,\n \"offset\": 0,\n \"previous\": null,\n \"total_count\": 2\n },\n \"objects\": [\n {\n \"Email\": \"george@gmail.com\",\n \"Name\": \"George\",\n \"Phone\": 76538979707,\n \"id\": 8,\n \"resource_uri\": \"/api/customer/8/\"\n },\n {\n \"Email\": \"james@gmail.com\",\n \"Name\": \"james\",\n \"Phone\": 76583939707,\n \"id\": 9,\n \"resource_uri\": \"/api/customer/9/\"\n }\n ]\n}"}],"_postman_id":"9bb2a095-8387-44ad-bf0a-aeb8855f6c5d"},{"name":"Change Tuple","id":"6d9e6c76-f3f4-44cc-9a88-a176281acbb2","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"PUT","header":[],"body":{"mode":"raw","raw":"","options":{"raw":{"language":"json"}}},"url":"http://localhost:8000/api/customer/9/","urlObject":{"protocol":"http","port":"8000","path":["api","customer","9",""],"host":["localhost"],"query":[],"variable":[]}},"response":[{"id":"932902c2-c0ce-4a31-b472-cf8138fc70cf","name":"Chane Tuple","originalRequest":{"method":"PUT","header":[],"body":{"mode":"raw","raw":"{\n \"Email\":\"j.shaw@gmail.com\"\n}","options":{"raw":{"language":"json"}}},"url":"http://localhost:8000/api/customer/9/"},"status":"No Content","code":204,"_postman_previewlanguage":"plain","header":[{"key":"Date","value":"Tue, 15 Dec 2020 01:13:37 GMT"},{"key":"Server","value":"WSGIServer/0.2 CPython/3.9.0"},{"key":"Vary","value":"Accept"},{"key":"X-Frame-Options","value":"DENY"},{"key":"Content-Length","value":"0"},{"key":"X-Content-Type-Options","value":"nosniff"},{"key":"Referrer-Policy","value":"same-origin"}],"cookie":[],"responseTime":null,"body":null}],"_postman_id":"6d9e6c76-f3f4-44cc-9a88-a176281acbb2"},{"name":"Delete Tuple","id":"e005acc5-bcb5-43a3-900c-7b48784ab00c","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"DELETE","header":[],"url":"http://localhost:8000/api/customer/8/","urlObject":{"protocol":"http","port":"8000","path":["api","customer","8",""],"host":["localhost"],"query":[],"variable":[]}},"response":[{"id":"6bf34c57-e29e-406f-8239-ba16febc1d54","name":"Delete Tuple","originalRequest":{"method":"DELETE","header":[],"url":"http://localhost:8000/api/customer/8/"},"status":"No Content","code":204,"_postman_previewlanguage":"plain","header":[{"key":"Date","value":"Tue, 15 Dec 2020 01:15:16 GMT"},{"key":"Server","value":"WSGIServer/0.2 CPython/3.9.0"},{"key":"Vary","value":"Accept"},{"key":"X-Frame-Options","value":"DENY"},{"key":"Content-Length","value":"0"},{"key":"X-Content-Type-Options","value":"nosniff"},{"key":"Referrer-Policy","value":"same-origin"}],"cookie":[],"responseTime":null,"body":null}],"_postman_id":"e005acc5-bcb5-43a3-900c-7b48784ab00c"},{"name":"Get Result","id":"41ed2592-a771-4a46-acec-2c74403b20b8","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"GET","header":[],"url":"http://localhost:8000/api/customer/","urlObject":{"protocol":"http","port":"8000","path":["api","customer",""],"host":["localhost"],"query":[],"variable":[]}},"response":[{"id":"05eeef12-ea3e-4dcf-bbe2-767080024770","name":"Get Result","originalRequest":{"method":"GET","header":[],"url":"http://localhost:8000/api/customer/"},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"Date","value":"Tue, 15 Dec 2020 01:15:36 GMT"},{"key":"Server","value":"WSGIServer/0.2 CPython/3.9.0"},{"key":"Content-Type","value":"application/json"},{"key":"Vary","value":"Accept"},{"key":"Cache-Control","value":"no-cache"},{"key":"X-Frame-Options","value":"DENY"},{"key":"Content-Length","value":"214"},{"key":"X-Content-Type-Options","value":"nosniff"},{"key":"Referrer-Policy","value":"same-origin"}],"cookie":[],"responseTime":null,"body":"{\n \"meta\": {\n \"limit\": 20,\n \"next\": null,\n \"offset\": 0,\n \"previous\": null,\n \"total_count\": 1\n },\n \"objects\": [\n {\n \"Email\": \"j.shaw@gmail.com\",\n \"Name\": \"james\",\n \"Phone\": 76583939707,\n \"id\": 9,\n \"resource_uri\": \"/api/customer/9/\"\n }\n ]\n}"}],"_postman_id":"41ed2592-a771-4a46-acec-2c74403b20b8"}],"id":"04397ca9-4448-4839-9209-ff5af0d3214f","description":"Includes details of customers. The attributes of the table are: Customer_id, Name, Email, Phone.
\n","event":[{"listen":"prerequest","script":{"id":"81c429ff-cac5-4b7d-b6b9-ed69fde2942d","type":"text/javascript","exec":[""]}},{"listen":"test","script":{"id":"d79842c8-58ba-49ff-8adb-08e647f5c075","type":"text/javascript","exec":[""]}}],"_postman_id":"04397ca9-4448-4839-9209-ff5af0d3214f"},{"name":"PAYMENT DETAILS","item":[{"name":"Populating the table","id":"2292f0dd-bc40-4b59-8e8e-d6e4ff068ccc","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"POST","header":[],"body":{"mode":"raw","raw":"{\n \"Customer_id\":\"02\",\n \"Billing_address\":\"3600 12 Ave\",\n \"Credit\":\"XXXX XXXX XXXX 9283\",\n \"Cash_on_delivery\":\"NA\"\n}","options":{"raw":{"language":"json"}}},"url":"http://localhost:8000/api/payment_details/?Customer_id=int&Billing_address=char&Credit=char&Cash_on_delivery=char","urlObject":{"protocol":"http","port":"8000","path":["api","payment_details",""],"host":["localhost"],"query":[{"description":{"content":"id of the customer
\n","type":"text/plain"},"key":"Customer_id","value":"int"},{"description":{"content":"billing address for customer
\n","type":"text/plain"},"key":"Billing_address","value":"char"},{"description":{"content":"credit card details if applicable
\n","type":"text/plain"},"key":"Credit","value":"char"},{"description":{"content":"shipping address if applicable
\n","type":"text/plain"},"key":"Cash_on_delivery","value":"char"}],"variable":[]}},"response":[{"id":"3c758f92-af01-4646-ae64-1fcd8bf8cdfb","name":"Populating the table","originalRequest":{"method":"POST","header":[],"body":{"mode":"raw","raw":"{\n \"Customer_id\":\"03\",\n \"Billing_address\":\"3928 12 Ave\",\n \"Credit\":\"NA\",\n \"Cash_on_delivery\":\"3928 12 Ave\"\n}","options":{"raw":{"language":"json"}}},"url":"http://localhost:8000/api/payment_details/"},"status":"Created","code":201,"_postman_previewlanguage":"html","header":[{"key":"Date","value":"Tue, 15 Dec 2020 01:33:33 GMT"},{"key":"Server","value":"WSGIServer/0.2 CPython/3.9.0"},{"key":"Content-Type","value":"text/html; charset=utf-8"},{"key":"Location","value":"/api/payment_details/3/"},{"key":"Vary","value":"Accept"},{"key":"X-Frame-Options","value":"DENY"},{"key":"Content-Length","value":"0"},{"key":"X-Content-Type-Options","value":"nosniff"},{"key":"Referrer-Policy","value":"same-origin"}],"cookie":[],"responseTime":null,"body":null}],"_postman_id":"2292f0dd-bc40-4b59-8e8e-d6e4ff068ccc"},{"name":"Retreiving data","id":"b97d5fc3-eca0-4df9-9b5e-124e64b46d1e","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"GET","header":[],"url":"","urlObject":{"query":[],"variable":[]}},"response":[{"id":"baef5aeb-dccc-449c-92a2-47994bb645ba","name":"Retreiving data","originalRequest":{"method":"GET","header":[],"url":"http://localhost:8000/api/payment_details/"},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"Date","value":"Tue, 15 Dec 2020 01:34:47 GMT"},{"key":"Server","value":"WSGIServer/0.2 CPython/3.9.0"},{"key":"Content-Type","value":"application/json"},{"key":"Vary","value":"Accept"},{"key":"Cache-Control","value":"no-cache"},{"key":"X-Frame-Options","value":"DENY"},{"key":"Content-Length","value":"421"},{"key":"X-Content-Type-Options","value":"nosniff"},{"key":"Referrer-Policy","value":"same-origin"}],"cookie":[],"responseTime":null,"body":"{\n \"meta\": {\n \"limit\": 20,\n \"next\": null,\n \"offset\": 0,\n \"previous\": null,\n \"total_count\": 2\n },\n \"objects\": [\n {\n \"Billing_address\": \"3928 12 Ave\",\n \"Cash_on_delivery\": \"3928 12 Ave\",\n \"Credit\": \"NA\",\n \"Customer_id\": 3,\n \"id\": 3,\n \"resource_uri\": \"/api/payment_details/3/\"\n },\n {\n \"Billing_address\": \"3600 12 Ave\",\n \"Cash_on_delivery\": \"NA\",\n \"Credit\": \"XXXX XXXX XXXX 9283\",\n \"Customer_id\": 2,\n \"id\": 4,\n \"resource_uri\": \"/api/payment_details/4/\"\n }\n ]\n}"}],"_postman_id":"b97d5fc3-eca0-4df9-9b5e-124e64b46d1e"},{"name":"Change tuple","id":"33c4bc8d-fd84-4209-8b65-638b58568b25","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"PUT","header":[],"body":{"mode":"raw","raw":"{\n \"Customer_id\":\"02\",\n \"Billing_address\":\"6777 26 ave\",\n \"Credit\":\"XXXX XXXX XXXX 9283\",\n \"Cash_on_delivery\":\"NA\"\n}","options":{"raw":{"language":"json"}}},"url":"http://localhost:8000/api/payment_details/4/","urlObject":{"protocol":"http","port":"8000","path":["api","payment_details","4",""],"host":["localhost"],"query":[],"variable":[]}},"response":[{"id":"aa58564b-afe8-4dc3-9fbd-c55b0d552220","name":"Change tuple","originalRequest":{"method":"PUT","header":[],"body":{"mode":"raw","raw":"{\n \"Customer_id\":\"02\",\n \"Billing_address\":\"6777 26 ave\",\n \"Credit\":\"XXXX XXXX XXXX 9283\",\n \"Cash_on_delivery\":\"NA\"\n}","options":{"raw":{"language":"json"}}},"url":"http://localhost:8000/api/payment_details/4/"},"status":"No Content","code":204,"_postman_previewlanguage":"plain","header":[{"key":"Date","value":"Tue, 15 Dec 2020 01:39:01 GMT"},{"key":"Server","value":"WSGIServer/0.2 CPython/3.9.0"},{"key":"Vary","value":"Accept"},{"key":"X-Frame-Options","value":"DENY"},{"key":"Content-Length","value":"0"},{"key":"X-Content-Type-Options","value":"nosniff"},{"key":"Referrer-Policy","value":"same-origin"}],"cookie":[],"responseTime":null,"body":null}],"_postman_id":"33c4bc8d-fd84-4209-8b65-638b58568b25"},{"name":"Delete tuple","id":"84f0c53e-c5aa-45db-a32c-0ca53784ab4c","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"DELETE","header":[],"url":"http://localhost:8000/api/payment_details/3/","urlObject":{"protocol":"http","port":"8000","path":["api","payment_details","3",""],"host":["localhost"],"query":[],"variable":[]}},"response":[{"id":"de4ab524-032e-4c89-923b-328a833b34e1","name":"Delete tuple","originalRequest":{"method":"DELETE","header":[],"url":"http://localhost:8000/api/payment_details/3/"},"status":"No Content","code":204,"_postman_previewlanguage":"plain","header":[{"key":"Date","value":"Tue, 15 Dec 2020 01:39:53 GMT"},{"key":"Server","value":"WSGIServer/0.2 CPython/3.9.0"},{"key":"Vary","value":"Accept"},{"key":"X-Frame-Options","value":"DENY"},{"key":"Content-Length","value":"0"},{"key":"X-Content-Type-Options","value":"nosniff"},{"key":"Referrer-Policy","value":"same-origin"}],"cookie":[],"responseTime":null,"body":null}],"_postman_id":"84f0c53e-c5aa-45db-a32c-0ca53784ab4c"},{"name":"Get Result","id":"949e2a20-0923-4377-b50b-73a8d3bd133d","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"GET","header":[],"url":"http://localhost:8000/api/payment_details/","urlObject":{"protocol":"http","port":"8000","path":["api","payment_details",""],"host":["localhost"],"query":[],"variable":[]}},"response":[{"id":"384c183e-edca-4c2b-952d-94a5df775e9b","name":"Get Result","originalRequest":{"method":"GET","header":[],"url":"http://localhost:8000/api/payment_details/"},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"Date","value":"Tue, 15 Dec 2020 01:40:26 GMT"},{"key":"Server","value":"WSGIServer/0.2 CPython/3.9.0"},{"key":"Content-Type","value":"application/json"},{"key":"Vary","value":"Accept"},{"key":"Cache-Control","value":"no-cache"},{"key":"X-Frame-Options","value":"DENY"},{"key":"Content-Length","value":"264"},{"key":"X-Content-Type-Options","value":"nosniff"},{"key":"Referrer-Policy","value":"same-origin"}],"cookie":[],"responseTime":null,"body":"{\n \"meta\": {\n \"limit\": 20,\n \"next\": null,\n \"offset\": 0,\n \"previous\": null,\n \"total_count\": 1\n },\n \"objects\": [\n {\n \"Billing_address\": \"6777 26 ave\",\n \"Cash_on_delivery\": \"NA\",\n \"Credit\": \"XXXX XXXX XXXX 9283\",\n \"Customer_id\": 2,\n \"id\": 4,\n \"resource_uri\": \"/api/payment_details/4/\"\n }\n ]\n}"}],"_postman_id":"949e2a20-0923-4377-b50b-73a8d3bd133d"}],"id":"93e3c8dc-1810-4627-9ef5-795190fcba40","description":"Includes the payment details of the customer. The attributes are Customer_id, Billing_Address, Credit, Cash_on_delivery.
\n","_postman_id":"93e3c8dc-1810-4627-9ef5-795190fcba40"},{"name":"ADMIN","item":[{"name":"Populating the table","id":"59b33e05-b215-4555-8a27-4ed58345bf73","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"POST","header":[],"body":{"mode":"raw","raw":"{\n \"Name\":\"charles\",\n \"Email\":\"charles@yahoomail.com\"\n}","options":{"raw":{"language":"json"}}},"url":"http://localhost:8000/api/admin/?Name=char&Email=char","urlObject":{"protocol":"http","port":"8000","path":["api","admin",""],"host":["localhost"],"query":[{"description":{"content":"Name of admin
\n","type":"text/plain"},"key":"Name","value":"char"},{"description":{"content":"email of admin
\n","type":"text/plain"},"key":"Email","value":"char"}],"variable":[]}},"response":[{"id":"12df1fbd-4d02-439f-9de5-9d9305061e17","name":"Populating the table","originalRequest":{"method":"POST","header":[],"body":{"mode":"raw","raw":"{\n \"Admin_id\":\"01\",\n \"Name\":\"Alex\",\n \"Email\":\"alex@yahoomail.com\"\n}","options":{"raw":{"language":"json"}}},"url":{"raw":"http://localhost:8000/api/admin/?Admin_id=int&Name=char&Email=char","protocol":"http","host":["localhost"],"port":"8000","path":["api","admin",""],"query":[{"key":"Admin_id","value":"int","description":"id of admin ","type":"text"},{"key":"Name","value":"char","description":"name of admin","type":"text"},{"key":"Email","value":"char","description":"email of admin","type":"text"}]}},"status":"Created","code":201,"_postman_previewlanguage":"html","header":[{"key":"Date","value":"Tue, 15 Dec 2020 01:43:30 GMT"},{"key":"Server","value":"WSGIServer/0.2 CPython/3.9.0"},{"key":"Content-Type","value":"text/html; charset=utf-8"},{"key":"Location","value":"/api/admin/2/"},{"key":"Vary","value":"Accept"},{"key":"X-Frame-Options","value":"DENY"},{"key":"Content-Length","value":"0"},{"key":"X-Content-Type-Options","value":"nosniff"},{"key":"Referrer-Policy","value":"same-origin"}],"cookie":[],"responseTime":null,"body":null}],"_postman_id":"59b33e05-b215-4555-8a27-4ed58345bf73"},{"name":"Retreiving data","id":"28b65490-03fe-41b9-8ece-26ceefbc184c","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"GET","header":[],"url":"http://localhost:8000/api/admin/","urlObject":{"protocol":"http","port":"8000","path":["api","admin",""],"host":["localhost"],"query":[],"variable":[]}},"response":[{"id":"f24a066f-67e3-485e-8ad3-bb5ee8eb1b3c","name":"Retreiving data","originalRequest":{"method":"GET","header":[],"url":"http://localhost:8000/api/admin/"},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"Date","value":"Tue, 15 Dec 2020 01:45:48 GMT"},{"key":"Server","value":"WSGIServer/0.2 CPython/3.9.0"},{"key":"Content-Type","value":"application/json"},{"key":"Vary","value":"Accept"},{"key":"Cache-Control","value":"no-cache"},{"key":"X-Frame-Options","value":"DENY"},{"key":"Content-Length","value":"287"},{"key":"X-Content-Type-Options","value":"nosniff"},{"key":"Referrer-Policy","value":"same-origin"}],"cookie":[],"responseTime":null,"body":"{\n \"meta\": {\n \"limit\": 20,\n \"next\": null,\n \"offset\": 0,\n \"previous\": null,\n \"total_count\": 2\n },\n \"objects\": [\n {\n \"Email\": \"alex@yahoomail.com\",\n \"Name\": \"Alex\",\n \"id\": 2,\n \"resource_uri\": \"/api/admin/2/\"\n },\n {\n \"Email\": \"charles@yahoomail.com\",\n \"Name\": \"charles\",\n \"id\": 3,\n \"resource_uri\": \"/api/admin/3/\"\n }\n ]\n}"}],"_postman_id":"28b65490-03fe-41b9-8ece-26ceefbc184c"},{"name":"Change Tuple","id":"2de5fede-773f-4953-a8de-9b348d16d715","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"PUT","header":[],"body":{"mode":"raw","raw":"{\n \"Email\":\"alex_12@gmail.com\"\n}","options":{"raw":{"language":"json"}}},"url":"http://localhost:8000/api/admin/2/","urlObject":{"protocol":"http","port":"8000","path":["api","admin","2",""],"host":["localhost"],"query":[],"variable":[]}},"response":[{"id":"a3382572-b463-40f8-91cd-f0baf0a9f48f","name":"change tuple","originalRequest":{"method":"PUT","header":[],"body":{"mode":"raw","raw":"{\n \"Email\":\"alex_12@gmail.com\"\n}","options":{"raw":{"language":"json"}}},"url":"http://localhost:8000/api/admin/2/"},"status":"No Content","code":204,"_postman_previewlanguage":"plain","header":[{"key":"Date","value":"Tue, 15 Dec 2020 02:01:46 GMT"},{"key":"Server","value":"WSGIServer/0.2 CPython/3.9.0"},{"key":"Vary","value":"Accept"},{"key":"X-Frame-Options","value":"DENY"},{"key":"Content-Length","value":"0"},{"key":"X-Content-Type-Options","value":"nosniff"},{"key":"Referrer-Policy","value":"same-origin"}],"cookie":[],"responseTime":null,"body":null}],"_postman_id":"2de5fede-773f-4953-a8de-9b348d16d715"},{"name":"Delete Tuple","id":"e0f520f8-7efb-4cef-986d-bb97deb53088","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"DELETE","header":[],"url":"http://localhost:8000/api/admin/3/","urlObject":{"protocol":"http","port":"8000","path":["api","admin","3",""],"host":["localhost"],"query":[],"variable":[]}},"response":[{"id":"5dc28bca-caee-484a-bea6-dc6b14d44bdc","name":"Delete Tuple","originalRequest":{"method":"DELETE","header":[],"url":"http://localhost:8000/api/admin/3/"},"status":"No Content","code":204,"_postman_previewlanguage":"plain","header":[{"key":"Date","value":"Tue, 15 Dec 2020 02:03:19 GMT"},{"key":"Server","value":"WSGIServer/0.2 CPython/3.9.0"},{"key":"Vary","value":"Accept"},{"key":"X-Frame-Options","value":"DENY"},{"key":"Content-Length","value":"0"},{"key":"X-Content-Type-Options","value":"nosniff"},{"key":"Referrer-Policy","value":"same-origin"}],"cookie":[],"responseTime":null,"body":null}],"_postman_id":"e0f520f8-7efb-4cef-986d-bb97deb53088"},{"name":"Get Result","id":"93748b61-be1a-48fe-92ee-bbb9fe610360","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"GET","header":[],"url":"http://localhost:8000/api/admin/","urlObject":{"protocol":"http","port":"8000","path":["api","admin",""],"host":["localhost"],"query":[],"variable":[]}},"response":[{"id":"6f6869b9-d204-4359-adab-4b46daaa05d5","name":"Get Result","originalRequest":{"method":"GET","header":[],"url":"http://localhost:8000/api/admin/"},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"Date","value":"Tue, 15 Dec 2020 02:04:35 GMT"},{"key":"Server","value":"WSGIServer/0.2 CPython/3.9.0"},{"key":"Content-Type","value":"application/json"},{"key":"Vary","value":"Accept"},{"key":"Cache-Control","value":"no-cache"},{"key":"X-Frame-Options","value":"DENY"},{"key":"Content-Length","value":"189"},{"key":"X-Content-Type-Options","value":"nosniff"},{"key":"Referrer-Policy","value":"same-origin"}],"cookie":[],"responseTime":null,"body":"{\n \"meta\": {\n \"limit\": 20,\n \"next\": null,\n \"offset\": 0,\n \"previous\": null,\n \"total_count\": 1\n },\n \"objects\": [\n {\n \"Email\": \"alex_12@gmail.com\",\n \"Name\": \"Alex\",\n \"id\": 2,\n \"resource_uri\": \"/api/admin/2/\"\n }\n ]\n}"}],"_postman_id":"93748b61-be1a-48fe-92ee-bbb9fe610360"}],"id":"d530f4cb-f9fc-4bc9-96c0-f6d51e8001dc","description":"Contains information of the admins. The attributes of the table are: Admin_id, Name, Email.
\n","event":[{"listen":"prerequest","script":{"id":"5d2c80b7-e848-4832-a0bf-cdea7058fd5a","type":"text/javascript","exec":[""]}},{"listen":"test","script":{"id":"ad83fe87-b18e-40e7-8091-e84e3979b8d7","type":"text/javascript","exec":[""]}}],"_postman_id":"d530f4cb-f9fc-4bc9-96c0-f6d51e8001dc"},{"name":"CONTACTS","item":[{"name":"Populating the database","id":"f10c342e-af01-41c9-b036-36fc66f854ac","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"POST","header":[],"body":{"mode":"raw","raw":"{\n \"Admin_id\":\"02\",\n \"Man_name\":\"The Pokemon Group\"\n}","options":{"raw":{"language":"json"}}},"url":"http://localhost:8000/api/contacts/?Admin_id=int&Man_name=char","urlObject":{"protocol":"http","port":"8000","path":["api","contacts",""],"host":["localhost"],"query":[{"description":{"content":"id of admin that contacts
\n","type":"text/plain"},"key":"Admin_id","value":"int"},{"description":{"content":"name of manufacturer contacted
\n","type":"text/plain"},"key":"Man_name","value":"char"}],"variable":[]}},"response":[{"id":"b6adcb4b-6735-401b-9d45-0dc52f419a1f","name":"Populating the database","originalRequest":{"method":"POST","header":[],"body":{"mode":"raw","raw":"{\n \"Admin_id\":\"01\",\n \"Man_name\":\"The Lego Group\"\n}","options":{"raw":{"language":"json"}}},"url":"http://localhost:8000/api/contacts/"},"status":"Created","code":201,"_postman_previewlanguage":"html","header":[{"key":"Date","value":"Tue, 15 Dec 2020 02:08:39 GMT"},{"key":"Server","value":"WSGIServer/0.2 CPython/3.9.0"},{"key":"Content-Type","value":"text/html; charset=utf-8"},{"key":"Location","value":"/api/contacts/1/"},{"key":"Vary","value":"Accept"},{"key":"X-Frame-Options","value":"DENY"},{"key":"Content-Length","value":"0"},{"key":"X-Content-Type-Options","value":"nosniff"},{"key":"Referrer-Policy","value":"same-origin"}],"cookie":[],"responseTime":null,"body":null}],"_postman_id":"f10c342e-af01-41c9-b036-36fc66f854ac"},{"name":"Retreiving data","id":"64ca6f25-b414-4f31-adc6-a95f54cfaebf","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"GET","header":[],"url":"http://localhost:8000/api/contacts/","urlObject":{"protocol":"http","port":"8000","path":["api","contacts",""],"host":["localhost"],"query":[],"variable":[]}},"response":[{"id":"f4491ed4-9954-418a-814c-e15e1aa628a5","name":"Retreiving data","originalRequest":{"method":"GET","header":[],"url":"http://localhost:8000/api/contacts/"},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"Date","value":"Tue, 15 Dec 2020 02:10:52 GMT"},{"key":"Server","value":"WSGIServer/0.2 CPython/3.9.0"},{"key":"Content-Type","value":"application/json"},{"key":"Vary","value":"Accept"},{"key":"Cache-Control","value":"no-cache"},{"key":"X-Frame-Options","value":"DENY"},{"key":"Content-Length","value":"286"},{"key":"X-Content-Type-Options","value":"nosniff"},{"key":"Referrer-Policy","value":"same-origin"}],"cookie":[],"responseTime":null,"body":"{\n \"meta\": {\n \"limit\": 20,\n \"next\": null,\n \"offset\": 0,\n \"previous\": null,\n \"total_count\": 2\n },\n \"objects\": [\n {\n \"Admin_id\": 1,\n \"Man_name\": \"The Lego Group\",\n \"id\": 1,\n \"resource_uri\": \"/api/contacts/1/\"\n },\n {\n \"Admin_id\": 2,\n \"Man_name\": \"The Pokemon Group\",\n \"id\": 2,\n \"resource_uri\": \"/api/contacts/2/\"\n }\n ]\n}"}],"_postman_id":"64ca6f25-b414-4f31-adc6-a95f54cfaebf"},{"name":"Changing tuple","id":"f03feb68-8130-4ac1-b633-6ab8618fd92d","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"PUT","header":[],"body":{"mode":"raw","raw":"{\n \"Admin_id\":\"01\"\n}","options":{"raw":{"language":"json"}}},"url":"http://localhost:8000/api/contacts/2/","urlObject":{"protocol":"http","port":"8000","path":["api","contacts","2",""],"host":["localhost"],"query":[],"variable":[]}},"response":[{"id":"068c750e-7b33-4194-9035-88ebae8c9cb0","name":"Changing tuple","originalRequest":{"method":"PUT","header":[],"body":{"mode":"raw","raw":"{\n \"Admin_id\":\"01\"\n}","options":{"raw":{"language":"json"}}},"url":"http://localhost:8000/api/contacts/2/"},"status":"No Content","code":204,"_postman_previewlanguage":"plain","header":[{"key":"Date","value":"Tue, 15 Dec 2020 02:13:14 GMT"},{"key":"Server","value":"WSGIServer/0.2 CPython/3.9.0"},{"key":"Vary","value":"Accept"},{"key":"X-Frame-Options","value":"DENY"},{"key":"Content-Length","value":"0"},{"key":"X-Content-Type-Options","value":"nosniff"},{"key":"Referrer-Policy","value":"same-origin"}],"cookie":[],"responseTime":null,"body":null}],"_postman_id":"f03feb68-8130-4ac1-b633-6ab8618fd92d"},{"name":"Delete Tuple","id":"b33da9a3-7a90-475f-92e1-121a86bc69d8","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"DELETE","header":[],"url":"http://localhost:8000/api/contacts/1/","urlObject":{"protocol":"http","port":"8000","path":["api","contacts","1",""],"host":["localhost"],"query":[],"variable":[]}},"response":[{"id":"ace833b2-c2e7-41d1-ba2f-30df0b64ea04","name":"Delete Tuple","originalRequest":{"method":"DELETE","header":[],"url":"http://localhost:8000/api/contacts/1/"},"status":"No Content","code":204,"_postman_previewlanguage":"plain","header":[{"key":"Date","value":"Tue, 15 Dec 2020 02:13:46 GMT"},{"key":"Server","value":"WSGIServer/0.2 CPython/3.9.0"},{"key":"Vary","value":"Accept"},{"key":"X-Frame-Options","value":"DENY"},{"key":"Content-Length","value":"0"},{"key":"X-Content-Type-Options","value":"nosniff"},{"key":"Referrer-Policy","value":"same-origin"}],"cookie":[],"responseTime":null,"body":null}],"_postman_id":"b33da9a3-7a90-475f-92e1-121a86bc69d8"},{"name":"Get Result","id":"3654f9cd-6655-4d6b-8332-dcfab09873d8","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"GET","header":[],"url":"http://localhost:8000/api/contacts/","urlObject":{"protocol":"http","port":"8000","path":["api","contacts",""],"host":["localhost"],"query":[],"variable":[]}},"response":[{"id":"66828c07-4cc0-4e11-b2d3-a5c31c42f459","name":"Get Result","originalRequest":{"method":"GET","header":[],"url":"http://localhost:8000/api/contacts/"},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"Date","value":"Tue, 15 Dec 2020 02:14:08 GMT"},{"key":"Server","value":"WSGIServer/0.2 CPython/3.9.0"},{"key":"Content-Type","value":"application/json"},{"key":"Vary","value":"Accept"},{"key":"Cache-Control","value":"no-cache"},{"key":"X-Frame-Options","value":"DENY"},{"key":"Content-Length","value":"194"},{"key":"X-Content-Type-Options","value":"nosniff"},{"key":"Referrer-Policy","value":"same-origin"}],"cookie":[],"responseTime":null,"body":"{\n \"meta\": {\n \"limit\": 20,\n \"next\": null,\n \"offset\": 0,\n \"previous\": null,\n \"total_count\": 1\n },\n \"objects\": [\n {\n \"Admin_id\": 1,\n \"Man_name\": \"The Pokemon Group\",\n \"id\": 2,\n \"resource_uri\": \"/api/contacts/2/\"\n }\n ]\n}"}],"_postman_id":"3654f9cd-6655-4d6b-8332-dcfab09873d8"}],"id":"29546f0d-1766-4898-bd41-ee393e3dff41","description":"This includes information about the contact between the admin and manufacturer. The attributes are: Admin_id, Man_name.
\n","_postman_id":"29546f0d-1766-4898-bd41-ee393e3dff41"},{"name":"ORDER ","item":[{"name":"Populating the Table","id":"bc38ef00-5d9d-460b-ae35-133cabf089b2","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"POST","header":[],"body":{"mode":"raw","raw":"{\n \"Order_date\": \"20-10-2020 09:20:30\",\n \"Sale_price\":\"78\",\n \"Admin_id\":\"01\",\n \"Ship_method\":\"international\",\n \"Ship_date\":\"14/11/20\",\n \"Ship_address\":\"Melbourne\",\n \"Courier_name\":\"FedexPost\",\n \"Customer_id\":\"06\"\n}","options":{"raw":{"language":"json"}}},"url":"http://localhost:8000/api/order/?Sale_price=int&Shipment_method=char&Customer_id=int&Order_no=int&Admin_id=int&Courier_name=char&Order_date=date&Ship_date=date","urlObject":{"protocol":"http","port":"8000","path":["api","order",""],"host":["localhost"],"query":[{"description":{"content":"total price of the sale
\n","type":"text/plain"},"key":"Sale_price","value":"int"},{"description":{"content":"shipment method
\n","type":"text/plain"},"key":"Shipment_method","value":"char"},{"description":{"content":"id of customer
\n","type":"text/plain"},"key":"Customer_id","value":"int"},{"description":{"content":"order number
\n","type":"text/plain"},"key":"Order_no","value":"int"},{"description":{"content":"id of the admin initiating order
\n","type":"text/plain"},"key":"Admin_id","value":"int"},{"description":{"content":"courier through which order is sent
\n","type":"text/plain"},"key":"Courier_name","value":"char"},{"description":{"content":"Date of order
\n","type":"text/plain"},"key":"Order_date","value":"date"},{"description":{"content":"date of shipping
\n","type":"text/plain"},"key":"Ship_date","value":"date"}],"variable":[]}},"response":[{"id":"f13d479d-df8b-413e-9a96-2b6d9a24fea1","name":"Populating the Table","originalRequest":{"method":"POST","header":[],"body":{"mode":"raw","raw":"{\n \"Order_date\": \"20-10-2020 09:20:30\",\n \"Sale_price\":\"78\",\n \"Admin_id\":\"01\",\n \"Ship_method\":\"international\",\n \"Ship_date\":\"14/11/20\",\n \"Ship_address\":\"Melbourne\",\n \"Courier_name\":\"FedexPost\",\n \"Customer_id\":\"06\"\n}","options":{"raw":{"language":"json"}}},"url":{"raw":"http://localhost:8000/api/order/?Sale_price=int&Shipment_method=char&Customer_id=int&Order_no=int&Admin_id=int&Courier_name=char&Order_date=date&Ship_date=date","protocol":"http","host":["localhost"],"port":"8000","path":["api","order",""],"query":[{"key":"Sale_price","value":"int","description":"total price of the sale"},{"key":"Shipment_method","value":"char","description":"shipment method"},{"key":"Customer_id","value":"int","description":"id of customer"},{"key":"Order_no","value":"int","description":"order number"},{"key":"Admin_id","value":"int","description":"id of the admin initiating order"},{"key":"Courier_name","value":"char","description":"courier through which order is sent "},{"key":"Order_date","value":"date","description":"Date of order"},{"key":"Ship_date","value":"date","description":"date of shipping"}]}},"_postman_previewlanguage":null,"header":null,"cookie":[],"responseTime":null,"body":null}],"_postman_id":"bc38ef00-5d9d-460b-ae35-133cabf089b2"},{"name":"Retreiving data","id":"e440e6cd-64a6-4576-82b5-3ff385537449","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"GET","header":[],"url":"http://localhost:8000/api/order/","urlObject":{"protocol":"http","port":"8000","path":["api","order",""],"host":["localhost"],"query":[],"variable":[]}},"response":[{"id":"d96fbfd4-ad4a-48d4-9799-9f353c7710b3","name":"Retreiving data","originalRequest":{"method":"GET","header":[],"url":"http://localhost:8000/api/order/"},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"Date","value":"Tue, 15 Dec 2020 02:41:58 GMT"},{"key":"Server","value":"WSGIServer/0.2 CPython/3.9.0"},{"key":"Content-Type","value":"application/json"},{"key":"Vary","value":"Accept"},{"key":"Cache-Control","value":"no-cache"},{"key":"X-Frame-Options","value":"DENY"},{"key":"Content-Length","value":"460"},{"key":"X-Content-Type-Options","value":"nosniff"},{"key":"Referrer-Policy","value":"same-origin"}],"cookie":[],"responseTime":null,"body":"{\n \"meta\": {\n \"limit\": 20,\n \"next\": null,\n \"offset\": 0,\n \"previous\": null,\n \"total_count\": 2\n },\n \"objects\": [\n {\n \"Admin_id\": 1,\n \"Courier_name\": \"CPost\",\n \"Customer_id\": 3,\n \"Sale_price\": 56,\n \"Ship_address\": \"3456 21 ave\",\n \"Ship_method\": \"Ground\",\n \"id\": 1,\n \"resource_uri\": \"/api/order/1/\"\n },\n {\n \"Admin_id\": 1,\n \"Courier_name\": \"FedexPost\",\n \"Customer_id\": 6,\n \"Sale_price\": 78,\n \"Ship_address\": \"Melbourne\",\n \"Ship_method\": \"international\",\n \"id\": 2,\n \"resource_uri\": \"/api/order/2/\"\n }\n ]\n}"}],"_postman_id":"e440e6cd-64a6-4576-82b5-3ff385537449"},{"name":"Change Tuple","id":"6d5b2e8a-c21d-45f3-a754-25b850aabdbc","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"PUT","header":[],"body":{"mode":"raw","raw":"{\n \"Order_date\": \"20-10-2020 09:20:30\",\n \"Sale_price\":\"80\",\n \"Admin_id\":\"01\",\n \"Ship_method\":\"international\",\n \"Ship_date\":\"14/11/20\",\n \"Ship_address\":\"Melbourne\",\n \"Courier_name\":\"FedEx\",\n \"Customer_id\":\"06\"\n}","options":{"raw":{"language":"json"}}},"url":"http://localhost:8000/api/order/2/","urlObject":{"protocol":"http","port":"8000","path":["api","order","2",""],"host":["localhost"],"query":[],"variable":[]}},"response":[{"id":"bd584ceb-6410-4959-bc18-a87d01844bd4","name":"Change Tuple","originalRequest":{"method":"PUT","header":[],"body":{"mode":"raw","raw":"{\n \"Order_date\": \"20-10-2020 09:20:30\",\n \"Sale_price\":\"80\",\n \"Admin_id\":\"01\",\n \"Ship_method\":\"international\",\n \"Ship_date\":\"14/11/20\",\n \"Ship_address\":\"Melbourne\",\n \"Courier_name\":\"FedEx\",\n \"Customer_id\":\"06\"\n}","options":{"raw":{"language":"json"}}},"url":"http://localhost:8000/api/order/2/"},"status":"No Content","code":204,"_postman_previewlanguage":"plain","header":[{"key":"Date","value":"Tue, 15 Dec 2020 02:46:46 GMT"},{"key":"Server","value":"WSGIServer/0.2 CPython/3.9.0"},{"key":"Vary","value":"Accept"},{"key":"X-Frame-Options","value":"DENY"},{"key":"Content-Length","value":"0"},{"key":"X-Content-Type-Options","value":"nosniff"},{"key":"Referrer-Policy","value":"same-origin"}],"cookie":[],"responseTime":null,"body":null}],"_postman_id":"6d5b2e8a-c21d-45f3-a754-25b850aabdbc"},{"name":"Delete Tuple","id":"2a7b328d-8e4b-49b2-b59e-db03b69f3ac8","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"DELETE","header":[],"url":"http://localhost:8000/api/order/1/","urlObject":{"protocol":"http","port":"8000","path":["api","order","1",""],"host":["localhost"],"query":[],"variable":[]}},"response":[{"id":"2f6701e9-fbb7-45a7-a679-c2d5aa9251a2","name":"Delete Tuple","originalRequest":{"method":"DELETE","header":[],"url":"http://localhost:8000/api/order/1/"},"status":"No Content","code":204,"_postman_previewlanguage":"plain","header":[{"key":"Date","value":"Tue, 15 Dec 2020 02:47:29 GMT"},{"key":"Server","value":"WSGIServer/0.2 CPython/3.9.0"},{"key":"Vary","value":"Accept"},{"key":"X-Frame-Options","value":"DENY"},{"key":"Content-Length","value":"0"},{"key":"X-Content-Type-Options","value":"nosniff"},{"key":"Referrer-Policy","value":"same-origin"}],"cookie":[],"responseTime":null,"body":null}],"_postman_id":"2a7b328d-8e4b-49b2-b59e-db03b69f3ac8"},{"name":"Get Result","id":"9bb04d5e-d40d-4220-a0f2-7c6bc228af16","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"GET","header":[],"url":"http://localhost:8000/api/order/","urlObject":{"protocol":"http","port":"8000","path":["api","order",""],"host":["localhost"],"query":[],"variable":[]}},"response":[{"id":"8f214ce7-1de9-439d-810b-3408e6c42ac0","name":"Get Result","originalRequest":{"method":"GET","header":[],"url":"http://localhost:8000/api/order/"},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"Date","value":"Tue, 15 Dec 2020 02:47:54 GMT"},{"key":"Server","value":"WSGIServer/0.2 CPython/3.9.0"},{"key":"Content-Type","value":"application/json"},{"key":"Vary","value":"Accept"},{"key":"Cache-Control","value":"no-cache"},{"key":"X-Frame-Options","value":"DENY"},{"key":"Content-Length","value":"280"},{"key":"X-Content-Type-Options","value":"nosniff"},{"key":"Referrer-Policy","value":"same-origin"}],"cookie":[],"responseTime":null,"body":"{\n \"meta\": {\n \"limit\": 20,\n \"next\": null,\n \"offset\": 0,\n \"previous\": null,\n \"total_count\": 1\n },\n \"objects\": [\n {\n \"Admin_id\": 1,\n \"Courier_name\": \"FedEx\",\n \"Customer_id\": 6,\n \"Sale_price\": 80,\n \"Ship_address\": \"Melbourne\",\n \"Ship_method\": \"international\",\n \"id\": 2,\n \"resource_uri\": \"/api/order/2/\"\n }\n ]\n}"}],"_postman_id":"9bb04d5e-d40d-4220-a0f2-7c6bc228af16"}],"id":"bf884411-ea09-48e1-bbce-6bb662ebc9a8","description":"Contains information regarding the order. The attributes included are: Order_no, Order_date, Sale_price, Admin_id, Ship_method, Ship_date, Courier_name, Customer_id.
\n","_postman_id":"bf884411-ea09-48e1-bbce-6bb662ebc9a8"},{"name":"ORDER ITEM","item":[{"name":"Populating the table","id":"614f31cc-807a-4a01-86d1-266f81f27b79","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"POST","header":[],"body":{"mode":"raw","raw":"{\n \"Order_no\":\"03\",\n \"Item_code\":\"01\",\n \"Quantity\":\"6\",\n \"Price\":\"7\"\n}","options":{"raw":{"language":"json"}}},"url":"http://localhost:8000/api/order_item/?Order_no=int&Item_code=int&Quantity=int&Price=int","urlObject":{"protocol":"http","port":"8000","path":["api","order_item",""],"host":["localhost"],"query":[{"description":{"content":"order number
\n","type":"text/plain"},"key":"Order_no","value":"int"},{"description":{"content":"code of the item in the system
\n","type":"text/plain"},"key":"Item_code","value":"int"},{"description":{"content":"Quantity ordered
\n","type":"text/plain"},"key":"Quantity","value":"int"},{"description":{"content":"price of single item
\n","type":"text/plain"},"key":"Price","value":"int"}],"variable":[]}},"response":[{"id":"24e84b1b-6cdc-4e23-b065-c6b083053e7d","name":"Populating the table","originalRequest":{"method":"POST","header":[],"body":{"mode":"raw","raw":"{\n \"Order_no\":\"03\",\n \"Item_code\":\"01\",\n \"Quantity\":\"6\",\n \"Price\":\"7\"\n}","options":{"raw":{"language":"json"}}},"url":"http://localhost:8000/api/order_item/"},"status":"Created","code":201,"_postman_previewlanguage":"html","header":[{"key":"Date","value":"Tue, 15 Dec 2020 02:52:21 GMT"},{"key":"Server","value":"WSGIServer/0.2 CPython/3.9.0"},{"key":"Content-Type","value":"text/html; charset=utf-8"},{"key":"Location","value":"/api/order_item/2/"},{"key":"Vary","value":"Accept"},{"key":"X-Frame-Options","value":"DENY"},{"key":"Content-Length","value":"0"},{"key":"X-Content-Type-Options","value":"nosniff"},{"key":"Referrer-Policy","value":"same-origin"}],"cookie":[],"responseTime":null,"body":null}],"_postman_id":"614f31cc-807a-4a01-86d1-266f81f27b79"},{"name":"Retreiving data ","id":"19ea889a-deaa-4590-8881-5a079d955eba","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"GET","header":[],"url":"http://localhost:8000/api/order_item/","urlObject":{"protocol":"http","port":"8000","path":["api","order_item",""],"host":["localhost"],"query":[],"variable":[]}},"response":[{"id":"b0d568ac-6636-498d-a2ee-d55806e42492","name":"Retreiving data ","originalRequest":{"method":"GET","header":[],"url":"http://localhost:8000/api/order_item/"},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"Date","value":"Tue, 15 Dec 2020 02:53:57 GMT"},{"key":"Server","value":"WSGIServer/0.2 CPython/3.9.0"},{"key":"Content-Type","value":"application/json"},{"key":"Vary","value":"Accept"},{"key":"Cache-Control","value":"no-cache"},{"key":"X-Frame-Options","value":"DENY"},{"key":"Content-Length","value":"314"},{"key":"X-Content-Type-Options","value":"nosniff"},{"key":"Referrer-Policy","value":"same-origin"}],"cookie":[],"responseTime":null,"body":"{\n \"meta\": {\n \"limit\": 20,\n \"next\": null,\n \"offset\": 0,\n \"previous\": null,\n \"total_count\": 2\n },\n \"objects\": [\n {\n \"Item_code\": 4,\n \"Order_no\": 1,\n \"Price\": 10,\n \"Quantity\": 3,\n \"id\": 1,\n \"resource_uri\": \"/api/order_item/1/\"\n },\n {\n \"Item_code\": 1,\n \"Order_no\": 3,\n \"Price\": 7,\n \"Quantity\": 6,\n \"id\": 2,\n \"resource_uri\": \"/api/order_item/2/\"\n }\n ]\n}"}],"_postman_id":"19ea889a-deaa-4590-8881-5a079d955eba"},{"name":"Change Tuple","id":"a352c565-39af-4c3a-b882-346f2fb01321","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"PUT","header":[],"body":{"mode":"raw","raw":"{\n \"Order_no\":\"03\",\n \"Item_code\":\"01\",\n \"Quantity\":\"10\",\n \"Price\":\"5\"\n}","options":{"raw":{"language":"json"}}},"url":"http://localhost:8000/api/order_item/2/","urlObject":{"protocol":"http","port":"8000","path":["api","order_item","2",""],"host":["localhost"],"query":[],"variable":[]}},"response":[{"id":"47cad48c-984a-47b4-b4e1-0bda879b1e23","name":"Change Tuple","originalRequest":{"method":"PUT","header":[],"body":{"mode":"raw","raw":"{\n \"Order_no\":\"03\",\n \"Item_code\":\"01\",\n \"Quantity\":\"10\",\n \"Price\":\"5\"\n}","options":{"raw":{"language":"json"}}},"url":"http://localhost:8000/api/order_item/2/"},"status":"No Content","code":204,"_postman_previewlanguage":"plain","header":[{"key":"Date","value":"Tue, 15 Dec 2020 02:56:13 GMT"},{"key":"Server","value":"WSGIServer/0.2 CPython/3.9.0"},{"key":"Vary","value":"Accept"},{"key":"X-Frame-Options","value":"DENY"},{"key":"Content-Length","value":"0"},{"key":"X-Content-Type-Options","value":"nosniff"},{"key":"Referrer-Policy","value":"same-origin"}],"cookie":[],"responseTime":null,"body":null}],"_postman_id":"a352c565-39af-4c3a-b882-346f2fb01321"},{"name":"Delete Tuple","id":"f5d9dd13-5c7c-4418-a0f1-e6a2bd1bf418","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"DELETE","header":[],"url":"http://localhost:8000/api/order_item/1/","urlObject":{"protocol":"http","port":"8000","path":["api","order_item","1",""],"host":["localhost"],"query":[],"variable":[]}},"response":[{"id":"85793111-8bb6-48d6-9433-c56444537f5b","name":"Delete Tuple","originalRequest":{"method":"DELETE","header":[],"url":"http://localhost:8000/api/order_item/1/"},"status":"No Content","code":204,"_postman_previewlanguage":"plain","header":[{"key":"Date","value":"Tue, 15 Dec 2020 02:56:54 GMT"},{"key":"Server","value":"WSGIServer/0.2 CPython/3.9.0"},{"key":"Vary","value":"Accept"},{"key":"X-Frame-Options","value":"DENY"},{"key":"Content-Length","value":"0"},{"key":"X-Content-Type-Options","value":"nosniff"},{"key":"Referrer-Policy","value":"same-origin"}],"cookie":[],"responseTime":null,"body":null}],"_postman_id":"f5d9dd13-5c7c-4418-a0f1-e6a2bd1bf418"},{"name":"Get Result","id":"b136723b-5b99-4d76-a4eb-516efe411c05","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"GET","header":[],"url":"http://localhost:8000/api/order_item/","urlObject":{"protocol":"http","port":"8000","path":["api","order_item",""],"host":["localhost"],"query":[],"variable":[]}},"response":[{"id":"4cde709e-5dd2-4f02-ad99-299f56c24150","name":"Get Result","originalRequest":{"method":"GET","header":[],"url":"http://localhost:8000/api/order_item/"},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"Date","value":"Tue, 15 Dec 2020 02:57:20 GMT"},{"key":"Server","value":"WSGIServer/0.2 CPython/3.9.0"},{"key":"Content-Type","value":"application/json"},{"key":"Vary","value":"Accept"},{"key":"Cache-Control","value":"no-cache"},{"key":"X-Frame-Options","value":"DENY"},{"key":"Content-Length","value":"207"},{"key":"X-Content-Type-Options","value":"nosniff"},{"key":"Referrer-Policy","value":"same-origin"}],"cookie":[],"responseTime":null,"body":"{\n \"meta\": {\n \"limit\": 20,\n \"next\": null,\n \"offset\": 0,\n \"previous\": null,\n \"total_count\": 1\n },\n \"objects\": [\n {\n \"Item_code\": 1,\n \"Order_no\": 3,\n \"Price\": 5,\n \"Quantity\": 10,\n \"id\": 2,\n \"resource_uri\": \"/api/order_item/2/\"\n }\n ]\n}"}],"_postman_id":"b136723b-5b99-4d76-a4eb-516efe411c05"}],"id":"e40758d6-f458-472d-b1c8-2db1386ee09b","description":"Contains information regarding the items in specific orders. The attributes of the table are: Order_no, Item_code, Quantity, Price.
\n","event":[{"listen":"prerequest","script":{"id":"4e13cfb5-24e4-4428-a610-98030cdf894d","type":"text/javascript","exec":[""]}},{"listen":"test","script":{"id":"03512eea-30d4-44c0-8f6f-312c47cc4e7b","type":"text/javascript","exec":[""]}}],"_postman_id":"e40758d6-f458-472d-b1c8-2db1386ee09b"},{"name":"COURIER","item":[{"name":"Populating the table","id":"7642fa7c-e5cd-48d8-8de3-e194cf00d4ea","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"POST","header":[],"body":{"mode":"raw","raw":"{\n \"Name\":\"CPost\",\n \"Branch\":\"downtown\"\n}","options":{"raw":{"language":"json"}}},"url":"http://localhost:8000/api/courier/?Name=char&Branch=char","urlObject":{"protocol":"http","port":"8000","path":["api","courier",""],"host":["localhost"],"query":[{"description":{"content":"name of post
\n","type":"text/plain"},"key":"Name","value":"char"},{"description":{"content":"branch if the post
\n","type":"text/plain"},"key":"Branch","value":"char"}],"variable":[]}},"response":[{"id":"f7d50a82-7bdb-40e3-bddf-b6d737f09d79","name":"Populating the table","originalRequest":{"method":"POST","header":[],"body":{"mode":"raw","raw":"{\n \"Name\":\"CPost\",\n \"Branch\":\"downtown\"\n}","options":{"raw":{"language":"json"}}},"url":"http://localhost:8000/api/courier/"},"status":"Created","code":201,"_postman_previewlanguage":"html","header":[{"key":"Date","value":"Tue, 15 Dec 2020 02:59:37 GMT"},{"key":"Server","value":"WSGIServer/0.2 CPython/3.9.0"},{"key":"Content-Type","value":"text/html; charset=utf-8"},{"key":"Location","value":"/api/courier/5/"},{"key":"Vary","value":"Accept"},{"key":"X-Frame-Options","value":"DENY"},{"key":"Content-Length","value":"0"},{"key":"X-Content-Type-Options","value":"nosniff"},{"key":"Referrer-Policy","value":"same-origin"}],"cookie":[],"responseTime":null,"body":null}],"_postman_id":"7642fa7c-e5cd-48d8-8de3-e194cf00d4ea"},{"name":"Retreiving the data","id":"e20c3d83-331b-4e0f-a4f2-910f942986ed","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"GET","header":[],"url":"http://localhost:8000/api/courier/","urlObject":{"protocol":"http","port":"8000","path":["api","courier",""],"host":["localhost"],"query":[],"variable":[]}},"response":[{"id":"39cecf83-b3aa-49a6-a34b-0f605d9af4cc","name":"Retreiving the data","originalRequest":{"method":"GET","header":[],"url":"http://localhost:8000/api/courier/"},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"Date","value":"Tue, 15 Dec 2020 02:59:59 GMT"},{"key":"Server","value":"WSGIServer/0.2 CPython/3.9.0"},{"key":"Content-Type","value":"application/json"},{"key":"Vary","value":"Accept"},{"key":"Cache-Control","value":"no-cache"},{"key":"X-Frame-Options","value":"DENY"},{"key":"Content-Length","value":"354"},{"key":"X-Content-Type-Options","value":"nosniff"},{"key":"Referrer-Policy","value":"same-origin"}],"cookie":[],"responseTime":null,"body":"{\n \"meta\": {\n \"limit\": 20,\n \"next\": null,\n \"offset\": 0,\n \"previous\": null,\n \"total_count\": 3\n },\n \"objects\": [\n {\n \"Branch\": \"deerfoot\",\n \"Name\": \"FedEx\",\n \"id\": 3,\n \"resource_uri\": \"/api/courier/3/\"\n },\n {\n \"Branch\": \"downtown\",\n \"Name\": \"CPost\",\n \"id\": 4,\n \"resource_uri\": \"/api/courier/4/\"\n },\n {\n \"Branch\": \"downtown\",\n \"Name\": \"CPost\",\n \"id\": 5,\n \"resource_uri\": \"/api/courier/5/\"\n }\n ]\n}"}],"_postman_id":"e20c3d83-331b-4e0f-a4f2-910f942986ed"},{"name":"Change Tuple","id":"e9c67a3e-5b94-40f4-9ce9-c820d1b73cee","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"PUT","header":[],"body":{"mode":"raw","raw":"{\n \"Branch\":\"NorthEast\"\n}","options":{"raw":{"language":"json"}}},"url":"http://localhost:8000/api/courier/5/","urlObject":{"protocol":"http","port":"8000","path":["api","courier","5",""],"host":["localhost"],"query":[],"variable":[]}},"response":[{"id":"4b2fb06d-57df-4fc0-b201-52fcce95562d","name":"Change Tuple","originalRequest":{"method":"PUT","header":[],"body":{"mode":"raw","raw":"{\n \"Branch\":\"NorthEast\"\n}","options":{"raw":{"language":"json"}}},"url":"http://localhost:8000/api/courier/5/"},"status":"No Content","code":204,"_postman_previewlanguage":"plain","header":[{"key":"Date","value":"Tue, 15 Dec 2020 03:02:06 GMT"},{"key":"Server","value":"WSGIServer/0.2 CPython/3.9.0"},{"key":"Vary","value":"Accept"},{"key":"X-Frame-Options","value":"DENY"},{"key":"Content-Length","value":"0"},{"key":"X-Content-Type-Options","value":"nosniff"},{"key":"Referrer-Policy","value":"same-origin"}],"cookie":[],"responseTime":null,"body":null}],"_postman_id":"e9c67a3e-5b94-40f4-9ce9-c820d1b73cee"},{"name":"Delete Tuple","id":"654a26cb-a600-42e2-aa42-c6f0c5ca92a1","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"DELETE","header":[],"url":"http://localhost:8000/api/courier/4/","urlObject":{"protocol":"http","port":"8000","path":["api","courier","4",""],"host":["localhost"],"query":[],"variable":[]}},"response":[],"_postman_id":"654a26cb-a600-42e2-aa42-c6f0c5ca92a1"},{"name":"Get Result","id":"276c1f63-3772-425e-b4ab-09015ada7cdb","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"GET","header":[],"url":"http://localhost:8000/api/courier/","urlObject":{"protocol":"http","port":"8000","path":["api","courier",""],"host":["localhost"],"query":[],"variable":[]}},"response":[{"id":"93218c5d-14bd-4a1a-b25a-4104b7efa791","name":"Get Result","originalRequest":{"method":"GET","header":[],"url":"http://localhost:8000/api/courier/"},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"Date","value":"Tue, 15 Dec 2020 03:03:26 GMT"},{"key":"Server","value":"WSGIServer/0.2 CPython/3.9.0"},{"key":"Content-Type","value":"application/json"},{"key":"Vary","value":"Accept"},{"key":"Cache-Control","value":"no-cache"},{"key":"X-Frame-Options","value":"DENY"},{"key":"Content-Length","value":"270"},{"key":"X-Content-Type-Options","value":"nosniff"},{"key":"Referrer-Policy","value":"same-origin"}],"cookie":[],"responseTime":null,"body":"{\n \"meta\": {\n \"limit\": 20,\n \"next\": null,\n \"offset\": 0,\n \"previous\": null,\n \"total_count\": 2\n },\n \"objects\": [\n {\n \"Branch\": \"deerfoot\",\n \"Name\": \"FedEx\",\n \"id\": 3,\n \"resource_uri\": \"/api/courier/3/\"\n },\n {\n \"Branch\": \"NorthEast\",\n \"Name\": \"CPost\",\n \"id\": 5,\n \"resource_uri\": \"/api/courier/5/\"\n }\n ]\n}"}],"_postman_id":"276c1f63-3772-425e-b4ab-09015ada7cdb"}],"id":"ab972037-191f-48af-a132-62e45d85c4d9","description":"Includes information about the different couruers used. The attributes od teh table are: Name, Branch.
\n","_postman_id":"ab972037-191f-48af-a132-62e45d85c4d9"},{"name":"DELIVERS TO ","item":[{"name":"Populating Table","id":"0bb603b9-72fc-47d7-a4e4-3dc6bbb257e9","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"POST","header":[],"body":{"mode":"raw","raw":"{\n \"Courier_name\":\"FedEx\",\n \"Customer_id\":\"09\"\n}","options":{"raw":{"language":"json"}}},"url":"http://localhost:8000/api/delivers_to/?Customer_id=char&Courier_name=char","urlObject":{"protocol":"http","port":"8000","path":["api","delivers_to",""],"host":["localhost"],"query":[{"description":{"content":"id of the cutomer package is being delivered to
\n","type":"text/plain"},"key":"Customer_id","value":"char"},{"description":{"content":"name of courier delivering
\n","type":"text/plain"},"key":"Courier_name","value":"char"}],"variable":[]}},"response":[{"id":"86f56226-f655-4598-90c9-32ec9d0135da","name":"Populating Table","originalRequest":{"method":"POST","header":[],"body":{"mode":"raw","raw":"{\n \"Courier_name\":\"FedEx\",\n \"Customer_id\":\"09\"\n}","options":{"raw":{"language":"json"}}},"url":"http://localhost:8000/api/delivers_to/"},"status":"Created","code":201,"_postman_previewlanguage":"html","header":[{"key":"Date","value":"Tue, 15 Dec 2020 03:06:36 GMT"},{"key":"Server","value":"WSGIServer/0.2 CPython/3.9.0"},{"key":"Content-Type","value":"text/html; charset=utf-8"},{"key":"Location","value":"/api/delivers_to/2/"},{"key":"Vary","value":"Accept"},{"key":"X-Frame-Options","value":"DENY"},{"key":"Content-Length","value":"0"},{"key":"X-Content-Type-Options","value":"nosniff"},{"key":"Referrer-Policy","value":"same-origin"}],"cookie":[],"responseTime":null,"body":null}],"_postman_id":"0bb603b9-72fc-47d7-a4e4-3dc6bbb257e9"},{"name":"Retreiving data","id":"bb81082a-8d22-438a-9737-f8aab292395e","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"GET","header":[],"url":"http://localhost:8000/api/delivers_to/","urlObject":{"protocol":"http","port":"8000","path":["api","delivers_to",""],"host":["localhost"],"query":[],"variable":[]}},"response":[{"id":"36e4c858-0064-49b6-80f4-97f3e9df095d","name":"Retreiving data","originalRequest":{"method":"GET","header":[],"url":"http://localhost:8000/api/delivers_to/"},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"Date","value":"Tue, 15 Dec 2020 03:08:00 GMT"},{"key":"Server","value":"WSGIServer/0.2 CPython/3.9.0"},{"key":"Content-Type","value":"application/json"},{"key":"Vary","value":"Accept"},{"key":"Cache-Control","value":"no-cache"},{"key":"X-Frame-Options","value":"DENY"},{"key":"Content-Length","value":"285"},{"key":"X-Content-Type-Options","value":"nosniff"},{"key":"Referrer-Policy","value":"same-origin"}],"cookie":[],"responseTime":null,"body":"{\n \"meta\": {\n \"limit\": 20,\n \"next\": null,\n \"offset\": 0,\n \"previous\": null,\n \"total_count\": 2\n },\n \"objects\": [\n {\n \"Courier_name\": \"CPost\",\n \"Customer_id\": 3,\n \"id\": 1,\n \"resource_uri\": \"/api/delivers_to/1/\"\n },\n {\n \"Courier_name\": \"FedEx\",\n \"Customer_id\": 9,\n \"id\": 2,\n \"resource_uri\": \"/api/delivers_to/2/\"\n }\n ]\n}"}],"_postman_id":"bb81082a-8d22-438a-9737-f8aab292395e"},{"name":"Change Tuple","id":"2751c81f-f75b-478a-9cd2-4cdb4ece1d9e","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"PUT","header":[],"body":{"mode":"raw","raw":"{\n \"Courier_name\":\"Purolator\",\n \"Customer_id\":\"09\"\n}","options":{"raw":{"language":"json"}}},"url":"http://localhost:8000/api/delivers_to/2/","urlObject":{"protocol":"http","port":"8000","path":["api","delivers_to","2",""],"host":["localhost"],"query":[],"variable":[]}},"response":[{"id":"fa9d2cc3-ece7-4d9b-8a95-d4ceb7a6224a","name":"Change Tuple","originalRequest":{"method":"PUT","header":[],"body":{"mode":"raw","raw":"{\n \"Courier_name\":\"Purolator\",\n \"Customer_id\":\"09\"\n}","options":{"raw":{"language":"json"}}},"url":"http://localhost:8000/api/delivers_to/2/"},"status":"No Content","code":204,"_postman_previewlanguage":"plain","header":[{"key":"Date","value":"Tue, 15 Dec 2020 03:09:45 GMT"},{"key":"Server","value":"WSGIServer/0.2 CPython/3.9.0"},{"key":"Vary","value":"Accept"},{"key":"X-Frame-Options","value":"DENY"},{"key":"Content-Length","value":"0"},{"key":"X-Content-Type-Options","value":"nosniff"},{"key":"Referrer-Policy","value":"same-origin"}],"cookie":[],"responseTime":null,"body":null}],"_postman_id":"2751c81f-f75b-478a-9cd2-4cdb4ece1d9e"},{"name":"Delete Tuple","id":"4c975a96-0ea0-4d95-a93b-078f32fd1ab6","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"DELETE","header":[],"url":"http://localhost:8000/api/delivers_to/1/","urlObject":{"protocol":"http","port":"8000","path":["api","delivers_to","1",""],"host":["localhost"],"query":[],"variable":[]}},"response":[{"id":"432706d8-9763-48cb-bd77-1d38ddec832a","name":"Delete Tuple","originalRequest":{"method":"DELETE","header":[],"url":"http://localhost:8000/api/delivers_to/1/"},"status":"No Content","code":204,"_postman_previewlanguage":"plain","header":[{"key":"Date","value":"Tue, 15 Dec 2020 03:10:15 GMT"},{"key":"Server","value":"WSGIServer/0.2 CPython/3.9.0"},{"key":"Vary","value":"Accept"},{"key":"X-Frame-Options","value":"DENY"},{"key":"Content-Length","value":"0"},{"key":"X-Content-Type-Options","value":"nosniff"},{"key":"Referrer-Policy","value":"same-origin"}],"cookie":[],"responseTime":null,"body":null}],"_postman_id":"4c975a96-0ea0-4d95-a93b-078f32fd1ab6"},{"name":"Get Result","id":"e55fba18-9540-49f2-be46-ebeee7639f12","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"GET","header":[],"url":"http://localhost:8000/api/delivers_to/","urlObject":{"protocol":"http","port":"8000","path":["api","delivers_to",""],"host":["localhost"],"query":[],"variable":[]}},"response":[{"id":"bc6295e6-2b3c-45e3-a76d-428b6a684fe0","name":"Get Result","originalRequest":{"method":"GET","header":[],"url":"http://localhost:8000/api/delivers_to/"},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"Date","value":"Tue, 15 Dec 2020 03:10:35 GMT"},{"key":"Server","value":"WSGIServer/0.2 CPython/3.9.0"},{"key":"Content-Type","value":"application/json"},{"key":"Vary","value":"Accept"},{"key":"Cache-Control","value":"no-cache"},{"key":"X-Frame-Options","value":"DENY"},{"key":"Content-Length","value":"196"},{"key":"X-Content-Type-Options","value":"nosniff"},{"key":"Referrer-Policy","value":"same-origin"}],"cookie":[],"responseTime":null,"body":"{\n \"meta\": {\n \"limit\": 20,\n \"next\": null,\n \"offset\": 0,\n \"previous\": null,\n \"total_count\": 1\n },\n \"objects\": [\n {\n \"Courier_name\": \"Purolator\",\n \"Customer_id\": 9,\n \"id\": 2,\n \"resource_uri\": \"/api/delivers_to/2/\"\n }\n ]\n}"}],"_postman_id":"e55fba18-9540-49f2-be46-ebeee7639f12"}],"id":"6334affb-319c-4d82-8464-ec54ee9560bb","description":"Contains information about the courier and the customer it delivers to. The attributes of the table are: Customer_id, Courier_name.
\n","_postman_id":"6334affb-319c-4d82-8464-ec54ee9560bb"}]}