Versions Compared

Old Version 1

changes.mady.by.user Nadja Pollard

Saved on

compared with

New Version Current

changes.mady.by.user Nadja Pollard

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Public Methods

MethodDescription

 BoundAttachments

Get all the BoundAttachments of this Relationship.

 ChildAction

Returns the child action of the given type.

The

Valid action types are

'

: INSERT

'

,

'

UPDATE

' or '

, and DELETE

'

. The return action names are

'

: NONE

'

,

'

RESTRICT

'

,

'

CASCADE

'

,

'

SETNULL

' or '

, and SETDEFAULT

'

. PARAMETERS: ActionType

as

(String). RETURN DATATYPE: String.

 FKColumnPairs

Returns an object representing a collection of all foreign key column pairs maintained by the relationship.

 ParentAction

Returns the parent action of the given type.

The

Valid action types are

'

: INSERT

'

,

'

UPDATE

' or '

, and DELETE

'

. The return action names are

'

: NONE

'

,

'

RESTRICT

'

,

'

CASCADE

'

,

'

SETNULL

' or '

, and SETDEFAULT

'

. PARAMETERS: ActionType

as

(String). RETURN DATATYPE: String.

 RepoCheckOutStatus

Get the Check Out status of this Relationship object. DATATYPE: StringObjects.

 RepoVersionHistory

Get the Version History of this Relationship from the Repository server. Return the data in the StringObjects collection. DATATYPE: StringObjects.

 SetChildAction

Sets the child action of the given type with the given action.

The

Valid action types are

'

: INSERT

'

,

'

UPDATE

'

, or

'

DELETE

'

. The action names are

'

: NONE

'

,

'

RESTRICT

'

,

'

CASCADE

'

,

'

SETNULL

' or '

, and SETDEFAULT

'

. PARAMETERS: ActionType

as String, ActionName as String

and ActionName (Strings).

 SetParentAction

Sets the parent action of the given type with the given action.

The

Valid action types are

'

: INSERT

'

,

'

UPDATE

' or '

, and DELETE

'

. The action names are

'

: NONE

'

,

'

RESTRICT

'

,

'

CASCADE

'

,

'

SETNULL

' or '

, and SETDEFAULT

'

. PARAMETERS: ActionType

as String, ActionName as String

and ActionName (Strings).

 UserComments

Returns a collection of user comments associated with this Relationship.

Public Properties

MethodDescription

 BusinessName

This is the business

Business name of the relationship. DATATYPE: String.

 CardinalityNo

This is the

Child Cardinality

No

Number of the relationship. Valid values are: 0 = Zero or One to Zero or More, 1 =

0,

Zero or One to One or More, 2 =

1,

Zero or One to Zero or One, 3 =

2,

Zero or One to exactly N

= 3

. DATATYPE: Integer.

 CardinalityValue

This is the

Cardinality Value of the relationship when the Cardinality No is 3 (Zero or One to exactly N). DATATYPE: Integer.

 ChildEntity

This is the child

Child entity of the relationship.

 DB2OSNotEnforced

This property specifies if

DB2 OS390 V8 and later only. Specifies whether a relationship is

enforced or not

enforced

. It applies only to DB2 OS390 V8 or later versions of the platform

. DATATYPE: Boolean.

 Deferrable

If true, you can defer the FK constriant check

can be deferred

to the end of the transaction. DATATYPE: Boolean.

 Definition

This is the definition

Definition of the relationship. DATATYPE: String.

 Disable

Applies to

Oracle

platforms

only. Determines if the FK constraint is disabled (true

) or enabled (false

). When set to false, the corresponding PK is also set to false. DATATYPE: Boolean.

 DoNotGenerate

If true, the Foreign Key Constraint

will

is not

be

generated in the DDL of the Child Entity. DATATYPE: Boolean.

 GUID

GUID of the relationship

. This GUID is

as assigned by ER/Studio. Each relationship has a unique GUID. DATATYPE: String.

 ID

ID of the relationship

. This ID is

as assigned by ER/Studio. Each relationship in a diagram has a unique ID. DATATYPE: Integer.

 InitiallyDeferred

If true, the FK constriant check is Initially Deferred. DATATYPE: Boolean.

 InterModelID

InterModelID of the object

. This ID is

as assigned by ER/Studio. DATATYPE: Integer.

 InversePhrase

This is the inverse

Inverse verb phrase of the relationship. DATATYPE: String.

 LogOrPhysOnly

Controls the logical/physical-only Relationship Property. DATATYPE: Boolean.

 Mandatory

This determines if

Determines whether the relationship is mandatory (true

) or not (false

). DATATYPE: Boolean.

 Name

This is the name

Name of the relationship. DATATYPE: String.

 NOCHECK

Applies to

Microsoft SQL Server 2005

, SQL Server

and 2008, Teradata v2R6

, Teradata

and 12.0

platforms

only. Determines if the FK constraint is disabled (true)

or enabled (false)

. DATATYPE: Boolean.

 Note

This the note

Note of the relationship. DATATYPE: String.

 NotForReplication

This property specifies if a

Microsoft SQL Server 2000 and later only. Specifies whether an FK constraint is checked for replication.

It applies only to MS SQL Server 2000 or later versions.

DATATYPE: Boolean.

 NoValidate

Applies to

Oracle

platforms

only. Determines

if

whether the FK constraint is NoValidate (true) or Validate (false). DATATYPE: Boolean.

 OptionalityValue

This the

Optionality of the Relationship. 0 = Optional and 1 =

0.

Mandatory

= 1

. DATATYPE: Integer.

 ParentEntity

This is the parent

Parent entity of the relationship.

 ParentKeyID

ID of the relationship's parent index. Zero for this property indicates Primary Key. To set the relationship to use the PK,

please

assign zero. DATATYPE: Integer.

 Type

This is the type

Type of the relationship.

The

Valid relationship types are: 0 = Identifying

- 0

, 1 = NonIdentifying

- 1

, 2 = NonSpecific

- 2

, 3 = NonIdentifying Optional

- 3

, 8 = Containment

- 8

(MongoDB

Only

only). DATATYPE: Integer.

 VerbPhrase

This is the verb

Verb phrase of the relationship. DATATYPE: String.

Info
titleSee Also

...