Wikicat Technical Design/Microform Enumerated Types
Wikicat datamodel microform enumerated types.
Form Type
[edit] > DESC microform_form_type;
COLUMN TYPE DESC
----------------------------------------------------
form_code VARCHAR2(3) Form code
NOT NULL
name VARCHAR2(50) Form short name
NOT NULL
TRANSLATABLE
> select * microform_form_type;
form_code name
------------------------------------------------------
apc Aperture Card
crt Microform Cartridge
fcs Microfilm Cassette
fre Microfilm Reel
fch Microfiche
fcc Microfiche Cassette
opq Micro Opaque
slp Microfilm Slip
Values taken from UNIMARC field 130 $a/0 and MARC21 field 007 /01.
Polarity Type
[edit] > DESC polarity_type;
COLUMN TYPE DESC
----------------------------------------------------
polarity_code VARCHAR2(3) Polarity code
NOT NULL
name VARCHAR2(50) Polarity short name
NOT NULL
TRANSLATABLE
> select * polarity_type;
polarity_code name
------------------------------------------------------
pos Positive
neg Negative
mix Mixed
Values taken from UNIMARC field 130 $a/1 and MARC21 field 007 /03.
Emulsion Type
[edit] > DESC microform_emulsion_type;
COLUMN TYPE DESC
----------------------------------------------------
emulsion_code VARCHAR2(3) Emulsion code
NOT NULL
name VARCHAR2(50) Emulsion short name
NOT NULL
TRANSLATABLE
> select * microform_emulsion_type;
emulsion_code name
------------------------------------------------------
slv Silver Halide
dzo Diazo
ves Vesicular
mix Mixed
Values taken from UNIMARC field 130 $a/8 and MARC21 field 007 /10.
Film Base Type
[edit] > DESC microform_film_base_type;
COLUMN TYPE DESC
----------------------------------------------------
base_code VARCHAR2(3) Film base code
NOT NULL
name VARCHAR2(50) Film base short name
NOT NULL
TRANSLATABLE
> select * microform_film_base_type;
base_code name
------------------------------------------------------
sfe Safety Base, Undetermined
ace Safety Base, Acetate Undetermined
2ac Safety Base, Diacetate
ply Safety Base, Polyester
sfm Safety Base, Mixed
3ac Safety Base, Triacetate
nit Nitrate Base
mix Mixed Base (Nitrate and Safety)
Values taken from UNIMARC field 130 $a/10 and MARC21 field 007 /12.
Carrier Size Type
[edit] > DESC microform_size_type;
COLUMN TYPE DESC
----------------------------------------------------
size_code VARCHAR2(3) Carrier size code
NOT NULL
name VARCHAR2(50) Carrier size short name
NOT NULL
TRANSLATABLE
form VARCHAR(3) Primary form; foreign key to
MICROFORM_FORM_TYPE
> select * microform_size_type;
size_code name form_code
------------------------------------------------------
8mm 8 mm fre
16m 16 mm fre
35m 35 mm fre
70m 70 mm fre
105 105 mm fre
3x5 3x5 in. (8x13 cm) fch
4x6 4x6 in. (llx15 cm) fch
6x9 6x9 in. (16x23 cm) fch
3x7 3 1/4x7 3/8 in. (9xl9 cm) apc
Values taken from UNIMARC field 130 $a/2 and MARC21 field 007 /04.