Table Head (th) |
---|
CSpace destination |
Table Head (th) |
---|
Migrated? |
Table Row (tr) |
---|
Table Cell (td) |
---|
MediaArchTypes |
Table Cell (td) |
---|
Do not import — not needed or used |
|
Table Row (tr) |
---|
Table Cell (td) |
---|
MediaColorDepths |
Table Cell (td) |
---|
Do not import — simplistic, 3-term list: "true color", "1“true color”, “1-bit grayscale"grayscale”, "8“8-bit grayscale" grayscale” — presumably superseded by CSpace list/functionality |
|
Table Row (tr) |
---|
Table Cell (td) |
---|
MediaCounts |
Table Cell (td) |
---|
Do not import — for TMS internal use |
|
Table Row (tr) |
---|
Table Cell (td) |
---|
MediaExtensions |
Table Cell (td) |
---|
Do not import — controlled list presumably superseded by CSpace list/functionality |
|
Table Row (tr) |
---|
Table Cell (td) |
---|
MediaFiles |
Table Cell (td) |
---|
ArchCatNum |
Table Cell (td) |
---|
Do not import — always null |
|
Table Row (tr) |
---|
Table Cell (td) |
---|
ArchFilename |
Table Cell (td) |
---|
Do not import — always null |
|
Table Row (tr) |
---|
Table Cell (td) |
---|
Do not import — always null |
|
Table Row (tr) |
---|
Table Cell (td) |
---|
ArchSubDir |
Table Cell (td) |
---|
Do not import — always null |
|
Table Row (tr) |
---|
Table Cell (td) |
---|
ArchTypeID |
Table Cell (td) |
---|
Do not import — always 0 |
|
Table Row (tr) |
---|
Table Cell (td) |
---|
ArchVolName |
Table Cell (td) |
---|
Do not import — always null |
|
Table Row (tr) |
---|
Table Cell (td) |
---|
ColorDepthID |
Table Cell (td) |
---|
Needed? Superseded by CSpace functionality? |
|
Table Row (tr) |
---|
Table Cell (td) |
---|
Do not import — always 0 |
|
Table Row (tr) |
---|
Table Cell (td) |
---|
EnteredDate |
Table Cell (td) |
---|
Only if useful for versioning context. |
|
Table Row (tr) |
---|
Table Cell (td) |
---|
Migrate if not automatically extracted upon import |
|
Table Row (tr) |
---|
Table Cell (td) |
---|
Do not import — use as PK for table |
|
Table Row (tr) |
---|
Table Cell (td) |
---|
Migrate if not automatically extracted upon import |
|
Table Row (tr) |
---|
Table Cell (td) |
---|
WHERE FileSize <> 0 |
|
Table Row (tr) |
---|
Table Cell (td) |
---|
use as FK to MediaFormats.FormatID to get format info. |
|
Table Row (tr) |
---|
Table Cell (td) |
---|
use as FK to Users.Login, then use Users.MTB_ConstituentID as FK to Constituents.ConstituentID to get person's info |
Table Cell (td) |
---|
Only if useful for attribution content. |
|
Table Row (tr) |
---|
Table Cell (td) |
---|
MemorySize |
|
Table Row (tr) |
---|
Table Cell (td) |
---|
use as FK to MediaPaths.PathID to get file location |
|
Table Row (tr) |
---|
Table Cell (td) |
---|
RenditionID |
Table Cell (td) |
---|
Needed? Useful if importing unlinked images |
|
Table Row (tr) |
---|
Table Cell (td) |
---|
MediaFormats |
Table Cell (td) |
---|
Do not import — controlled list presumably superseded by CSpace list/functionality |
|
Table Row (tr) |
---|
Table Cell (td) |
---|
MediaMaster |
Table Cell (td) |
---|
AgreementSignedDate |
Table Cell (td) |
---|
Do not import |
|
Table Row (tr) |
---|
Table Cell (td) |
---|
ApprovedForWeb |
Table Cell (td) |
---|
•Schema extension/ custom field needed? Needed for filtering for public web viewing on Delphi. |
|
Table Row (tr) |
---|
Table Cell (td) |
---|
Description |
|
Table Row (tr) |
---|
Table Cell (td) |
---|
DisplayRendID |
Table Cell (td) |
---|
Do not import — not needed; presumably superseded by CSpace functionality |
|
Table Row (tr) |
---|
Table Cell (td) |
---|
EnteredDate |
Table Cell (td) |
---|
Do not import; use MediaXrefs.EnteredDate instead (TMS bug prevents linking to existing media, so all MediaXrefs.EnteredDate should be the same as MediaMaster.EnteredDate). |
|
Table Row (tr) |
---|
Table Cell (td) |
---|
Do not import; use MediaXrefs.LoginID instead (TMS bug prevents linking to existing media, so all MediaXrefs.LoginID should be the same as MediaMaster.LoginID). |
|
Table Row (tr) |
---|
Table Cell (td) |
---|
MediaMasterID |
Table Cell (td) |
---|
Do not import — use as PK for table |
|
Table Row (tr) |
---|
Table Cell (td) |
---|
PrimaryRendID |
Table Cell (td) |
---|
Do not import — not needed; presumably superseded by CSpace functionality |
|
Table Row (tr) |
---|
Table Cell (td) |
---|
PublicAccess |
Table Cell (td) |
---|
Do not import — not needed |
|
Table Row (tr) |
---|
Table Cell (td) |
---|
PublicCaption |
Table Cell (td) |
---|
Media handling information: description (first part, followed by MediaMaster.MediaView, MediaMaster.Description, MediaRenditions.Remarks, and MediaXrefs.Remarks |
|
Table Row (tr) |
---|
Table Cell (td) |
---|
Do not import — no useful information (11 entries: 10 refer to images that have been removed; remaining entry was described as useless by entry creator) |
|
Table Row (tr) |
---|
Table Cell (td) |
---|
Restrictions |
Table Cell (td) |
---|
•Schema extension/ custom field needed? |
|
Table Row (tr) |
---|
Table Cell (td) |
---|
MediaPaths |
Table Cell (td) |
---|
Paths migrated through MediaFiles.PathID |
|
Table Row (tr) |
---|
Table Cell (td) |
---|
MediaRenditions |
Table Cell (td) |
---|
Not useful ("0"”0”: 18,191; <null>: 504,368) |
|
Table Row (tr) |
---|
Table Cell (td) |
---|
EnteredDate |
Table Cell (td) |
---|
Only if useful for versioning context. |
|
Table Row (tr) |
---|
Table Cell (td) |
---|
Do not import — default is "0" “0” (not color), was not changed for nearly 500,000 color images. |
|
Table Row (tr) |
---|
Table Cell (td) |
---|
Do not import |
|
Table Row (tr) |
---|
Table Cell (td) |
---|
use as FK to Users.Login, then use Users.MTB_ConstituentID as FK to Constituents.ConstituentID to get person's info |
Table Cell (td) |
---|
Only if useful for attribution content. |
|
Table Row (tr) |
---|
Table Cell (td) |
---|
MediaMasterID |
Table Cell (td) |
---|
Used as FK to MediaMaster |
|
Table Row (tr) |
---|
Table Cell (td) |
---|
MediaSizeID |
Table Cell (td) |
---|
Useful? If MediaSizeID=2, original film format was 35mm |
|
Table Row (tr) |
---|
Table Cell (td) |
---|
MediaStatusDate |
Table Cell (td) |
---|
Do not import — always null |
|
Table Row (tr) |
---|
Table Cell (td) |
---|
MediaStatusID |
Table Cell (td) |
---|
Do not import — always 0 |
|
Table Row (tr) |
---|
Table Cell (td) |
---|
MediaTypeID |
Table Cell (td) |
---|
Needed? Indicates whether file is Image ("1"”1”), Audio ("2"”2”), Video ("3"”3”), Document ("4"”4”), Slide ("10"”10”), or Negative ("9"”9”) |
|
Table Row (tr) |
---|
Table Cell (td) |
---|
ParentRendID |
Table Cell (td) |
---|
Useful? (799 are != -1) |
|
Table Row (tr) |
---|
Table Cell (td) |
---|
PrimaryFileID |
Table Cell (td) |
---|
use as FK to MediaFiles.FileID to get media file info. |
|
Table Row (tr) |
---|
Table Cell (td) |
---|
Worth importing? ("great"”great”: 209; "Peru"“Peru”: 512; <null>: 521,838) |
|
Table Row (tr) |
---|
Table Cell (td) |
---|
QualityConID |
Table Cell (td) |
---|
Do not import — always null |
|
Table Row (tr) |
---|
Table Cell (td) |
---|
QualityDate |
Table Cell (td) |
---|
Do not import — always null |
|
Table Row (tr) |
---|
Table Cell (td) |
---|
QuantityAvailable |
Table Cell (td) |
---|
Not worth importing? ("0"”0”: 17,894; "1"“1”: 297; <null>: 504,368) |
|
Table Row (tr) |
---|
Table Cell (td) |
---|
QuantityMade |
Table Cell (td) |
---|
Not worth importing? ("1"“1”: 21,720; <null>: 500,839) |
|
Table Row (tr) |
---|
Table Cell (td) |
---|
RenditionDate |
Table Cell (td) |
---|
Do not import — no data |
|
Table Row (tr) |
---|
Table Cell (td) |
---|
RenditionID |
Table Cell (td) |
---|
Do not import — use as PK for table |
|
Table Row (tr) |
---|
Table Cell (td) |
---|
RenditionNumber |
|
Table Row (tr) |
---|
Table Cell (td) |
---|
SortNumber |
Table Cell (td) |
---|
Do not import — presumably superseded by CSpace functionality |
|
Table Row (tr) |
---|
Table Cell (td) |
---|
Do not import — always null |
|
Table Row (tr) |
---|
Table Cell (td) |
---|
ThumbBlobSize |
|
Table Row (tr) |
---|
Table Cell (td) |
---|
ThumbExtensionID |
Table Cell (td) |
---|
Do not import — presumably superseded by CSpace functionality |
|
Table Row (tr) |
---|
Table Cell (td) |
---|
ThumbFileName |
|
Table Row (tr) |
---|
Table Cell (td) |
---|
ThumbPathID |
Table Cell (td) |
---|
Indicates location of thumbnails for the images (6 different locations) |
|
Table Row (tr) |
---|
Table Cell (td) |
---|
MediaSizes |
Table Cell (td) |
---|
Do not import — 1-item controlled list (35 mm) presumably superseded by CSpace list/functionality |
|
Table Row (tr) |
---|
Table Cell (td) |
---|
MediaStatuses |
Table Cell (td) |
---|
Do not import — not used by PAHMA |
|
Table Row (tr) |
---|
Table Cell (td) |
---|
MediaTypes |
Table Cell (td) |
---|
Do not import — controlled list presumably superseded by CSpace list/functionality |
|
Table Row (tr) |
---|
Table Cell (td) |
---|
MediaXrefs |
Table Cell (td) |
---|
EnteredDate |
Table Cell (td) |
---|
Only if useful for versioning context. |
|
Table Row (tr) |
---|
Table Cell (td) |
---|
(person-related digital media) |
Table Cell (td) |
---|
WHERE TableID=23, use as FK to Constituents.ConstituentID to get person?s information |
|
Table Row (tr) |
---|
Table Cell (td) |
---|
(exhibition-related digital media) |
Table Cell (td) |
---|
WHERE TableID=47, use as FK to Exhibitions.ExhibitionID to get exhibition info. |
|
Table Row (tr) |
---|
Table Cell (td) |
---|
(loan-related digital media) |
Table Cell (td) |
---|
WHERE TableID=81, use as FK to Loans.LoanID to get loan info. |
|
Table Row (tr) |
---|
Table Cell (td) |
---|
(conservation- and/or condition-related digital media) |
Table Cell (td) |
---|
WHERE TableID=97, use as FK to CondLineItems.CondLineItemID to get [conservation] condition line item info. |
|
Table Row (tr) |
---|
Table Cell (td) |
---|
(object-related digital media) |
Table Cell (td) |
---|
WHERE TableID=108, use as FK to Objects.ObjectID to get object info. |
|
Table Row (tr) |
---|
Table Cell (td) |
---|
(historical event-related digital media) |
Table Cell (td) |
---|
WHERE TableID=187, use as FK to HistEvents.HistEventID to get historical event info. |
|
Table Row (tr) |
---|
Table Cell (td) |
---|
(place-related digital media) |
Table Cell (td) |
---|
WHERE TableID=189, use as FK to Sites.SiteID to get place info. |
|
Table Row (tr) |
---|
Table Cell (td) |
---|
(shipment-related digital media) |
Table Cell (td) |
---|
WHERE TableID=345, use as FK to Shipments.ShipmentID to get shipment info. |
|
Table Row (tr) |
---|
Table Cell (td) |
---|
use as FK to Users.Login, then use Users.MTB_ConstituentID as FK to Constituents.ConstituentID to get person's info |
Table Cell (td) |
---|
Only if useful for attribution content. |
|
Table Row (tr) |
---|
Table Cell (td) |
---|
MediaMasterID |
Table Cell (td) |
---|
use as FK to MediaMaster.MediaMasterID to get media info (filename, filepath, etc.) |
|
Table Row (tr) |
---|
Table Cell (td) |
---|
MediaXrefID |
Table Cell (td) |
---|
Do not import — use as PK for table |
|
Table Row (tr) |
---|
Table Cell (td) |
---|
PrimaryDisplay |
Table Cell (td) |
---|
The primary image to be displayed is indicated by PrimaryDisplay=1 |
|
Table Row (tr) |
---|
Table Cell (td) |
---|
Indicates the relative display order of images (media with lower numbers should be displayed before media with higher numbers). |
|
Table Row (tr) |
---|
Table Cell (td) |
---|
use in conjunction with ID, above |
|
|