Skip to content

Database

Emily Parkes edited this page Mar 20, 2023 · 4 revisions

ERD

Expected Response:

[
	{
		"id": 1,
		"clayId": 1,
		"clay": "White",
		"shapeId": 5,
		"shape": "Vase",
		"statusId": 2,
		"status": "Leather Hard",
		"weightLeatherHard": 0,
		"weightBoneDry": 0,
		"weightBisqueFired": 0,
		"weightGlazed": 0,
		"weightComplete": 0,
		"dateCreated": "2020-06-15T13:45:30",
		"dateComplete": "2020-07-15T13:45:30",
		"description": "Creations by emily is great",
		"note": "Glaze with criss-cross pattern and details in black and white.",
		"name": "Le Vase",
		"imgLeatherHard": null,
		"imgBisqueFired": null,
		"imgGlazed": null,
		"imgComplete": "/images/vase.png",
		"imgGallery": null,
		"glazes": [
			{
				"id": 1,
				"glaze": "Clear"
			},
			{
				"id": 10,
				"glaze": "White"
			},
			{
				"id": 11,
				"glaze": "Peach"
			}
		]
	}, ...

Expected Response:

{
	"id": 1,
	"clayId": 1,
	"clay": "White",
	"shapeId": 5,
	"shape": "Vase",
	"statusId": 1,
	"status": "Wet",
	"weightLeatherHard": 0,
	"weightBoneDry": 0,
	"weightBisqueFired": 0,
	"weightGlazed": 0,
	"weightComplete": 0,
	"dateCreated": "2020-06-15T13:45:30",
	"dateComplete": "2020-07-15T13:45:30",
	"description": "Creations by emily is great",
	"note": "Glaze with criss-cross pattern",
	"name": "Slushie Apocalypse",
	"imgLeatherHard": null,
	"imgBisqueFired": null,
	"imgGlazed": null,
	"imgComplete": "/images/vase.png",
	"imgGallery": null,
	"glazes": [
		{
			"id": 1,
			"glaze": "Clear"
		},
		{
			"id": 9,
			"glaze": "Black"
		},
		{
			"id": 10,
			"glaze": "White"
		},
		{
			"id": 11,
			"glaze": "Peach"
		}
	]
}

Request Body:

{
	"description": "12333",
	"clayId": "2",
	"shapeId": "2",
	"statusId": "2",
  "glazes": [
    {"id": 1, "glaze": "Clear"},
    {"id": 8, "glaze": "Green Forrest"}
  ],
  "imgBisqueFired": null,
  "imgComplete": null,
  "imgGallery": null,
  "imgGlazed": null,
  "imgLeatherHard": null,
  "name": "ee",
  "note": "123",
  "weightBisqueFired": null,
  "weightBoneDry": null,
  "weightComplete": null,
  "weightGlazed": null,
  "weightLeatherHard": null
}

Expected Response:

{
	"id": 10,
	"clayId": 2,
	"clay": "Grey Pebble",
	"shapeId": 2,
	"shape": "Plate",
	"statusId": 2,
	"status": "Leather Hard",
	"weightLeatherHard": null,
	"weightBoneDry": null,
	"weightBisqueFired": null,
	"weightGlazed": null,
	"weightComplete": null,
	"dateCreated": null,
	"dateComplete": null,
	"description": "12333",
	"note": "123",
	"name": "ee",
	"imgLeatherHard": null,
	"imgBisqueFired": null,
	"imgGlazed": null,
	"imgComplete": null,
	"imgGallery": null,
	"glazes": [
		{
			"id": 1,
			"glaze": "Clear"
		},
		{
			"id": 8,
			"glaze": "Green Forrest"
		}
	]
}

Expected Response:

{
	"deleted": "1 item(s) have been deleted successfully"
}

Request Body:

{ 
"clayId": 1,
"date_complete": "2020-07-15T13:45:30",
"date_created": "2020-06-15T13:45:30", 
"description": "Creations by emily is great", 
"glazes": [ 
	{"id": 1, "glaze": "Clear"},
	{"id": 10, "glaze": "White"},
	{"id": 9, "glaze": "Black"} ], 
"id": 1, 
"img_bisque_fired": null, 
"img_complete": "/images/vase.png", 
"img_gallery": null, 
"img_glazed": null, 
"img_leather_hard": null, 
"name": "Le Vase", 
"note": "test 12", 
"shapeId": 5, 
"statusId": 2, 
"weight_bisque_fired": 0, 
"weight_bone_dry": 0, 
"weight_complete": 0, 
"weight_glazed": 0, 
"weight_leather_hard": 0
}

Expected Response:

{
	"id": 1,
	"clayId": 1,
	"clay": "White",
	"shapeId": 5,
	"shape": "Vase",
	"statusId": 2,
	"status": "Leather Hard",
	"weightLeatherHard": 0,
	"weightBoneDry": 0,
	"weightBisqueFired": 0,
	"weightGlazed": 0,
	"weightComplete": 0,
	"dateCreated": "2020-06-15T13:45:30",
	"dateComplete": "2020-07-15T13:45:30",
	"description": "Creations by emily is great",
	"note": "test 12",
	"name": "Le Vase",
	"imgLeatherHard": null,
	"imgBisqueFired": null,
	"imgGlazed": null,
	"imgComplete": "/images/vase.png",
	"imgGallery": null,
	"glazes": [
		{
			"glazeId": 1,
			"glaze": "Clear"
		},
		{
			"glazeId": 10,
			"glaze": "White"
		},
		{
			"glazeId": 9,
			"glaze": "Black"
		}
	]
}

Table of Contents

Design

Front-End

Back-End

Clone this wiki locally