...
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 |
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 |
...