ERD Diagram

ERD diagram can be found at dbdiagram.io

Table Details

Table users as U {
  id int [pk, increment] // auto-increment
  username string
  hash binary
  user_type string
}

Table clay {
  id int [pk, increment]
  clay string
  in_use boolean
`}

Table statuses {
  id int [pk, increment]
  status string
}

Table shapes {
  id int [pk, increment]
  shape string
}

Table glazes {
  id int [pk, increment]
  glaze string
  underglaze boolean
  in_use boolean
}

Table creation_glazes {
  id int [pk, increment]
  creation_id int [ref: <> creations.id]
  glaze_id int [ref: <> glazes.id]
}

Table creations {
  id int [pk, increment]
  clay int [ref: > clay.id]
  shape int [ref: > shapes.id]
  status int [ref: > statuses.id]
  weight_leather_hard int
  weight_bone_dry int
  weight_bisque_fired int
  weight_glazed int
  weight_complete int
  name string
  description text
  note text [note: 'Type of pattern/glaze style']
  date_created dateTime
  date_completed dateTime
  img_leather_hard string
  img_bisque_fired string
  img_glazed string
  img_complete string
  img_gallery string
}