APIdia Launch Partner
Top Description Inners Methods
io.github.spannm.jackcess

public Interface Relationship

Known Direct Implementers
io.github.spannm.jackcess.impl.RelationshipImpl
Imports
java.util.List

Information about a relationship between two tables in the Database.

Nested and Inner Type Summary

Modifier and TypeClass and Description
public static enum
Relationship.JoinType

The type of join used when this relationship is followed, mirroring Access's own join type options.

Method Summary

Modifier and TypeMethod and Description
public boolean

Returns:

true if deletes of "from" table rows cascade to delete the corresponding "to" table rows (only meaningful if hasReferentialIntegrity is true)
cascadeDeletes
()

Returns true if deletes of "from" table rows cascade to delete the corresponding "to" table rows (only meaningful if hasReferentialIntegrity is true).

public boolean

Returns:

true if deletes of "from" table rows null out the corresponding foreign key in the "to" table rows, rather than deleting them (only meaningful if hasReferentialIntegrity is true)
cascadeNullOnDelete
()

Returns true if deletes of "from" table rows null out the corresponding foreign key in the "to" table rows, rather than deleting them (only meaningful if hasReferentialIntegrity is true).

public boolean

Returns:

true if updates to the "from" table's key are cascaded to the "to" table (only meaningful if hasReferentialIntegrity is true)
cascadeUpdates
()

Returns true if updates to the "from" table's key are cascaded to the "to" table (only meaningful if hasReferentialIntegrity is true).

public List<Column>

Returns:

the columns of getFromTable which participate in this relationship, in the same order as the corresponding columns returned by getToColumns
getFromColumns
()

Returns the columns of getFromTable which participate in this relationship, in the same order as the corresponding columns returned by getToColumns.

public Table

Returns:

the "one" (or referenced) side table of this relationship
getFromTable
()

Returns the "one" (or referenced) side table of this relationship.

public Relationship.JoinType

Returns:

the join type used when this relationship is followed
getJoinType
()

Returns the join type used when this relationship is followed.

public String

Returns:

the name of this relationship
getName
()

Returns the name of this relationship.

public List<Column>

Returns:

the columns of getToTable which participate in this relationship, in the same order as the corresponding columns returned by getFromColumns
getToColumns
()

Returns the columns of getToTable which participate in this relationship, in the same order as the corresponding columns returned by getFromColumns.

public Table

Returns:

the "many" (or referencing) side table of this relationship
getToTable
()

Returns the "many" (or referencing) side table of this relationship.

public boolean

Returns:

true if this relationship enforces referential integrity
hasReferentialIntegrity
()

Returns true if this relationship enforces referential integrity.

public boolean

Returns:

true if this relationship is enforced as a left outer join
isLeftOuterJoin
()

Returns true if this relationship is enforced as a left outer join.

public boolean

Returns:

true if this relationship enforces a one-to-one association, false if one-to-many
isOneToOne
()

Returns true if this relationship enforces a one-to-one association, false if one-to-many.

public boolean

Returns:

true if this relationship is enforced as a right outer join
isRightOuterJoin
()

Returns true if this relationship is enforced as a right outer join.

Method Detail

cascadeDeletesback to summary
public boolean cascadeDeletes()

Returns true if deletes of "from" table rows cascade to delete the corresponding "to" table rows (only meaningful if hasReferentialIntegrity is true).

Returns:boolean

true if deletes of "from" table rows cascade to delete the corresponding "to" table rows (only meaningful if hasReferentialIntegrity is true)

cascadeNullOnDeleteback to summary
public boolean cascadeNullOnDelete()

Returns true if deletes of "from" table rows null out the corresponding foreign key in the "to" table rows, rather than deleting them (only meaningful if hasReferentialIntegrity is true).

Returns:boolean

true if deletes of "from" table rows null out the corresponding foreign key in the "to" table rows, rather than deleting them (only meaningful if hasReferentialIntegrity is true)

cascadeUpdatesback to summary
public boolean cascadeUpdates()

Returns true if updates to the "from" table's key are cascaded to the "to" table (only meaningful if hasReferentialIntegrity is true).

Returns:boolean

true if updates to the "from" table's key are cascaded to the "to" table (only meaningful if hasReferentialIntegrity is true)

getFromColumnsback to summary
public List<Column> getFromColumns()

Returns the columns of getFromTable which participate in this relationship, in the same order as the corresponding columns returned by getToColumns.

Returns:List<Column>

the columns of getFromTable which participate in this relationship, in the same order as the corresponding columns returned by getToColumns

getFromTableback to summary
public Table getFromTable()

Returns the "one" (or referenced) side table of this relationship.

Returns:Table

the "one" (or referenced) side table of this relationship

getJoinTypeback to summary
public Relationship.JoinType getJoinType()

Returns the join type used when this relationship is followed.

Returns:Relationship.JoinType

the join type used when this relationship is followed

getNameback to summary
public String getName()

Returns the name of this relationship.

Returns:String

the name of this relationship

getToColumnsback to summary
public List<Column> getToColumns()

Returns the columns of getToTable which participate in this relationship, in the same order as the corresponding columns returned by getFromColumns.

Returns:List<Column>

the columns of getToTable which participate in this relationship, in the same order as the corresponding columns returned by getFromColumns

getToTableback to summary
public Table getToTable()

Returns the "many" (or referencing) side table of this relationship.

Returns:Table

the "many" (or referencing) side table of this relationship

hasReferentialIntegrityback to summary
public boolean hasReferentialIntegrity()

Returns true if this relationship enforces referential integrity.

Returns:boolean

true if this relationship enforces referential integrity

isLeftOuterJoinback to summary
public boolean isLeftOuterJoin()

Returns true if this relationship is enforced as a left outer join.

Returns:boolean

true if this relationship is enforced as a left outer join

isOneToOneback to summary
public boolean isOneToOne()

Returns true if this relationship enforces a one-to-one association, false if one-to-many.

Returns:boolean

true if this relationship enforces a one-to-one association, false if one-to-many

isRightOuterJoinback to summary
public boolean isRightOuterJoin()

Returns true if this relationship is enforced as a right outer join.

Returns:boolean

true if this relationship is enforced as a right outer join

io.github.spannm.jackcess back to summary

public final Enum Relationship.JoinType

extends Enum<Relationship.JoinType>
Class Inheritance

The type of join used when this relationship is followed, mirroring Access's own join type options.

Field Summary

Modifier and TypeField and Description
public static final Relationship.JoinType
public static final Relationship.JoinType
public static final Relationship.JoinType

Constructor Summary

AccessConstructor and Description
private

Method Summary

Modifier and TypeMethod and Description
public static Relationship.JoinType
public static Relationship.JoinType[]
Inherited from java.lang.Enum:
clonecompareTodescribeConstableequalsfinalizegetDeclaringClasshashCodenameordinaltoStringvalueOf

Field Detail

INNERback to summary
public static final Relationship.JoinType INNER
LEFT_OUTERback to summary
public static final Relationship.JoinType LEFT_OUTER
RIGHT_OUTERback to summary
public static final Relationship.JoinType RIGHT_OUTER

Constructor Detail

JoinTypeback to summary
private JoinType()

Method Detail

valueOfback to summary
public static Relationship.JoinType valueOf(String name)
valuesback to summary
public static Relationship.JoinType[] values()