JDBC Driver for SugarCRM

Build 23.0.8839

Relationships

The Relationships View. This view provides information regarding different relationships between tables.

Columns

Name Type Description
Name String The name of the relationship.
DynamicSubpanel String The dynamic subpanel of the relationship.
JoinKeyLhs String The lhs join key of the relationship.
JoinKeyRhs String The rhs join key of the relationship.
JoinTable String The name of join table.
LhsKey String The lhs key of the relationship.
LhsModule String The lhs module of the relationship.
LhsTable String The lhs table of the relationship.
RelationshipRoleColumn String The name of the relationship role column.
RelationshipRoleColumnValue String The value of the relationship role column.
RelationshipType String The type of the relationship.
PrimaryFlagColumn String The name of the primary flag column.
PrimaryFlagDefault String The default value of the primary flag.
PrimaryFlagSide String The side of the primary flag.
RhsKey String The rhs key of the relationship.
RhsModule String The rhs module of the relationship.
RhsTable String The rhs table of the relationship.
TrueRelationshipType String The true type of the relationship.
UserField String The name of the user field.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 23.0.8839