Art inventory tracking custom database system for Windows
Art objects tracking system for the Swedish Medical Center Foundation.
Custom database development includes database definition, form design,
and database transfer from the old system.
meta data:
ID:Integer:
CATALOG_NO:Numeric:
ARTIST:Text:80
TITLE:Text:100
EDITION:Text:80
YEAR_:Text:80
ARTWORKDESCRIPTION:Text:100
PROVENANCE:Text:150
ACQUISITIONDATE:Date:
PURCHASECOST:Numeric:
CAMPUS:Text:80
BUILDING:Text:80
FLOOR:Text:80
LOCATIONDESCRIPTION:Text:150
CONDITIONNOTES:Memo:
TREATMENT:Memo:
NOTES:Memo:
PICTURE_1:Text:254
PICTURE_2:Text:254
MEDIUM:Text:150
DEPTH:Text:80
HEIGHT:Text:80
WIDTH:Text:80
FRAMEDDEPTH:Text:80
FRAMEDHEIGHT:Text:80
FRAMEDWIDTH:Text:80
DEACCESSIONED:Text:80
DEACCESSIONDATE:Date:
CURRENTAPPRAISALVALUE:Numeric:
APPRAISALDATE:Date:
LOCATIONPICTURE:Text:254
COLLECTIONSTATUS:Text:150
RELATIVEVALUE:Text:150
DONOR:Text:80
MONETARYVALUE:Text:254
REPAIRNEEDED:Text:80
KEYPIECE:Text:80
DVS3D:Text:80
TOURPIECE:Text:80
CASEDEPTH:Text:80
CASEHEIGHT:Text:80
CASEWIDTH:Text:80
SIGNATURE:Text:80
LOCATIONNOTES:Memo:
ACQUISITIONMETHOD:Text:80
CURRENTVALUE:Numeric:
RETAILVALUE:Numeric:
DEACCESSIONEDMETHOD:Text:80
DEACCESSIONRECIPIENT:Text:80
FINANCIALNOTES:Memo:
RELEASEONFILE:Text:80
RELEASENOTES:Memo:
USEINSMCMATERIALS:Memo: