Photograph Table Definitions
The Photograph catalog consists of a single table that contains all the information that IMNH maintains about each photograph in the collection.

To select a desires field all one needs to do is select the field name. You do not need to pre-pend the table name onto the field name.
Click here for an Authoritative list of database entries.

Table: PhotographCatalogue
Columns
Name Type Size
PhotographNumber Text 20
AccessionNumber Text 8
TemporaryNumber Text 12
OtherNumber Text 15
YearNumber Long Integer 4
TransactionNumber Long Integer 4
ItemNumber Long Integer 4
Part Text 5
DocumentFile Text 25
CollectionName Text 50
TakenBy Text 35
EarliestDate Date/Time 8
LatestDate Date/Time 8
ProbableDate Text 25
TypeAndSizeOfOrigional Text 50
CopyNegativeAvaliable? Text 1
Copies Text 100
TypeOfImage Text 35
PersonsDepicted Text 125
PlacesShown Text 100
ObjectsShown Memo -
ActivitiesEventsShown Text 50
CrossReference Text 100
Presentation Text 50
Marks Text 100
Condition Text 25
CopyrightHolder Text 35
AddressLine1 Text 35
AddressLine2 Text 35
AddressLine3 Text 35
Restrictions Text 100
CreditLine Text 100
PublicationHistory Text 255
BibliographicReferences Text 100
Comments Memo -
CataloguedBy Text 35
CatalogueDate Date/Time 8
DataEntryBy Text 35
DataEntryDate Date/Time 8
photo Image -