EN
Español
English
Português
    ASMS_LOCATION

    Represents locations within the company

    Data model

    Fields

    Field Type Description
    address* NVARCHAR (510) Location Address
    building_id INT Identifier of the associated catalog (catalog BUILDING1), reference the table AFW_CATALOG.cata_id
    city_id* INT Identifier of the associated catalog (CITY catalog), reference the table AFW_CATALOG.cata_id
    company_id INT Identifier of the associated catalog (COMPANY catalog), reference the table AFW_CATALOG.cata_id
    country_id INT Identifier of the associated catalog (COUNTRY catalog), reference the table AFW_CATALOG.cata_id
    department_id INT Identifier of the associated catalog (DEDEPARTMENTAL catalog), reference the table AFW_CATALOG.cata_id
    description* NVARCHAR (510) Description of the location
    floor_id INT Identifier of the associated catalog (FLOOR catalog), reference the table AFW_CATALOG.cata_id
    id* INT Location Identifier
    name* NVARCHAR (510) Location Name
    numberdep_id INT Identifier of the associated catalog (catalog DEDEPARTMENTNUMBER), reference the table AFW_CATALOG.cata_id
    phone NVARCHAR (510) Location Phone
    project_id* INT Associated project ID, reference table ASMS_PROJECTS.proj_id
    site_id INT Identifier of the associated catalog (SITE catalog), reference the table AFW_CATALOG.cata_id

    Primary Key

    PK_LOCATION
    id

    References

    Column Referenced Table Referenced column Name
    project_id* dbo.ASMS_PROJECTS proj_id FK01_ASMS_LOCATION