Wikicat Technical Design/Projected Image Enumerated Types
Wikicat datamodel for movie/cinemagraphic (as well as projected image)-related enumerated types.
Projected Image Class Type
> DESC proj_img_class_type;
COLUMN TYPE DESC
----------------------------------------------------
class_code VARCHAR2(3) Projected image class code
NOT NULL
name VARCHAR2(50) Projected image class short name
NOT NULL
TRANSLATABLE
> select * proj_img_class_type
class_code name
------------------------------------------------------
flm Film
vid Video
sld Slide
trp Transparency
Video Technique
Technique for video, motion picture class of material.
> DESC video_technique_type;
COLUMN TYPE DESC
----------------------------------------------------
vid_tech_code VARCHAR(3) Video technique type code
NOT NULL
name VARCHAR(50) Video technique type short name
NOT NULL
TRANSLATABLE
> select * video_technique_type;
vid_tech_code name
------------------------------------------------------
anm Animation
liv Live Action
mix Animation and Live Action
Values taken from UNIMARC field 115 $a/9 and MARC21 008 /34.
Movie Presentation Format Type
> DESC movie_present_type;
COLUMN TYPE DESC
----------------------------------------------------
present_code VARCHAR2(3) Movie presentation format
NOT NULL code
name VARCHAR2(50) Movie presentation format
NOT NULL short name
TRANSLATABLE
> select * movie_present_type;
present_code name
------------------------------------------------------
std Standard Sound Aperture
nam Non-Anamorphic (Wide Screen)
3d 3D
ana Anamorphic (Wide Screen)
ssa Standard Silent Aperture
wid Wide Screen, Other
Values taken from UNIMARC field 115 $a/10 and MARC21 field 007 /04.
Movie Sound Media Type
> DESC movie_sound_media_type;
COLUMN TYPE DESC
----------------------------------------------------
media_code VARCHAR2(3) Film sound media code
NOT NULL
name VARCHAR2(50) Film sound media short name
NOT NULL
TRANSLATABLE
> select * movie_sound_media_type;
media_code name
------------------------------------------------------
opf Optical Sound Track, On Film
mgf Magnetic Sound Track, On Film
mgc Magnetic Audio Tape, Cartridge
sdc Sound Disc
mgr Magnetic Audio Tape, On Reel
mgs Magnetic Audio Tape, Cassette
omf Optical and Magnetic Sound Track, On Film
vtp Videotape
vdc Videodisc
Values taken from UNIMARC field 115 $a/6 and MARC21 field 007 /06.
Video Format Type
> DESC video_format_type;
COLUMN TYPE DESC
----------------------------------------------------
format_code VARCHAR2(3) Video recording format code
NOT NULL
name VARCHAR2(50) Video recording format short name
NOT NULL
TRANSLATABLE
> select * video_format_type;
format_code name
------------------------------------------------------
bet Beta
vhs VHS
umt U-matic
eij EIAJ
tyc Type C
qua Quadruplex
las Laser Optical Videodisc
ced CED
bet Betacam
bsp Betacam SP
svh Super-VHS
mii M-II
d2 D-2
8mm 8 mm.
hi8 Hi-8 mm.
dvd DVD
v8 Video8
v20 V2000
Values taken from UNIMARC field 115 $a/16 and MARC21 field 007 /04.
Projected Image Carrier Type
> DESC proj_img_carrier_type;
COLUMN TYPE DESC
----------------------------------------------------
form_code VARCHAR2(3) Projected image form carrier
NOT NULL format code
name VARCHAR2(50) Projected image form carrier
NOT NULL short name
TRANSLATABLE
> select * proj_img_carrier_type;
form_code name
------------------------------------------------------
fre Film Reel
fcr Film Cartridge
fca Film Cassette
fot Film Type, Other
fsc Filmstrip Cartridge
fsl Filmslip
fto Filmstrip Type, Other
fsr Film Strip Roll
sli Slide/Slide set/Stereograph
tra Transparency
vca Videocartridge
vds Videodisc
vcs Videocassette
vre Videoreel
evr Electronic Videorecording
Values synthesized from UNIMARC field 115 a$8, $a/15 and MARC21 fields 007 /01 [1] [2] [3]
Base Emulsion Type
> DESC base_emulsion_type;
COLUMN TYPE DESC
----------------------------------------------------
base_code VARCHAR2(3) Base on emulsion material
NOT NULL format code
name VARCHAR2(50) Base on emulsion material
NOT NULL short name
TRANSLATABLE
> select * base_emulsion_type
base_code name
------------------------------------------------------
saf Safety Film
fot Film Base, Non-Safety Film
syn Synthetics
mix Mixed Collection
gla Glass
pap Paper
Values taken from UNIMARC field 115 $a/17 and MARC21 field 007 /04.
Film Base Type
> DESC film_base_type;
COLUMN TYPE DESC
----------------------------------------------------
base_code VARCHAR2(3) Film base format code
NOT NULL
name VARCHAR2(50) Film base short name
NOT NULL
TRANSLATABLE
> select * film_base_type
base_code name
------------------------------------------------------
sf3 Safety, Triacetate
nit Nitrate
sf2 Safety, Diacetate
ply Polyester
mix Mixed Base
Values taken from UNIMARC field 115 $b/4 and MARC21 field 007 /12.
Color Film Stock Type
> DESC color_film_stock_type;
COLUMN TYPE DESC
----------------------------------------------------
stock_code VARCHAR2(3) Color film stock format code
NOT NULL
name VARCHAR2(50) Color film stock short name
NOT NULL
TRANSLATABLE
> select * color_film_stock_type
stock_code name
------------------------------------------------------
idt Imbibition Dye Transfer
3ly Three Layer
3lf Three Layer, Low Fade
dup Duplitised
Values taken from UNIMARC field 115 $b/6 and MARC21 field 007 /14.
Projected Image Mounting
> DESC proj_img_mount_type;
COLUMN TYPE DESC
----------------------------------------------------
mount_code VARCHAR2(3) Projected image mounting code
NOT NULL
name VARCHAR2(50) Projected image mounting short name
NOT NULL
TRANSLATABLE
> select * proj_img_mount_type
stock_code name
------------------------------------------------------
crd Cardboard
gls Glass
syn Synthetics
mtl Metal
m&g Metal and Glass
s&g Synthetics and Glass
Values taken from UNIMARC field 115 $a/18 and MARC21 field 007 /08.
Projected Image Dimensions Type
> DESC proj_img_size_type;
COLUMN TYPE DESC
----------------------------------------------------
size_code VARCHAR2(3) Projected image size code
NOT NULL
name VARCHAR2(50) Projected image size short name
NOT NULL
TRANSLATABLE
proj_class VARCHAR(3) Primary projected image class; foreign
key to PROJ_IMG_CLASS_TYPE
> select * proj_img_size_type
size_code name proj_class
------------------------------------------------------
8mm 8mm flm
s8m Super 8mm flm
9mm 9.5mm flm
16m 16mm flm
28m 28mm flm
35m 35mm flm
70m 70mm flm
2q2 2.25 x 2.25 in. sld
2x2 2 x 2 in. sld
.75 3/4 in. vid
.25 1/4 in. vid
.5i 1/2 in. vid
1in 1 in. vid
2in 2 in. vid
810 8 x 10 in. trp
4x5 4 x 5 in. trp
5x7 5 x 7 in. trp
7x7 7 x 7 in. trp
8x8 8 x 8 in. trp
9x9 9 x 9 in. trp
10x 10 x 10 in. trp
Values taken from UNIMARC field 115 $a/7 MARC21 field 007 /07 [4] [5] [6].
Video Broadcast Standard Type
> DESC video_broadcast_type;
COLUMN TYPE DESC
----------------------------------------------------
bcast_code VARCHAR2(3) Video broadcast standard code
NOT NULL
name VARCHAR2(50) Video broadcast standard short name
NOT NULL
TRANSLATABLE
> select * video_broadcast_type;
bcast_code name
------------------------------------------------------
405 405
nts NTSC (525)
pal 625 PAL
sec 625 SECAM
112 1125
Values taken from UNIMARC field 115 $a/19.
Film Generation Type
> DESC film_generation_type;
COLUMN TYPE DESC
----------------------------------------------------
gen_code VARCHAR2(3) Film generation code
NOT NULL
name VARCHAR2(50) Film generation short name
NOT NULL
TRANSLATABLE
> select * proj_img_generation_type
gen_code name
------------------------------------------------------
org Original
mst Master
dup Duplicate
ref Reference Print/Viewing Copy
Values taken from UNIMARC field 115 $b/0 MARC21 field 007 /11.