spvisualquery

Table info.

Title Sp Visual Query
Description Sp Visual Query

Fields

Name Type Required Index Hidden On form Title Pick list Description
SpVisualQueryID int(11) PRI
TimestampCreated datetime Timestamp Created timestampCreated
TimestampModified datetime Timestamp Modified timestampModified
Version int(11) Version version
Description text Description description
Name varchar(64) MUL Name name
CreatedByAgentID int(11) MUL
ModifiedByAgentID int(11) MUL
SpecifyUserID int(11) MUL

Indexes

Name Fields Unique Nullable
FK34BC5F0B4BDD9E10 SpecifyUserID
FK34BC5F0B5327F942 ModifiedByAgentID
FK34BC5F0B7699B003 CreatedByAgentID
PRIMARY SpVisualQueryID
SpVisualQueryNameIDX Name

One-to-many relationships

Name Field Related table Related field
FKE4EEDE6E2583AF6E SpVisualQueryID latlonpolygon SpVisualQueryID

Many-to-one relationships

Name Field Related table Related field
FK34BC5F0B4BDD9E10 SpecifyUserID specifyuser SpecifyUserID
FK34BC5F0B5327F942 ModifiedByAgentID agent AgentID
FK34BC5F0B7699B003 CreatedByAgentID agent AgentID