Wikicat Technical Design/Expression Entities

Wikicat data model for Expression-related entities.

Expression

edit
    > DESC expression;
    
    COLUMN        TYPE          DESC
    ----------------------------------------------------
    expr_id       INT(15)       Primary key of the entity
                  NOT NULL
    expr_form     VARCHAR(3)    Form of expression; foreign key to
                  NOT NULL      EXPRESSION_FORM_TYPE
    date_creation FUZZYDATE     Date of creation
                  NOT NULL
    date_publication DATERANGE  Date of publication/distribution
    notes_publication VARCHAR(200) Notes on publication/distribution
    other_distinguisher         Other expression distinguishing characteristic
                  VARCHAR(200)
    revisable_flag BOOLEAN      Whether the expression is revisable
                  NOT NULL
    extensible_flag BOOLEAN     Whether the expression is extensible
    extent_value  FLOAT         Extent of the expression
    extent_unit   VARCHAR(3)    Unit of measure for the extent;
                                foreign key to EXTENT_UNIT_TYPE
    extent_notes  VARCHAR(100)  Expression extent notes
    content_summary VARCHAR(200) Summary of the contents- e.g.
                                abstract, synopsis, etc.
    content_list  VARCHAR(200)  List of contents
    generative_context INT(8)   Intellectual, social, historical,
                                or artistic context in which the
                                work was realized.  Foreign key to...
    crit_response_note VARCHAR(200) Critical response note
    use_restrictions VARCHAR(50) Use restriction note- e.g. copyright
    music_attrib_id INT(8)      Musical attributes of an expression;
                                foreign key to EXPRESSION_MUSIC_ATTRIBS
    cartgrph_attrib_id INT(8)   Cartographic attribtues; foreign key to
                                EXPRESSION_CARTGRPH_ATTRIBS

Expression Language

edit

Language of the expression; intersection table is needed as an Expression can have multiple languages. Note that this is not intended to express all the languages of agreggate composed of sub-Expressions in multiple languages.

    > DESC expression_language;
    
    COLUMN        TYPE          DESC
    ----------------------------------------------------
    expr_id       INT(15)       Foreign key to EXPRESSION
                  NOT NULL
    expr_lang     INT(15)       Language of expression; foreign                    
                                key to the Ultimate Wiktionary table Language
    expr_lang_note VARCHAR(100) Note on expression language
    expr_script   INT(15)       Script of the expression foreign key
                                to Ultimate Wiktionary table Script

Expression Musical Attributes

edit
    > DESC expression_music_attribs;
    
    COLUMN        TYPE          DESC
    ----------------------------------------------------
    expr_music_id INT(15)       Primary key
                  NOT NULL
    score_type    VARCHAR(3)    Type of score; foreign key to MUSIC_SCORE_TYPE
    score_note    VARCHAR(100)  Note about the score

Expression Cartographic Attributes

edit
    > DESC expression_cartgrph_attribs;
    
    COLUMN        TYPE          DESC
    ----------------------------------------------------
    expr_crtgrph_id INT(15)     Primary key
                  NOT NULL
    scale_type    VARCHAR(3)    Scale type; foreign key to CARTGRPH_SCALE_TYPE
    scale_note    VARCHAR(100)  Scale note.
    projection_meth VARCHAR(3)  Projection method; foreign key to
                                CARTGRPH_PROJ_TYPE
    phys_dimension INT(1)       Physical dimensions of the item;
                                (2) or (3) dimensions

Expression Cartographic Scale

edit
    > DESC expression_cartgrph_scale;
    
    COLUMN        TYPE          DESC
    ----------------------------------------------------
    expr_id       INT(15)       Foreign key to EXPRESSION
                  NOT NULL
    axis_type     VARCHAR2(3)   Axis type of the scale; foreign
                  NOT NULL      key to CARTGRPH_AXIS_TYPE
    scale_ratio   FLOAT         Scale ration as a real number
                  NOT NULL

Expression Cartographic Imaging Technique

edit

Intersection table between EXPRESSION and CARTGRPH_IMAGING_TYPE, indicating imaging techniques used by the item.

    > DESC expression_cartgrph_imaging;
    
    COLUMN        TYPE          DESC
    ----------------------------------------------------
    expr_id       INT(15)       Foreign key to EXPRESSION
                  NOT NULL
    image_tech    VARCHAR(3)    Imaging technique; foreign key to 
                  NOT NULL      CARTGRPH_IMAGING_TYPE

Expression Cartographic Relief Technique

edit

Intersection table between EXPRESSION and CARTGRPH_RELIEF_TYPE, indicating relief techniques used by the item.

    > DESC expression_cartgrph_relief;
    
    COLUMN        TYPE          DESC
    ----------------------------------------------------
    expr_id       INT(15)       Foreign key to EXPRESSION
                  NOT NULL
    relief_tech   VARCHAR(3)    Relief technique; foreign key to 
                  NOT NULL      CARTGRPH_RELIEF_TYPE

Expression Cartographic Presentation Technique

edit

Intersection table between EXPRESSION and CARTGRPH_PRESENT_TYPE, indicating presentation techniques used by the item.

    > DESC expression_cartgrph_presentation;
    
    COLUMN        TYPE          DESC
    ----------------------------------------------------
    expr_id       INT(15)       Foreign key to EXPRESSION
                  NOT NULL
    present_tech  VARCHAR(3)    Presentation technique; foreign key to 
                  NOT NULL      CARTGRPH_PRESENT_TYPE

Expression Cartographic RSI Method

edit

Intersection table between EXPRESSION and CARTGRPH_RSI_TYPE, indicating remote sensing image recording techniques used by the item.

    > DESC expression_cartgrph_rsi_method;
    
    COLUMN        TYPE          DESC
    ----------------------------------------------------
    expr_id       INT(15)       Foreign key to EXPRESSION
                  NOT NULL
    rsi_tech      VARCHAR(3)    Remote sensing image recording technique; foreign key to 
                  NOT NULL      CARTGRPH_RSI_TYPE