THE GEIGER DATABASE


DATA TABLE STRUCTURES
DATABASE JGDB10 TABLES

TABLE DETAIL: STATUS

The structure of this table was designed to record the existential status of Frank Lloyd Wright commissions.

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 STATUS contains 3 rows arranged in 3 columns.

Thes table has three row entries to describe Wright designs as:

  • PJT: Project or designed but not executed work
  • EXE: Executed work, building, decorative arts, etc.
  • DMD: Demolished or lost work

There appears to be no active use of this table. The same status options are found as a choice list built into Column [SYMBOL] of Table MMTFDRAWINGS FILE.

ORIGINAL DATAEASE FORM SCREEN

STATUS form

Document: Dataease table definition printout (PDF)

COLUMN LABELS

Column: [IDENTIFICATION] records a unique number for each row in the table.

Column: [SYMBOL] records a term indicating status of a Wright design or building.

Column: [DESCRIPTION] records the term defining the abbreviation found in rows of column [SYMBOL].

RELATED QUERY PROCEDURES

This table is not referenced directly in any of the query procedures devised by Geiger.