Wikicat Technical Design/Text Enumerated Types

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

Wikicat datamodel text-related enumerated types.

Literary Form Type[edit]

Literary form types.

    > DESC literary_form_type;
    
    COLUMN        TYPE           DESC
    ----------------------------------------------------
    lit_form_code VARCHAR2(3)    Literary form code
                  NOT NULL 
    name          VARCHAR2(50)   Literary form short name
                  NOT NULL
                  TRANSLATABLE
    > select * literary_form_type;
    
    lit_form_code     name
    ------------------------------------------------------
    alg               Allegory
    aph               Aphorism/Anecdote
    bio               Biography
    com               Comic Strip
    chr               Chronicle
    dia               Diary
    dra               Drama
    epi               Letter/Epistle
    ero               Erotica
    ess               Essay/Feuilleton
    fab               Fable
    fai               Fairy Tale
    hly               Hagiography
    hum               Humor/Satire
    leg               Legend
    lib               Libretto
    mem               Memoir
    mix               Mixed Form
    mys               Mystic Literature
    nov               Novel
    nva               Novella
    par               Parable
    poe               Poetry
    rom               Romance
    spe               Speech/Oratory
    sst               Short Story
    trv               Travelogue

Values taken from UNIMARC field 105 $a/11, UNIMARC field 140 $a/17-18 and MARC21 field 008 /33

Biography Type[edit]

Types of biographical material.

    > DESC biography_type;
    
    COLUMN        TYPE           DESC
    ----------------------------------------------------
    biography_code VARCHAR2(3)   Biography type code
                  NOT NULL 
    name          VARCHAR2(50)   Biography type short name
                  NOT NULL
                  TRANSLATABLE
    > select * biography_type;
    
    biography_code    name
    ------------------------------------------------------
    aut               Autobiography
    inv               Individual Biography
    col               Collective Biography
    inf               Contains Biographical Info

Values taken from UNIMARC field 105 $a/4-7 and MARC21 field 008 /12

Specialized Text Content[edit]

Specialized textual content types.

    > DESC special_txt_content_type;
    
    COLUMN        TYPE           DESC
    ----------------------------------------------------
    txt_contnt_code VARCHAR2(3)  Special textual content code
                  NOT NULL 
    name          VARCHAR2(50)   Special textual content short name
                  NOT NULL
                  TRANSLATABLE
    > select * special_txt_content_type;
    
    txt_contnt_code   name
    ------------------------------------------------------
    abs               Abstract/Summary
    bib               Bibliography
    cal               Calendar
    com               Cartoon/Comic Strip
    cat               Catalog
    cte               Catechism
    dev               Devotional Literature
    dct               Dictionary
    dir               Directory
    dsc               Discography
    dis               Discursive
    enc               Encylopedia
    eph               Ephemera
    eul               Commemorative/Eulogistic
    exm               Exam
    flm               Filmography
    gen               Genealogy
    hbk               Handbook
    hst               Historical Work, General
    inx               Index, Separate
    ins               Instructional, General
    lwr               Law Report/Digest
    lga               Legal Articles
    lec               Legal Case
    law               Legislation
    num               Numeric Table
    pat               Patent Document
    pol               Polemical Treatise
    pro               Program Textbook
    prj               Project Description
    rec               Recordkeeping
    div               Recreational/Diversional
    rls               Religious Service Work
    rel               Religious Work, General
    rev               Review
    ser               Sermon
    sci               Scientific Work
    soc               Social Customs Rulebook
    sta               Standard/Specification
    sta               Statistics
    sur               Subject Literature Survey
    tkr               Technical Report
    txb               Textbook
    ths               Thesis
    the               Thesaurus
    trt               Treaty

Values taken from UNIMARC field 105 $a/4-7, UNIMARC field 140 $a/9-16 and MARC21 field 008 /24-27

Text Format[edit]

    > DESC text_format_type;
    
    COLUMN        TYPE           DESC
    ----------------------------------------------------
    format_code   VARCHAR2(3)    Text format code
                  NOT NULL
    name          VARCHAR2(50)   Text format short name
                  NOT NULL
                  TRANSLATABLE
    > select * text_format_type;
    
    format_code       name
    ------------------------------------------------------
    lpr               Large Print
    nws               Newspaper Format
    bra               Braille or Moon Script
    mic               Microprint
    man               Hand-written
    mlt               Multimedia
    min               Mini-print
    pri               Regular Rrint

Values taken from UNIMARC field 106 $a and MARC21 field 007 /1

Writing Material Type[edit]

    > DESC writing_material_type;
    
    COLUMN        TYPE           DESC
    ----------------------------------------------------
    material_code VARCHAR2(3)    Writing material medium code
                  NOT NULL
    name          VARCHAR2(50)   Writing material short name
                  NOT NULL
                  TRANSLATABLE
    > select * writing_material_type;
    
    medium_code       name
    ------------------------------------------------------
    pap               Paper, General
    hnd               Hand-made Paper
    ric               Rice Paper
    woo               Wood-pulp Paper
    pch               Parchment, Vellum

Values taken from UNIMARC field 106 $a/20.