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 entity type, unique along with sttr_code_fin, sttr_code_ini, sttr_project, and sttr_model_id fields, reference to ASMS_TYPES.id table
    sttr_code_fin INT Unique final state identifier next to fields sttr_code_ini, sttr_category, sttr_project, and sttr_model_id, references the ASMS_STATUS.stat_id table
    sttr_code_ini INT Initial state identifier, unique next to the fields sttr_code_fin, sttr_category, sttr_project and sttr_model_id, reference the table ASMS_STATUS.stat_id
    sttr_id* INT Unique identifier of the transition
    sttr_model_id INT Model identifier, unique along with the sttr_code_fin, sttr_code_ini, sttr_category, and sttr_project fields, reference to the ASMS_MODEL.id table
    sttr_project INT Project ID, unique next to fields sttr_code_fin, sttr_code_ini, sttr_category, and sttr_model_id, reference to the ASMS_PROJECTS.id table

    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