Wikicat Technical Design/Microform Enumerated Types

From Meta, a Wikimedia project coordination wiki
Jump to navigation Jump to search

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.