jjwg_maps


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id CHAR 36 null
jjwg_maps_audit.parent_id Defined in XMLR
jjwg_maps_jjwg_areas_c.jjwg_maps_5304wg_maps_ida Defined in XMLR
jjwg_maps_jjwg_markers_c.jjwg_maps_b229wg_maps_ida Defined in XMLR
securitygroups_records.record_id Defined in XMLR
name VARCHAR 255 √ null
date_entered DATETIME 26 √ null
date_modified DATETIME 26 √ null
modified_user_id CHAR 36 √ null
users.id Defined in XMLR
created_by CHAR 36 √ null
users.id Defined in XMLR
description TEXT 65535 √ null
deleted BIT 1 √ 0
assigned_user_id CHAR 36 √ null
users.id Defined in XMLR
distance FLOAT 9,4 √ null
unit_type VARCHAR 100 √ mi
module_type VARCHAR 100 √ Accounts
parent_type VARCHAR 255 √ null
parent_id CHAR 36 √ null
accounts.id Defined in XMLR
cases.id Defined in XMLR
contacts.id Defined in XMLR
leads.id Defined in XMLR
meetings.id Defined in XMLR
opportunities.id Defined in XMLR
project.id Defined in XMLR
prospects.id Defined in XMLR

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id

Relationships

Close relationships within degrees of separation