...
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 |
Schema Column Details
| Anchor | | cmstype-(comp) | cmstype-(comp) | |
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 | |||
...