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