EN
Español
English
Português
    ASMS_STATUS_TRANSITION

    Contains the information about the transition between two states

    Data model

    Fields

    Field Type Description
    sttr_category INT Related, unique entity type along with the sttr_code_fin, sttr_code_ini, sttr_project, and sttr_model_id fields
    sttr_code_fin INT Unique end-state identifier next to the sttr_code_ini, sttr_category, sttr_project, and sttr_model_id fields
    sttr_code_ini INT A unique initial state identifier next to the sttr_code_fin, sttr_category, sttr_project, and sttr_model_id fields
    sttr_id* INT Unique identifier of the transition
    sttr_model_id INT Unique model identifier along with fields sttr_code_fin, sttr_code_ini, sttr_category, and sttr_project
    sttr_project INT Unique project identifier next to fields sttr_code_fin, sttr_code_ini, sttr_category, and sttr_model_id

    Primary Key

    PK_ASMS_STATUS_TRANSITION
    sttr_id

    References

    Column Referenced Table Referenced column Name
    sttr_category dbo.ASMS_TYPES id FK03_ASMS_STATUS_TRANSITION
    sttr_code_fin dbo.ASMS_STATUS stat_id FK02_ASMS_STATUS_TRANSITION
    sttr_code_ini dbo.ASMS_STATUS stat_id FK01_ASMS_STATUS_TRANSITION
    sttr_model_id dbo.ASMS_MODEL id FK05_ASMS_STATUS_TRANSITION
    sttr_project dbo.ASMS_PROJECTS proj_id FK04_ASMS_STATUS_TRANSITION