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)