EN
Español
English
Português
    ASMS_PROJECT_CONTRACT

    Contains the relationship between a project and a contract

    Data model

    Fields

    Field Type Description
    cont_contractid* INT Unique identifier of the contract, reference to table ASMS_CONTRACT. ContractId
    cont_projectid* INT Unique identifier of the project, reference to the ASMS_PROJECTS.proj_id table

    Primary Key

    PK_ASMS_PROJECT_CONTRACT
    cont_contractid, cont_projectid

    References

    Column Referenced Table Referenced column Name
    cont_contractid* dbo.ASMS_CONTRACT contractid FK02_ASMS_PROJECT_CONTRACT
    cont_projectid* dbo.ASMS_PROJECTS proj_id FK01_ASMS_PROJECT_CONTRACT