Page Comparison

HTML Table

borders	1
cellpadding	3
cellspacing	0

Table Head (th)
Table

Table Head (th)
Columns

Table Head (th)
CSpace destination

Table Head (th)
Cleaned?

Table Head (th)
Migrated?

Table Head (th)
Mapping

Table Head (th)
Notes

Table Row (tr)

Table Cell (td)
MediaArchTypes

Table Cell (td)
————

Table Cell (td)
————

Table Cell (td)

align	center

————

Table Cell (td)

align	center

no

Table Cell (td)
————

Table Cell (td)
Do not import — not needed or used

Table Row (tr)

Table Cell (td)
MediaColorDepths

Table Cell (td)
———

Table Cell (td)
————

Table Cell (td)

align	center

Table Cell (td)

align	center

Table Cell (td)
————

Table Cell (td)
Do not import — simplistic, 3-term list: "true color", "1-bit grayscale", "8-bit grayscale" — presumably superseded by CSpace list/functionality

Table Row (tr)

Table Cell (td)
MediaCounts

Table Cell (td)
————

Table Cell (td)
————

Table Cell (td)

align	center

————

Table Cell (td)

align	center

————

Table Cell (td)
————

Table Cell (td)
Do not import — for TMS internal use

Table Row (tr)

Table Cell (td)
MediaExtensions

Table Cell (td)
———

Table Cell (td)
————

Table Cell (td)

align	center

————

Table Cell (td)

align	center

no

Table Cell (td)
————

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)
————

Table Cell (td)

align	center

————

Table Cell (td)

align	center

————

Table Cell (td)
————

Table Cell (td)
Do not import — always null

Table Row (tr) Table Cell (td)

Table Cell (td)
ArchFilename

Table Cell (td)
————

Table Cell (td)

align	center

————

Table Cell (td)

align	center

————

Table Cell (td)
————

Table Cell (td)
Do not import — always null

Table Row (tr) Table Cell (td)

Table Cell (td)
ArchIDNum

Table Cell (td)
————

Table Cell (td)

align	center

————

Table Cell (td)

align	center

————

Table Cell (td)
————

Table Cell (td)
Do not import — always null

Table Row (tr) Table Cell (td)

Table Cell (td)
ArchSubDir

Table Cell (td)
————

Table Cell (td)

align	center

————

Table Cell (td)

align	center

————

Table Cell (td)
————

Table Cell (td)
Do not import — always null

Table Row (tr) Table Cell (td)

Table Cell (td)
ArchTypeID

Table Cell (td)
————

Table Cell (td)

align	center

Table Cell (td)

align	center

Table Cell (td)
————

Table Cell (td)
Do not import — always 0

Table Row (tr) Table Cell (td)

Table Cell (td)
ArchVolName

Table Cell (td)
————

Table Cell (td)

align	center

————

Table Cell (td)

align	center

————

Table Cell (td)
————

Table Cell (td)
Do not import — always null

Table Row (tr) Table Cell (td)

Table Cell (td)
ColorDepthID

Table Cell (td)
—?—

Table Cell (td)

align	center

Table Cell (td)

align	center

Table Cell (td)
—?—

Table Cell (td)
Needed? Superseded by CSpace functionality?

Table Row (tr) Table Cell (td)

Table Cell (td)
Duration

Table Cell (td)
————

Table Cell (td)

align	center

Table Cell (td)

align	center

Table Cell (td)
————

Table Cell (td)
Do not import — always 0

Table Row (tr) Table Cell (td)

Table Cell (td)
EnteredDate

Table Cell (td)
—?—

Table Cell (td)

align	center

————

Table Cell (td)

align	center

no

Table Cell (td)
—?—

Table Cell (td)
Only if useful for versioning context.

Table Row (tr) Table Cell (td)

Table Cell (td)
FileDate

Table Cell (td)
Media handling information: date created

Table Cell (td)

align	center

Table Cell (td)

align	center

Table Cell (td)

Table Cell (td)
Migrate if not automatically extracted upon import

Table Row (tr) Table Cell (td)

Table Cell (td)
FileID

Table Cell (td)
————

Table Cell (td)

align	center

————

Table Cell (td)

align	center

————

Table Cell (td)
————

Table Cell (td)
Do not import — use as PK for table

Table Row (tr) Table Cell (td)

Table Cell (td)
FileName

Table Cell (td)
Media handling information: file name

Table Cell (td)

align	center

Table Cell (td)

align	center

Table Cell (td)

Table Cell (td)
Migrate if not automatically extracted upon import

Table Row (tr) Table Cell (td)

Table Cell (td)
FileSize

Table Cell (td)
Media handling information: dimension ?

Table Cell (td)

align	center

Table Cell (td)

align	center

Table Cell (td)
WHERE FileSize <> 0

Table Cell (td) Table Row (tr) Table Cell (td)

Table Cell (td)
FormatID

Table Cell (td)
Media handling information: format

Table Cell (td)

align	center

Table Cell (td)

align	center

Table Cell (td)
use as FK to MediaFormats.FormatID to get format info.

Table Cell (td) Table Row (tr) Table Cell (td)

Table Cell (td)
LoginID

Table Cell (td)
—?—

Table Cell (td)

align	center

no

Table Cell (td)

align	center

no

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)

Table Cell (td)
MemorySize

Table Cell (td)
Media handling information: dimension ?

Table Cell (td)

align	center

Table Cell (td)

align	center

Table Cell (td) Table Cell (td) Table Row (tr) Table Cell (td)

Table Cell (td)
PathID

Table Cell (td)
Media handling information: location

Table Cell (td)

align	center

Table Cell (td)

align	center

Table Cell (td)
use as FK to MediaPaths.PathID to get file location

Table Cell (td) Table Row (tr) Table Cell (td)

Table Cell (td)
PixelH

Table Cell (td)
Media handling information: dimension ?

Table Cell (td)

align	center

Table Cell (td)

align	center

Table Cell (td) Table Cell (td) Table Row (tr) Table Cell (td)

Table Cell (td)
PixelW

Table Cell (td)
Media handling information: dimension ?

Table Cell (td)

align	center

Table Cell (td)

align	center

Table Cell (td) Table Cell (td) Table Row (tr) Table Cell (td)

Table Cell (td)
RenditionID

Table Cell (td)
—?—

Table Cell (td)

align	center

Table Cell (td)

align	center

Table Cell (td)
—?—

Table Cell (td)
Needed? Useful if importing unlinked images

Table Row (tr)

Table Cell (td)
MediaFormats

Table Cell (td)
———

Table Cell (td)
————

Table Cell (td)

align	center

————

Table Cell (td)

align	center

no

Table Cell (td)
————

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)
————

Table Cell (td)

align	center

————

Table Cell (td)

align	center

————

Table Cell (td)
————

Table Cell (td)
Do not import

Table Row (tr) Table Cell (td)

Table Cell (td)
ApprovedForWeb

Table Cell (td)
•Schema extension/ custom field needed? Needed for filtering for public web viewing on Delphi.

Table Cell (td)

align	center

Table Cell (td)

align	center

Table Cell (td) Table Cell (td) Table Row (tr) Table Cell (td)

Table Cell (td)
Copyright

Table Cell (td)
Media handling information: rights holder

Table Cell (td)

align	center

Table Cell (td)

align	center

Table Cell (td) Table Cell (td) Table Row (tr) Table Cell (td)

Table Cell (td)
Description

Table Cell (td)
append to Media handling information: description

Table Cell (td)

align	center

Table Cell (td)

align	center

Table Cell (td) Table Cell (td) Table Row (tr) Table Cell (td)

Table Cell (td)
DisplayRendID

Table Cell (td)
————

Table Cell (td)

align	center

————

Table Cell (td)

align	center

————

Table Cell (td)
————

Table Cell (td)
Do not import — not needed; presumably superseded by CSpace functionality

Table Row (tr) Table Cell (td)

Table Cell (td)
EnteredDate

Table Cell (td)
————

Table Cell (td)

align	center

————

Table Cell (td)

align	center

————

Table Cell (td)
————

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)

Table Cell (td)
LoginID

Table Cell (td)
————

Table Cell (td)

align	center

————

Table Cell (td)

align	center

————

Table Cell (td)
————

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)

Table Cell (td)
MediaMasterID

Table Cell (td)
————

Table Cell (td)

align	center

————

Table Cell (td)

align	center

————

Table Cell (td)
————

Table Cell (td)
Do not import — use as PK for table

Table Row (tr) Table Cell (td)

Table Cell (td)
MediaView

Table Cell (td)
•Schema extension/ custom field needed? (or append to Media handling information: description)

Table Cell (td)

align	center

Table Cell (td)

align	center

Table Cell (td)
—?—

Table Cell (td) Table Row (tr) Table Cell (td)

Table Cell (td)
PrimaryRendID

Table Cell (td)
————

Table Cell (td)

align	center

————

Table Cell (td)

align	center

————

Table Cell (td)
————

Table Cell (td)
Do not import — not needed; presumably superseded by CSpace functionality

Table Row (tr) Table Cell (td)

Table Cell (td)
PublicAccess

Table Cell (td)
————

Table Cell (td)

align	center

————

Table Cell (td)

align	center

————

Table Cell (td)
————

Table Cell (td)
Do not import — not needed

Table Row (tr) Table Cell (td)

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 Cell (td)

align	center

Table Cell (td)

align	center

Table Cell (td) Table Cell (td) Table Row (tr) Table Cell (td)

Table Cell (td)
Remarks

Table Cell (td)
————

Table Cell (td)

align	center

————

Table Cell (td)

align	center

————

Table Cell (td)
————

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)

Table Cell (td)
Restrictions

Table Cell (td)
•Schema extension/ custom field needed?

Table Cell (td)

align	center

Table Cell (td)

align	center

Table Cell (td) Table Cell (td)

Table Row (tr)

Table Cell (td)
MediaPaths

Table Cell (td)
————

Table Cell (td)
————

Table Cell (td)

align	center

————

Table Cell (td)

align	center

no

Table Cell (td)
————

Table Cell (td)
Paths migrated through MediaFiles.PathID

Table Row (tr)

Table Cell (td)
MediaRenditions

Table Cell (td)
Duration

Table Cell (td)
————

Table Cell (td)

align	center

Table Cell (td)

align	center

Table Cell (td)
————

Table Cell (td)
Not useful ("0": 18,191; <null>: 504,368)

Table Row (tr) Table Cell (td)

Table Cell (td)
EnteredDate

Table Cell (td)
—?—

Table Cell (td)

align	center

————

Table Cell (td)

align	center

no

Table Cell (td)
—?—

Table Cell (td)
Only if useful for versioning context.

Table Row (tr) Table Cell (td)

Table Cell (td)
IsColor

Table Cell (td)
————

Table Cell (td)

align	center

Table Cell (td)

align	center

Table Cell (td)
————

Table Cell (td)
Do not import — default is "0" (not color), was not changed for nearly 500,000 color images.

Table Row (tr) Table Cell (td)

Table Cell (td)
LocTermID

Table Cell (td)
————

Table Cell (td)

align	center

————

Table Cell (td)

align	center

————

Table Cell (td)
————

Table Cell (td)
Do not import

Table Row (tr) Table Cell (td)

Table Cell (td)
LoginID

Table Cell (td)
—?—

Table Cell (td)

align	center

no

Table Cell (td)

align	center

no

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)

Table Cell (td)
MediaMasterID

Table Cell (td)
————

Table Cell (td)

align	center

Table Cell (td)

align	center

Table Cell (td)
————

Table Cell (td)
Used as FK to MediaMaster

Table Row (tr) Table Cell (td)

Table Cell (td)
MediaSizeID

Table Cell (td)
—?—

Table Cell (td)

align	center

Table Cell (td)

align	center

Table Cell (td)
—?—

Table Cell (td)
Useful? If MediaSizeID=2, original film format was 35mm

Table Row (tr) Table Cell (td)

Table Cell (td)
MediaStatusDate

Table Cell (td)
————

Table Cell (td)

align	center

————

Table Cell (td)

align	center

————

Table Cell (td)
————

Table Cell (td)
Do not import — always null

Table Row (tr) Table Cell (td)

Table Cell (td)
MediaStatusID

Table Cell (td)
————

Table Cell (td)

align	center

Table Cell (td)

align	center

Table Cell (td)
————

Table Cell (td)
Do not import — always 0

Table Row (tr) Table Cell (td)

Table Cell (td)
MediaTypeID

Table Cell (td)
—?—

Table Cell (td)

align	center

Table Cell (td)

align	center

Table Cell (td)
—?—

Table Cell (td)
Needed? Indicates whether file is Image ("1"), Audio ("2"), Video ("3"), Document ("4"), Slide ("10"), or Negative ("9")

Table Row (tr) Table Cell (td)

Table Cell (td)
ParentRendID

Table Cell (td)
—?—

Table Cell (td)

align	center

Table Cell (td)

align	center

Table Cell (td)
—?—

Table Cell (td)
Useful? (799 are != -1)

Table Row (tr) Table Cell (td)

Table Cell (td)
PrimaryFileID

Table Cell (td)
————

Table Cell (td)

align	center

Table Cell (td)

align	center

Table Cell (td)
use as FK to MediaFiles.FileID to get media file info.

Table Cell (td) Table Row (tr) Table Cell (td)

Table Cell (td)
Quality

Table Cell (td)
—?—

Table Cell (td)

align	center

Table Cell (td)

align	center

Table Cell (td)
—?—

Table Cell (td)
Worth importing? ("great": 209; "Peru": 512; <null>: 521,838)

Table Row (tr) Table Cell (td)

Table Cell (td)
QualityConID

Table Cell (td)
————

Table Cell (td)

align	center

————

Table Cell (td)

align	center

————

Table Cell (td)
————

Table Cell (td)
Do not import — always null

Table Row (tr) Table Cell (td)

Table Cell (td)
QualityDate

Table Cell (td)
————

Table Cell (td)

align	center

————

Table Cell (td)

align	center

————

Table Cell (td)
————

Table Cell (td)
Do not import — always null

Table Row (tr) Table Cell (td)

Table Cell (td)
QuantityAvailable

Table Cell (td)
————

Table Cell (td)

align	center

Table Cell (td)

align	center

Table Cell (td)
————

Table Cell (td)
Not worth importing? ("0": 17,894; "1": 297; <null>: 504,368)

Table Row (tr) Table Cell (td)

Table Cell (td)
QuantityMade

Table Cell (td)
————

Table Cell (td)

align	center

Table Cell (td)

align	center

Table Cell (td)
————

Table Cell (td)
Not worth importing? ("1": 21,720; <null>: 500,839)

Table Row (tr) Table Cell (td)

Table Cell (td)
Remarks

Table Cell (td)
append to Media handling information: description

Table Cell (td)

align	center

Table Cell (td)

align	center

Table Cell (td) Table Cell (td) Table Row (tr) Table Cell (td)

Table Cell (td)
RenditionDate

Table Cell (td)
————

Table Cell (td)

align	center

Table Cell (td)

align	center

Table Cell (td)
————

Table Cell (td)
Do not import — no data

Table Row (tr) Table Cell (td)

Table Cell (td)
RenditionID

Table Cell (td)
————

Table Cell (td)

align	center

————

Table Cell (td)

align	center

————

Table Cell (td)
————

Table Cell (td)
Do not import — use as PK for table

Table Row (tr) Table Cell (td)

Table Cell (td)
RenditionNumber

Table Cell (td)
Media handling information: identification number

Table Cell (td)

align	center

Table Cell (td)

align	center

Table Cell (td) Table Cell (td) Table Row (tr) Table Cell (td)

Table Cell (td)
SortNumber

Table Cell (td)
————

Table Cell (td)

align	center

————

Table Cell (td)

align	center

————

Table Cell (td)
————

Table Cell (td)
Do not import — presumably superseded by CSpace functionality

Table Row (tr) Table Cell (td)

Table Cell (td)
Technique

Table Cell (td)
————

Table Cell (td)

align	center

————

Table Cell (td)

align	center

————

Table Cell (td)
————

Table Cell (td)
Do not import — always null

Table Row (tr) Table Cell (td)

Table Cell (td)
ThumbBLOB

Table Cell (td)
—?—

Table Cell (td)

align	center

Table Cell (td)

align	center

Table Cell (td)
—?—

Table Cell (td)
Needed?

Table Row (tr) Table Cell (td)

Table Cell (td)
ThumbBlobSize

Table Cell (td)
—?—

Table Cell (td)

align	center

Table Cell (td)

align	center

Table Cell (td)
—?—

Table Cell (td)
Needed?

Table Row (tr) Table Cell (td)

Table Cell (td)
ThumbExtensionID

Table Cell (td)
————

Table Cell (td)

align	center

————

Table Cell (td)

align	center

————

Table Cell (td)
————

Table Cell (td)
Do not import — presumably superseded by CSpace functionality

Table Row (tr) Table Cell (td)

Table Cell (td)
ThumbFileName

Table Cell (td)
—?—

Table Cell (td)

align	center

Table Cell (td)

align	center

Table Cell (td)
—?—

Table Cell (td)
Needed?

Table Row (tr) Table Cell (td)

Table Cell (td)
ThumbPathID

Table Cell (td)
—?—

Table Cell (td)

align	center

Table Cell (td)

align	center

Table Cell (td)
—?—

Table Cell (td)
Indicates location of thumbnails for the images (6 different locations)

Table Row (tr)

Table Cell (td)
MediaSizes

Table Cell (td)
———

Table Cell (td)
————

Table Cell (td)

align	center

————

Table Cell (td)

align	center

no

Table Cell (td)
————

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)
———

Table Cell (td)
————

Table Cell (td)

align	center

————

Table Cell (td)

align	center

no

Table Cell (td)
————

Table Cell (td)
Do not import — not used by PAHMA

Table Row (tr)

Table Cell (td)
MediaTypes

Table Cell (td)
————

Table Cell (td)
————

Table Cell (td)

align	center

————

Table Cell (td)

align	center

no

Table Cell (td)
————

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)
—?—

Table Cell (td)

align	center

————

Table Cell (td)

align	center

no

Table Cell (td)
—?—

Table Cell (td)
Only if useful for versioning context.

Table Row (tr) Table Cell (td)

Table Cell (td)
ID

Table Cell (td)
(person-related digital media)

Table Cell (td)

align	center

Table Cell (td)

align	center

Table Cell (td)
WHERE TableID=23, use as FK to Constituents.ConstituentID to get person?s information

Table Cell (td) Table Row (tr) Table Cell (td) Table Cell (td)

Table Cell (td)
(exhibition-related digital media)

Table Cell (td)

align	center

Table Cell (td)

align	center

Table Cell (td)
WHERE TableID=47, use as FK to Exhibitions.ExhibitionID to get exhibition info.

Table Cell (td) Table Row (tr) Table Cell (td) Table Cell (td)

Table Cell (td)
(loan-related digital media)

Table Cell (td)

align	center

Table Cell (td)

align	center

Table Cell (td)
WHERE TableID=81, use as FK to Loans.LoanID to get loan info.

Table Cell (td) Table Row (tr) Table Cell (td) Table Cell (td)

Table Cell (td)
(conservation- and/or condition-related digital media)

Table Cell (td)

align	center

Table Cell (td)

align	center

Table Cell (td)
WHERE TableID=97, use as FK to CondLineItems.CondLineItemID to get [conservation] condition line item info.

Table Cell (td) Table Row (tr) Table Cell (td) Table Cell (td)

Table Cell (td)
(object-related digital media)

Table Cell (td)

align	center

Table Cell (td)

align	center

Table Cell (td)
WHERE TableID=108, use as FK to Objects.ObjectID to get object info.

Table Cell (td) Table Row (tr) Table Cell (td) Table Cell (td)

Table Cell (td)
(historical event-related digital media)

Table Cell (td)

align	center

Table Cell (td)

align	center

Table Cell (td)
WHERE TableID=187, use as FK to HistEvents.HistEventID to get historical event info.

Table Cell (td) Table Row (tr) Table Cell (td) Table Cell (td)

Table Cell (td)
(place-related digital media)

Table Cell (td)

align	center

Table Cell (td)

align	center

Table Cell (td)
WHERE TableID=189, use as FK to Sites.SiteID to get place info.

Table Cell (td) Table Row (tr) Table Cell (td) Table Cell (td)

Table Cell (td)
(shipment-related digital media)

Table Cell (td)

align	center

Table Cell (td)

align	center

Table Cell (td)
WHERE TableID=345, use as FK to Shipments.ShipmentID to get shipment info.

Table Cell (td) Table Row (tr) Table Cell (td)

Table Cell (td)
LoginID

Table Cell (td)
Media handling information: contributor? (or publisher?)

Table Cell (td)

align	center

no

Table Cell (td)

align	center

no

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)

Table Cell (td)
MediaMasterID

Table Cell (td)
————

Table Cell (td)

align	center

Table Cell (td)

align	center

Table Cell (td)
use as FK to MediaMaster.MediaMasterID to get media info (filename, filepath, etc.)

Table Cell (td) Table Row (tr) Table Cell (td)

Table Cell (td)
MediaXrefID

Table Cell (td)
————

Table Cell (td)

align	center

————

Table Cell (td)

align	center

————

Table Cell (td)
————

Table Cell (td)
Do not import — use as PK for table

Table Row (tr) Table Cell (td)

Table Cell (td)
PrimaryDisplay

Table Cell (td)
—?—

Table Cell (td)

align	center

Table Cell (td)

align	center

Table Cell (td)

Table Cell (td)
The primary image to be displayed is indicated by PrimaryDisplay=1

Table Row (tr) Table Cell (td)

Table Cell (td)
Rank

Table Cell (td)
—?—

Table Cell (td)

align	center

Table Cell (td)

align	center

Table Cell (td)

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)

Table Cell (td)
Remarks

Table Cell (td)
•Schema extension/ custom field needed? (or append to Media handling information: description)

Table Cell (td)

align	center

Table Cell (td)

align	center

Table Cell (td) Table Cell (td) Table Row (tr) Table Cell (td)

Table Cell (td)
TableID

Table Cell (td)
————

Table Cell (td)

align	center

Table Cell (td)

align	center

Table Cell (td)
use in conjunction with ID, above

td Wiki Markup

{table:borders=1|cellspacing=0|cellpadding=3}
{th} Table {th}{th} Columns {th}{th} CSpace destination {th}{th} Cleaned? {th}{th} Migrated? {th}{th} Mapping {th}{th} Notes {th}
{tr}{td}MediaArchTypes{td}{td}————{td}{td}————{td}{td:align=center}————{td}{td:align=center}no{td}{td}————{td}{td}Do not import — not needed or used{td}{tr}
{tr}{td}MediaColorDepths{td}{td}———{td}{td}————{td}{td:align=center}{td}{td:align=center}{td}{td}————{td}{td}Do not import — simplistic, 3-term list: "true color", "1-bit grayscale", "8-bit grayscale" —
presumably superseded by CSpace list/functionality{td}{tr}
{tr}{td}MediaCounts{td}{td}————{td}{td}————{td}{td:align=center}————{td}{td:align=center}————{td}{td}————{td}{td}Do not import — for TMS internal use{td}{tr}
{tr}{td}MediaExtensions{td}{td}———{td}{td}————{td}{td:align=center}————{td}{td:align=center}no{td}{td}————{td}{td}Do not import — controlled list presumably superseded by CSpace list/functionality{td}
{tr}
{tr}{td}MediaFiles{td}{td}ArchCatNum{td}{td}————{td}{td:align=center}————{td}{td:align=center}————{td}{td}————{td}{td}Do not import — always null{td}{tr}
{tr}{td} {td}{td}ArchFilename{td}{td}————{td}{td:align=center}————{td}{td:align=center}————{td}{td}————{td}{td}Do not import — always null{td}{tr}
{tr}{td} {td}{td}ArchIDNum{td}{td}————{td}{td:align=center}————{td}{td:align=center}————{td}{td}————{td}{td}Do not import — always null{td}{tr}
{tr}{td} {td}{td}ArchSubDir{td}{td}————{td}{td:align=center}————{td}{td:align=center}————{td}{td}————{td}{td}Do not import — always null{td}{tr}
{tr}{td} {td}{td}ArchTypeID{td}{td}————{td}{td:align=center}{td}{td:align=center}{td}{td}————{td}{td}Do not import — always 0{td}{tr}
{tr}{td} {td}{td}ArchVolName{td}{td}————{td}{td:align=center}————{td}{td:align=center}————{td}{td}————{td}{td}Do not import — always null{td}{tr}
{tr}{td} {td}{td}ColorDepthID{td}{td}—?—{td}{td:align=center}{td}{td:align=center}{td}{td}—?—{td}{td}Needed? Superseded by CSpace functionality?{td}{tr}
{tr}{td} {td}{td}Duration{td}{td}————{td}{td:align=center}{td}{td:align=center}{td}{td}————{td}{td}Do not import — always 0{td}{tr}
{tr}{td} {td}{td}EnteredDate{td}{td}—?—{td}{td:align=center}————{td}{td:align=center}no{td}{td}—?—{td}{td}Only if useful for versioning context.{td}{tr}
{tr}{td} {td}{td}FileDate{td}{td}[Media handling information|http://wiki.collectionspace.org/display/collectionspace/Media+Handling+Schema]: date created{td}{td:align=center}{td}{td:align=center}{td}{td}{td}{td}Migrate if
not automatically extracted upon import{td}{tr}
{tr}{td} {td}{td}FileID{td}{td}————{td}{td:align=center}————{td}{td:align=center}————{td}{td}————{td}{td}Do not import — use as PK for table{td}{tr}
{tr}{td} {td}{td}FileName{td}{td}[Media handling information|http://wiki.collectionspace.org/display/collectionspace/Media+Handling+Schema]: file name{td}{td:align=center}{td}{td:align=center}{td}{td}{td}{td}Migrate if
not automatically extracted upon import{td}{tr}
{tr}{td} {td}{td}FileSize{td}{td}[Media handling information|http://wiki.collectionspace.org/display/collectionspace/Media+Handling+Schema]: dimension ?{td}{td:align=center}{td}{td:align=center}{td}{td}WHERE FileSize
<> 0{td}{td}{td}{tr}
{tr}{td} {td}{td}FormatID{td}{td}[Media handling information|http://wiki.collectionspace.org/display/collectionspace/Media+Handling+Schema]: format{td}{td:align=center}{td}{td:align=center}{td}{td}use as FK to
MediaFormats.FormatID to get format info.{td}{td}{td}{tr}
{tr}{td} {td}{td}LoginID{td}{td}—?—{td}{td:align=center}no{td}{td:align=center}no{td}{td}use as FK to Users.Login, then use Users.MTB_ConstituentID as FK to Constituents.ConstituentID to get person's info{td}{td}
Only if useful for attribution content.{td}{tr}
{tr}{td} {td}{td}MemorySize{td}{td}[Media handling information|http://wiki.collectionspace.org/display/collectionspace/Media+Handling+Schema]: dimension ?{td}{td:align=center}{td}{td:align=center}{td}{td}{td}{td}{td}
{tr}
{tr}{td} {td}{td}PathID{td}{td}[Media handling information|http://wiki.collectionspace.org/display/collectionspace/Media+Handling+Schema]: location{td}{td:align=center}{td}{td:align=center}{td}{td}use as FK to
MediaPaths.PathID to get file location{td}{td}{td}{tr}
{tr}{td} {td}{td}PixelH{td}{td}[Media handling information|http://wiki.collectionspace.org/display/collectionspace/Media+Handling+Schema]: dimension ?{td}{td:align=center}{td}{td:align=center}{td}{td}{td}{td}{td}{tr}
{tr}{td} {td}{td}PixelW{td}{td}[Media handling information|http://wiki.collectionspace.org/display/collectionspace/Media+Handling+Schema]: dimension ?{td}{td:align=center}{td}{td:align=center}{td}{td}{td}{td}{td}{tr}
{tr}{td} {td}{td}RenditionID{td}{td}—?—{td}{td:align=center}{td}{td:align=center}{td}{td}—?—{td}{td}Needed? Useful if importing unlinked images{td}{tr}
{tr}{td}MediaFormats{td}{td}———{td}{td}————{td}{td:align=center}————{td}{td:align=center}no{td}{td}————{td}{td}Do not import — controlled list presumably superseded by CSpace list/functionality{td}{tr}
{tr}{td}MediaMaster{td}{td}AgreementSignedDate{td}{td}————{td}{td:align=center}————{td}{td:align=center}————{td}{td}————{td}{td}Do not import{td}{tr}
{tr}{td} {td}{td}ApprovedForWeb{td}{td}•Schema extension/ custom field needed? Needed for filtering for public web viewing on Delphi.{td}{td:align=center}{td}{td:align=center}{td}{td}{td}{td}{td}{tr}
{tr}{td} {td}{td}Copyright{td}{td}[Media handling information|http://wiki.collectionspace.org/display/collectionspace/Media+Handling+Schema]: rights holder{td}{td:align=center}{td}{td:align=center}{td}{td}{td}{td}{td}{tr}
{tr}{td} {td}{td}Description{td}{td}append to [Media handling information|http://wiki.collectionspace.org/display/collectionspace/Media+Handling+Schema]: description{td}{td:align=center}{td}{td:align=center}{td}{td}{td}
{td}{td}{tr}
{tr}{td} {td}{td}DisplayRendID{td}{td}————{td}{td:align=center}————{td}{td:align=center}————{td}{td}————{td}{td}Do not import — not needed; presumably superseded by CSpace functionality{td}{tr}
{tr}{td} {td}{td}EnteredDate{td}{td}————{td}{td:align=center}————{td}{td:align=center}————{td}{td}————{td}{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).{td}{tr}
{tr}{td} {td}{td}LoginID{td}{td}————{td}{td:align=center}————{td}{td:align=center}————{td}{td}————{td}{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).{td}{tr}
{tr}{td} {td}{td}MediaMasterID{td}{td}————{td}{td:align=center}————{td}{td:align=center}————{td}{td}————{td}{td}Do not import — use as PK for table{td}{tr}
{tr}{td} {td}{td}MediaView{td}{td}•Schema extension/ custom field needed? (or append to [Media handling information|http://wiki.collectionspace.org/display/collectionspace/Media+Handling+Schema]: description){td}
{td:align=center}{td}{td:align=center}{td}{td}—?—{td}{td}{td}{tr}
{tr}{td} {td}{td}PrimaryRendID{td}{td}————{td}{td:align=center}————{td}{td:align=center}————{td}{td}————{td}{td}Do not import — not needed; presumably superseded by CSpace functionality{td}{tr}
{tr}{td} {td}{td}PublicAccess{td}{td}————{td}{td:align=center}————{td}{td:align=center}————{td}{td}————{td}{td}Do not import — not needed{td}{tr}
{tr}{td} {td}{td}PublicCaption{td}{td}[Media handling information|http://wiki.collectionspace.org/display/collectionspace/Media+Handling+Schema]: description (first part, followed by MediaMaster.MediaView,
MediaMaster.Description, MediaRenditions.Remarks, and MediaXrefs.Remarks{td}{td:align=center}{td}{td:align=center}{td}{td}{td}{td}{td}{tr}
{tr}{td} {td}{td}Remarks{td}{td}————{td}{td:align=center}————{td}{td:align=center}————{td}{td}————{td}{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){td}{tr}
{tr}{td} {td}{td}Restrictions{td}{td}•Schema extension/ custom field needed?{td}{td:align=center}{td}{td:align=center}{td}{td}{td}{td}{td}{tr}
{tr}{td}MediaPaths{td}{td}————{td}{td}————{td}{td:align=center}————{td}{td:align=center}no{td}{td}————{td}{td}Paths migrated through MediaFiles.PathID{td}{tr}
{tr}{td}MediaRenditions{td}{td}Duration{td}{td}————{td}{td:align=center}{td}{td:align=center}{td}{td}————{td}{td}Not useful ("0": 18,191; <null>: 504,368){td}{tr}
{tr}{td} {td}{td}EnteredDate{td}{td}—?—{td}{td:align=center}————{td}{td:align=center}no{td}{td}—?—{td}{td}Only if useful for versioning context.{td}{tr}
{tr}{td} {td}{td}IsColor{td}{td}————{td}{td:align=center}{td}{td:align=center}{td}{td}————{td}{td}Do not import — default is "0" (not color), was not changed for nearly 500,000 color images.{td}{tr}
{tr}{td} {td}{td}LocTermID{td}{td}————{td}{td:align=center}————{td}{td:align=center}————{td}{td}————{td}{td}Do not import{td}{tr}
{tr}{td} {td}{td}LoginID{td}{td}—?—{td}{td:align=center}no{td}{td:align=center}no{td}{td}use as FK to Users.Login, then use Users.MTB_ConstituentID as FK to Constituents.ConstituentID to get person's info{td}{td}
Only if useful for attribution content.{td}{tr}
{tr}{td} {td}{td}MediaMasterID{td}{td}————{td}{td:align=center}{td}{td:align=center}{td}{td}————{td}{td}Used as FK to MediaMaster{td}{tr}
{tr}{td} {td}{td}MediaSizeID{td}{td}—?—{td}{td:align=center}{td}{td:align=center}{td}{td}—?—{td}{td}Useful? If MediaSizeID=2, original film format was 35mm{td}{tr}
{tr}{td} {td}{td}MediaStatusDate{td}{td}————{td}{td:align=center}————{td}{td:align=center}————{td}{td}————{td}{td}Do not import — always null{td}{tr}
{tr}{td} {td}{td}MediaStatusID{td}{td}————{td}{td:align=center}{td}{td:align=center}{td}{td}————{td}{td}Do not import — always 0{td}{tr}
{tr}{td} {td}{td}MediaTypeID{td}{td}—?—{td}{td:align=center}{td}{td:align=center}{td}{td}—?—{td}{td}Needed? Indicates whether file is Image ("1"), Audio ("2"), Video ("3"), Document ("4"), Slide ("10"), or Negative ("9")
{td}{tr}
{tr}{td} {td}{td}ParentRendID{td}{td}—?—{td}{td:align=center}{td}{td:align=center}{td}{td}—?—{td}{td}Useful? (799 are != -1){td}{tr}
{tr}{td} {td}{td}PrimaryFileID{td}{td}————{td}{td:align=center}{td}{td:align=center}{td}{td}use as FK to MediaFiles.FileID to get media file info.{td}{td}{td}{tr}
{tr}{td} {td}{td}Quality{td}{td}—?—{td}{td:align=center}{td}{td:align=center}{td}{td}—?—{td}{td}Worth importing? ("great": 209; "Peru": 512; <null>: 521,838){td}{tr}
{tr}{td} {td}{td}QualityConID{td}{td}————{td}{td:align=center}————{td}{td:align=center}————{td}{td}————{td}{td}Do not import — always null{td}{tr}
{tr}{td} {td}{td}QualityDate{td}{td}————{td}{td:align=center}————{td}{td:align=center}————{td}{td}————{td}{td}Do not import — always null{td}{tr}
{tr}{td} {td}{td}QuantityAvailable{td}{td}————{td}{td:align=center}{td}{td:align=center}{td}{td}————{td}{td}Not worth importing? ("0": 17,894; "1": 297; <null>: 504,368){td}{tr}
{tr}{td} {td}{td}QuantityMade{td}{td}————{td}{td:align=center}{td}{td:align=center}{td}{td}————{td}{td}Not worth importing? ("1": 21,720; <null>: 500,839){td}{tr}
{tr}{td} {td}{td}Remarks{td}{td}append to [Media handling information|http://wiki.collectionspace.org/display/collectionspace/Media+Handling+Schema]: description{td}{td:align=center}{td}{td:align=center}{td}{td}{td}{td}
{td}{tr}
{tr}{td} {td}{td}RenditionDate{td}{td}————{td}{td:align=center}{td}{td:align=center}{td}{td}————{td}{td}Do not import — no data{td}{tr}
{tr}{td} {td}{td}RenditionID{td}{td}————{td}{td:align=center}————{td}{td:align=center}————{td}{td}————{td}{td}Do not import — use as PK for table{td}{tr}
{tr}{td} {td}{td}RenditionNumber{td}{td}[Media handling information|http://wiki.collectionspace.org/display/collectionspace/Media+Handling+Schema]: identification number{td}{td:align=center}{td}{td:align=center}{td}
{td}{td}{td}{td}{tr}
{tr}{td} {td}{td}SortNumber{td}{td}————{td}{td:align=center}————{td}{td:align=center}————{td}{td}————{td}{td}Do not import — presumably superseded by CSpace functionality{td}{tr}
{tr}{td} {td}{td}Technique{td}{td}————{td}{td:align=center}————{td}{td:align=center}————{td}{td}————{td}{td}Do not import — always null{td}{tr}
{tr}{td} {td}{td}ThumbBLOB{td}{td}—?—{td}{td:align=center}{td}{td:align=center}{td}{td}—?—{td}{td}Needed?{td}{tr}
{tr}{td} {td}{td}ThumbBlobSize{td}{td}—?—{td}{td:align=center}{td}{td:align=center}{td}{td}—?—{td}{td}Needed?{td}{tr}
{tr}{td} {td}{td}ThumbExtensionID{td}{td}————{td}{td:align=center}————{td}{td:align=center}————{td}{td}————{td}{td}Do not import — presumably superseded by CSpace functionality{td}{tr}
{tr}{td} {td}{td}ThumbFileName{td}{td}—?—{td}{td:align=center}{td}{td:align=center}{td}{td}—?—{td}{td}Needed?{td}{tr}
{tr}{td} {td}{td}ThumbPathID{td}{td}—?—{td}{td:align=center}{td}{td:align=center}{td}{td}—?—{td}{td}Indicates location of thumbnails for the images (6 different locations){td}{tr}
{tr}{td}MediaSizes{td}{td}———{td}{td}————{td}{td:align=center}————{td}{td:align=center}no{td}{td}————{td}{td}Do not import — 1-item controlled list (35 mm) presumably superseded by CSpace
list/functionality{td}{tr}
{tr}{td}MediaStatuses{td}{td}———{td}{td}————{td}{td:align=center}————{td}{td:align=center}no{td}{td}————{td}{td}Do not import — not used by PAHMA{td}{tr}
{tr}{td}MediaTypes{td}{td}————{td}{td}————{td}{td:align=center}————{td}{td:align=center}no{td}{td}————{td}{td}Do not import — controlled list presumably superseded by CSpace list/functionality{td}{tr}
{tr}{td}MediaXrefs{td}{td}EnteredDate{td}{td}—?—{td}{td:align=center}————{td}{td:align=center}no{td}{td}—?—{td}{td}Only if useful for versioning context.{td}{tr}
{tr}{td} {td}{td}ID{td}{td}(person-related digital media){td}{td:align=center}{td}{td:align=center}{td}{td}WHERE TableID=23, use as FK to Constituents.ConstituentID to get person?s information{td}{td}{td}{tr}
{tr}{td} {td}{td}{td}{td}(exhibition-related digital media){td}{td:align=center}{td}{td:align=center}{td}{td}WHERE TableID=47, use as FK to Exhibitions.ExhibitionID to get exhibition info.{td}{td}{td}{tr}
{tr}{td} {td}{td}{td}{td}(loan-related digital media){td}{td:align=center}{td}{td:align=center}{td}{td}WHERE TableID=81, use as FK to Loans.LoanID to get loan info.{td}{td}{td}{tr}
{tr}{td} {td}{td}{td}{td}(conservation- and/or condition-related digital media){td}{td:align=center}{td}{td:align=center}{td}{td}WHERE TableID=97, use as FK to CondLineItems.CondLineItemID to get \[conservation\]
condition line item info.{td}{td}{td}{tr}
{tr}{td} {td}{td}{td}{td}(object-related digital media){td}{td:align=center}{td}{td:align=center}{td}{td}WHERE TableID=108, use as FK to Objects.ObjectID to get object info.{td}{td}{td}{tr}
{tr}{td} {td}{td}{td}{td}(historical event-related digital media){td}{td:align=center}{td}{td:align=center}{td}{td}WHERE TableID=187, use as FK to HistEvents.HistEventID to get historical event info.{td}{td}{td}{tr}
{tr}{td} {td}{td}{td}{td}(place-related digital media){td}{td:align=center}{td}{td:align=center}{td}{td}WHERE TableID=189, use as FK to Sites.SiteID to get place info.{td}{td}{td}{tr}
{tr}{td} {td}{td}{td}{td}(shipment-related digital media){td}{td:align=center}{td}{td:align=center}{td}{td}WHERE TableID=345, use as FK to Shipments.ShipmentID to get shipment info.{td}{td}{td}{tr}
{tr}{td} {td}{td}LoginID{td}{td}[Media handling information|http://wiki.collectionspace.org/display/collectionspace/Media+Handling+Schema]: contributor? (or publisher?){td}{td:align=center}no{td}{td:align=center}no{td}
{td}use as FK to Users.Login, then use Users.MTB_ConstituentID as FK to Constituents.ConstituentID to get person's info{td}{td}Only if useful for attribution content.{td}{tr}
{tr}{td} {td}{td}MediaMasterID{td}{td}————{td}{td:align=center}{td}{td:align=center}{td}{td}use as FK to MediaMaster.MediaMasterID to get media info (filename, filepath, etc.){td}{td}{td}{tr}
{tr}{td} {td}{td}MediaXrefID{td}{td}————{td}{td:align=center}————{td}{td:align=center}————{td}{td}————{td}{td}Do not import — use as PK for table{td}{tr}
{tr}{td} {td}{td}PrimaryDisplay{td}{td}—?—{td}{td:align=center}{td}{td:align=center}{td}{td}{td}{td}The primary image to be displayed is indicated by PrimaryDisplay=1{td}{tr}
{tr}{td} {td}{td}Rank{td}{td}—?—{td}{td:align=center}{td}{td:align=center}{td}{td}{td}{td}Indicates the relative display order of images (media with lower numbers should be displayed before media with higher numbers).
{td}{tr}
{tr}{td} {td}{td}Remarks{td}{td}•Schema extension/ custom field needed? (or append to [Media handling information|http://wiki.collectionspace.org/display/collectionspace/Media+Handling+Schema]: description){td}
{td:align=center}{td}{td:align=center}{td}{td}{td}{td}{td}{tr}
{tr}{td} {td}{td}TableID{td}{td}————{td}{td:align=center}{td}{td:align=center}{td}{td}use in conjunction with ID, above{td}{td}{td}{tr}
{table}

Versions Compared

Old Version 1

New Version 2

Key