Wikicat Technical Design/Item Entities

Wikicat datamodel for Item entities.

Wikicat Item entity

The Item entity:

    > DESC item;
    
    COLUMN        TYPE          DESC
    ----------------------------------------------------
    item_id       INT(15)       Primary key
                  NOT NULL
    mnfst_id      INT(15)       Manifestation for the item;
                  NOT NULL      foreign key to MANIFESTATION
    fingerprint   VARCHAR(50)   "Fingerprint" of the item; means of
                                identifiying older (non-mass produced)
                                monographs by taking characters from
                                certain pages to produce a unique value
    fprint_sys_code VARCHAR(3)  Finger print system code; foreign
                                key to FINGERPRINT_SCHEME_TYPE
    provenance_note VARCHAR(100) Note on the provenance of the item
    marks_note    VARCHAR(100)  Notes on any significant marks to the
                                item
    binding_state VARCHAR(3)    Condition of the book binding;
                                foreign key to ITEM_CONDITION_TYPE
    body_state    VARCHAR(3)    Condition of the main body of the item
    access_note   VARCHAR(3)    Notes on access restriction

All identifiers of the item:

    > DESC item_identifier;
    
    COLUMN        TYPE          DESC
    ----------------------------------------------------
    item_id       INT(15)       The item; foreign key to
                  NOT NULL      ITEM
    scheme_code   VARCHAR(3)    The scheme of the identifier;
                  NOT NULL      foreign key to CATALOG_ID_SCHEME
    id            VARCHAR(50)   Actual identifier

Actions applied to the item, such as exhibition, restoration/treatment, etc:

    > DESC item_action;
    
    COLUMN        TYPE          DESC
    ----------------------------------------------------
    item_id       INT(15)       The item; foreign key to
                  NOT NULL      ITEM
    action_type   VARCHAR(3)    Action type; foreign key to
                                ITEM_ACTION_TYPE
    timeframe     DATERANGES    Timeframe for the action
    institution_id INT(15)      Institution arranging the action;
                                foreign key to... INSTITUTION