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 Associated catalog identifier (BUILDING1 catalog)
    city_id* INT Identifier of the associated catalog (CITY catalog)
    company_id INT Associated catalog identifier (COMPANY catalog)
    country_id INT Identifier of the associated catalog (COUNTRY catalog)
    department_id INT Identifier of the associated catalog (DEDEPARTMENTAL catalog)
    description* NVARCHAR (510) Description of the location
    floor_id INT Associated catalog identifier (FLOOR catalog)
    id* INT Location Identifier
    name* NVARCHAR (510) Location Name
    numberdep_id INT Associated catalog identifier (catalog DEDEPARTMENTNUMBER)
    phone NVARCHAR (510) Location Phone
    project_id* INT Associated project ID
    site_id INT Associated catalog identifier (SITE catalog)

    Primary Key

    PK_LOCATION
    id

    References

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