What fields do I have to manage object records?

1. Basic object information

The basic object information is structured in a series of tabs, with each unit of information allowing only a single value. This is different from “relationships” (or associations, below) where groups of information are repeated.

Description

Field name

Type of field

Constraints

Object number

text

required, unique

Entry number

text

 

Other or previous numbers

multi-line text

 

Simple name

list

required

Title

text

required

Classification

list

 

Brief description

multi-line text

 

Number of items

number

numeric

Execution date

text

 

Material/Medium

multi-line text

 

Dimensions

text

 

Acquisition (tab - single values, with audit trail)

Field name

Type of field

Constraints

Person/Organisation

list

 

Method

list

 

Date

date

 

Price

text

thousands separator

Notes

multi-line text

 

Copyright (tab - single values, with audit trail)

Field name

Type of field

Constraints

Copyright holder

text

 

Copyright contact

multi-line text

 

Copyright Credit Line

text

 

Location (tab - single values, with audit trail)

Field name

Type of field

Constraints

Current location

text

 

Condition (tab - single value, with audit trail)

Field name

Type of field

Constraints

Condition

multi-line text

 

Field collection (tab - single values, with audit trail)

Field name

Type of field

Constraints

Collection method

list

 

Person/Organisation

list

 

Place

list

 

Date

date

 

Notes

multi-line text

 

Website (tab)

Field name

Type of field

Constraints

Web description

rich text

 

Object on display

yes/no

 

On display location

text

 

2. Relationships

These here below are relationships, in the sense that there are multiple possible values for each group of information.

Artist/maker

Field name

Type of field

Constraints

Person/Organisation

list

required

Role

list

required

Notes

multi-line text

 

Related places

Field name

Type of field

Constraints

Place

list

required

Role

list

required

Notes

multi-line text

 

Related people/organisations

Field name

Type of field

Constraints

Person/Organisation

list

required

Role

list

required

Notes

multi-line text