Wikicat Technical Design/Graphic Enumerated Types

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

Wikicat datamodel for graphic (non-projected)-related enumerated types.

Graphic Class Material Type[edit]

    > DESC graphic_class_mat_type;
    
    COLUMN        TYPE           DESC
    ----------------------------------------------------
    class_code    VARCHAR2(3)    Graphic class of material
                  NOT NULL       code
    name          VARCHAR2(50)   Graphic class of material
                  NOT NULL       short name
                  TRANSLATABLE
    > select * graphic_class_mat_type;
    
    class_code        name
    ------------------------------------------------------
    col               Collage
    drw               Drawing
    pnt               Painting
    rep               Photomechanical Reproduction
    pne               Photonegative
    ppr               Photoprint
    pic               Picture, Generic

Values taken from UNIMARC field 116 $a/0 and MARC21 field 007/01.

Color Scheme Type[edit]

    > DESC color_scheme_type;
    
    COLUMN        TYPE           DESC
    ----------------------------------------------------
    scheme_code   VARCHAR2(3)    Color scheme code
                  NOT NULL
    name          VARCHAR2(50)   Color scheme short name
                  NOT NULL
                  TRANSLATABLE
    > select * color_scheme_type;
    
    schem_code        name
    ------------------------------------------------------
    mon               Monochromatic
    b&w               Black-and-white
    mul               Multicolored
    han               Hand colored
    mix               Mixed
    sep               Tinted/Toned/Sepia
    sta               Stained

Values taken from UNIMARC field 116 $a/3 and MARC21 field 007 /03.

Graphic Support Material[edit]

    > DESC graphic_supp_mat_type;
    
    COLUMN        TYPE           DESC
    ----------------------------------------------------
    material_code VARCHAR2(3)    Support material code
                  NOT NULL
    name          VARCHAR2(50)   Support material short name
                  NOT NULL
                  TRANSLATABLE
    > select * graphic_supp_mat_type;
    
    material_code     name
    ------------------------------------------------------
    cnv               Canvas
    bri               Bristol Board
    crd               Cardboard/Illustration Board
    gls               Glass
    syn               Synthetics
    skn               Skins
    txl               Textiles
    mtl               Metal
    pap               Paper
    pla               Plaster
    hbd               Hardboard
    pcl               Porcelain
    stn               Stone
    woo               Wood
    mix               Mixed

Values taken from UNIMARC field 116 $a/1 and MARC21 field 007/04.