Database and Metadata Structure
Data Types
Archive Metadata
id
init(11)
width
decimal(5)
height
decimal(5)
depth
decimal(5)
media type
init(2)
book/magazine
1. LLC number
2. publisher
varchar(255)
3. publisher city
varchar(255)
4. volume/No/Edition
varchar(255)
5. pages
init(11)
photograph
format
init(2)
1. 35mm negative
2. copy negative
3. copy print
4. transparency
5. black and white print
6. slide
7. C-print
8. contact sheet
9. Polaroid
audio recording
length
init(11)
format
init(2)
1. 8-track
2. 1/4" reel
3. cassette
4. micro cassette
5. LP
6. 45
7. CD
8. diskette
9. DVD
10. CD-R
11. DAT
video
length
init(11)
colour
binary
aspect ratio
varchar(5)
format
init(2)
1. 1/2" reel
2. 3/4" umatic
3. 3/4" SP
4. 1" reel
5. 2" Quadruplex
6. super 8mm
7. Single 8
8. 8mm
9. 16mm
10. 35mm
11. betacam
12. betacam SP
13. betamax
14. VHS
15. S-VHS
16. VHS-C
17. VHS-HQ
18. DV CAM/SP
19. DVD
20. CD-R
21. DAT
22. Digital 8
23. DV
24. Mini-DV
25. beta F1
26. diskette
27. U-matic
system
init(2)
1. PAL
2. NTSC
3. SECAM
ephemera
format
init(2)
1. invitation
2. press release
3. letter
4. clipping
5. brochure
6. leaflet
7. pamphlet
8. postcard
9. poster
10. broadsheet
11. bookmark
12. ticket
13. handbill
title
varchar(255)
assigned title?
binary
. yes
. no
date
date (yyyy-mm-dd)
assigned date?
binary
. yes
. no
credit
text
keywords
text (comma delimitated)
short description
text
creator(s)
init(11)
role
init(2)
1. artist
2. curator
3. speaker
4. writer
5. performer
6. conductor
7. composer
8. editor
9. photographer (if not the artist)
10. cinematographer
11. art director
12. designer
location source
varchar(255)
location fond
varchar(255)
location code
varchar(255)
Creator Metadata
id
init(11)
url
varchar(255)
biography
text
date of birth
year
city of birth
varchar(255)
country of birth
varchar(255)