EN
Español
English
Português
    AFLS_ZONES

    Table to store the location points of certain zones of the system.

    Data model

    Fields

    Field Type Description
    zone_creationdate* DATETIME Column containing the date of the record within the table
    zone_description NVARCHAR (510) Column containing the description of the zone configured in the system
    zone_id* INT Primary Table Key
    zone_is_active* BIT Identifies whether the zone registered in the current table is active or inactive
    zone_is_deleted* BIT Marking to identify if the configured zone record is in a deleted state
    zone_latitude DECIMAL It corresponds to the distance in degrees, minutes and seconds with respect to the parallel of the equator for the zone configured in the system
    zone_longitude DECIMAL Corresponds to the distance in degrees, minutes and seconds with respect to the greenwich meridian for the zone configured in the system
    zone_modifieddate DATETIME Column that contains the date of the record update in the table
    zone_name* NVARCHAR (510) Column containing the information corresponding to the name of the zone configured in the system
    zone_priority_order* INT Identifies the order in which the zone is configured
    zone_radio FLOAT Corresponds to the number value of the radius corresponding to the zone configured in the system
    zone_type NVARCHAR (200) Identifies the type of zone configured in the system

    Primary Key

    PK_AFLS_ZONES
    zone_id