THE GEIGER DATABASE


DATA TABLE STRUCTURES
DATABASE JGDB10 TABLES

TABLE DETAIL: MMJGINV

The structure of this table was designed to record descriptions of personal possessions belonging to John Geiger, particularly home furnishings and his art collection.

Note: The column labels shown within the table structures are historical references only, and do not reflect the definitions used within the version of the database being served through the website.

TABLE NOTES

Table MMJGINV contains 263 rows arranged in 17 columns.

The structure of the table is designed to provide description, note provenance or source, financial values including insurance, and storage location information. The entries in this table are evidence of the longstanding interest of Geiger in Art Nouveau, Asian, and Thonet Bentwood furniture, as well as show the extent of his investment and maintenance of his art collection.

ORIGINAL DATAEASE FORM SCREEN

MMJGNVl form

Document: DataEase table definition printout (PDF)

COLUMN LABELS

Column:[REC#] records an automatically assigned unique row identifier number for each row in this table.

Column: [DESCRIPTION] records a description of an object. Text may flow continously into [DESC2] and [DESC3].

Column: [TYPE] records a type for the object, using a selection list:

  • FURN (furnishings)
  • DECART (decorative arts)
  • APAREL (clothing)
  • KITWARE (kitchen ware)
  • CHINA (ceramics, including Asian art)
  • FLTWR (flatware, utensils)
  • EQUIP (equipment)
  • LCTRNC (electronic appliances)
  • PHOTO (photograph)
  • LIGHTG (lighting)
  • HSHLD (household)

Column: [OH] records the number of quantity on hand for an object.

Column: [SIZE] records the dimensions in inches of an object, usually in width/depth/height format.

Column: [DATE] records a date in format YYYY, sometimes with "c" for circa.

Column: [ORIG/REPRO] records whether an object is new, original, or a reproduction, using a selection list:

  • ORIG (original)
  • REPRO (reproduction)
  • NEW (new)

Column: [UNITRET] records original cost for an object.

Column: [RETVALUE] records a current retail value for an object.

Column: [INSURER#] records a number related to an insurance policy.

Column: [DESC2] records additional descriptive detail about an object.

Column: [X] records a single number ("1") for an unknown purpose.

Column: [DESC3] records additional descriptive detail about an object.

Column: [UNITCOST] records additional detail about cost associated with an object, usually indicating repairs or conservation expense. Few entries.

Column: [TCOST] records the total of Column [UNITCOST] multiplied by the count present in the row of Column [OH].

Column: [LOCATION] records a location for the object in the Geiger apartment on Westgate, using a selection list:

  • LIVING ROOM
  • DINING ROOM
  • KITCHEN
  • BEDROOM
  • BATHROOM
  • CORRIDOR
  • STAIRWELL
  • EXTERIOR BALCONY
  • ENTRANCE HALL
  • STUDIO
  • ON LOAN

Column: [LOCATION2] records a secondary location for objects with multiple quantities. Rarely used.

RELATED QUERY PROCEDURES

The data in this table is referenced in 3 query procedures devised by Geiger: