Content Comparison

...

Document modified	By	Description
Wednesday 2017-10-25	Tim Speevack	Combined sheet and doc, fixed some column length inconsistencies.
Tuesday, 2017-11-7	Tim Speevack	Added location column for exhibitions mapping
Wednesday, 2018-01-31	Tim Speevack	Renamed checksum to cmschecksum Renamed copyrightstatus cmscopyrightstatus Renamed keywords to cmskeywords
Friday, 2018-8-3	Youjun Guo	Add column updateRequested
Friday, 2022-08-266	Jeffrey Campbell	Began adding PostgreSQL data types
Friday, 2023 -01-06	Jeffrey Campbell	Migrated from Google Doc

Table of Contents

minLevel	1
maxLevel	3

Schema Summary

Column Name SQL Server	Datatype SQL Server	Column Name PostgreSQL (if different)	Datatype PostgreSQL	Nullable	Notes	Is Attribute?
cmstype	nchar(3)		nchar	not null	Primary Key
cmsid	integer		integer	not null	Primary Key
lastmodified	datetime		timestamp(3)	not null
cmschecksum	varbinary(20)		bytea	null
cmsnumber	nvarchar(60)			not null		R/O
altcmsnumbers	nvarchar(400)			null		R/O
title	nvarchar(2000)			null		R/O
artists	nvarchar(max)		text	null		R/O
beginyear	integer		integer	null		R/O
endyear	integer		integer	null		R/O
begindate	date		date	null		R/O
enddate	date		date	null		R/O
datestring	nvarchar(200)			null		R/O
department	nvarchar(100)			null		R/O
cmskeywords	nvarchar(max)			null		R/O
classification	nvarchar(2000)			null		R/O
culture	nvarchar(100)			null		R/O
medium	nvarchar(2000)			null		R/O
creditline	nvarchar(2000)			null		R/O
creditlinerepro	nvarchar(2000)			null		R/O
cmscopyrightstatus	nvarchar(256)			null		R/O
copyrightstatement	nvarchar(1000)			null		R/O
location	nvarchar(200)			null		R/O
updateRequested	smallint		smallint	null		R/W

cmstype (Composite Primary Key)
Datatype	nchar(3)
Nullable	No
Description	String which identifies the source cms system at the unit level.
Notes	Contains short unit-specific values which identify the cms source which, combined with the cmsid, will uniquely identify the parent record in the unit’s CMS system.
Sample value	obj, exb, evt, lec, doc

cmsid (Composite Primary Key)
Datatype	integer
Nullable	No
Description	Integer which when combined with the cmstype will uniquely identify the original source record in the unit’s CMS system.
Notes	For YUAG this would be the TMS objectID or exhibitionID, or an id from a custom events database. For YPM this would be the integer identifier of the object in the EMu catalogue module.
Sample value	12345

...