Wikicat Technical Design/Projected Image Enumerated Types

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

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.