EN
Español
English
Português
    AFLS_WORK_POSITIONS

    Table that serves to record the different positions (positions) of the specialists

    Data model

    Fields

    Field Type Description
    creation_date DATETIME Date of creation
    posi_active* BIT Identify whether the position is in active or inactive status.
    posi_cost* DECIMAL Cost of the user’s charge.
    posi_id* INT Primary Table Key with User Position (Position) Identifier
    posi_name* NVARCHAR (100) Name given to the user’s position.
    posi_tasks NVARCHAR (500) Duties associated with the position
    tent_id* INT Identifier of the tenant to which the user’s position belongs

    Primary Key

    PK_AFLS_WORK_POSITIONS
    posi_id

    References

    Column Referenced Table Referenced column Name
    tent_id* Bod. AFLS_TENANTS tent_id FK01_AFLS_WORK_POSITIONS