About the Database

Utensil Table

Utensil Relationship Diagram

Utensil Relationship Diagram

Field Name: Artifact ID Number

Field Name: Artifact Count

Field Name: Completeness
Authority Terms:

  1. Complete
  2. Incomplete

Field Name: Utensil Form
Authority Terms:

  1. 1 Piece: unid.
  2. 2 Piece: unid.
  3. Fork, 1 Piece
  4. Fork, 2 piece
  5. Knife, 1 Piece
  6. Knife, 2 Piece
  7. Knife, unid.
  8. Spoon, 1 Piece
  9. Spoon, 2 Piece
  10. Unidentifiable

Field Name: Plating
Authority Terms:

  1. Gold
  2. None
  3. Silver
  4. Tin
  5. Unidentifiable

Field Name: Handle Decoration
Authority Terms:

  1. Carved
  2. Inlay
  3. Molded
  4. None
  5. Not Applicable
  6. Painted under
  7. Unidentifiable

Field Name: Spoon Rat Tail
Authority Terms:

  1. Yes
  2. No
  3. N/A (Not Applicable)
  4. N/R (Not Recorded)

Field Name: Burned
Authority Terms:

  1. Yes
  2. No
  3. N/A (Not Applicable)
  4. N/R (Not Recorded)

Field Name: Marks?

Field Name: Conserved?

Field Name: Mended?
Authority Terms

  1. Yes
  2. No
  3. N/A (Not Applicable)
  4. N/R (Not Recorded)

Field Name: Post-Manufacturing Modification
Authority Terms:

  1. Yes
  2. No
  3. N/A (Not Applicable)
  4. N/R (Not Recorded)

Field Name:Object Length in millimeters

Field Name:Object Width in millimeters

Field Name: Object Weight in grams

Field Name: Fork: Number of Tines
Authority Terms:

  1. Not Applicable
  2. Two
  3. Three
  4. Four

Field Name: Added By

Field Name: Date Added

Field Name: Changed By

Field Name: Date Changed

Field Name: Notes

Related Table: Utensil Specifics

Field Name: Part
Authority Terms:

  1. Blade
  2. Bowl
  3. Handle
  4. Stem
  5. Tang
  6. Tine
  7. Unidentifiable

Field Name: Shape
Authority Terms:

  1. Round End
  2. Square End
  3. Pistol Grip
  4. Unidentifiable

Field Name: Manufacturing Technique
Authority Terms:

  1. Cast
  2. Forged
  3. Missing
  4. Not Applicable
  5. Not in List
  6. Unidentifiable

Field Name: Utensil Material (applies to one piece utensils and for the metal portion of a handled utensil.)
Authority Terms:

  1. Brass
  2. Iron
  3. Latten
  4. Missing
  5. Not Applicable
  6. Not in List
  7. Other
  8. Pewter
  9. Silver
  10. Steel
  11. Unidentifiable

Field Name: Length (of Part) in millimeters

Field Name: Width (of Part) in millimeters

Field Name: Height (of Part) in millimeters